Page History
...
Table 6-1 Standard views in the Objects tab
View Description
...
| View | Description |
|---|---|
| Overview | Usually the first view that is displayed. The Overview shows general properties of the entity that can be found in the Oracle data dictionary, such as DBA_OBJECTS, and DBA_TABLES, and also provides graphs that can assist you in analyzing changes in objects. |
| RAC Database | RAC |
...
| allows multiple instances on different nodes to access a shared database on a cluster system. This allows multiple servers to share the load. The RAC Database view is only displayed for RAC instances. |
| Storage |
...
| This view displays current storage information for objects such as information on extents. |
| Changes |
...
The changes displayed by this view are represented differently depending on whether they occurred on the instance level or on the table or index level, as follows: |
...
|
...
|
...
|
...
|
...
| Statistics | This view displays statistics generated by the Oracle statistics collection mechanism (for example, distinct values for a column, or number of rows for a table). If you are using the COST or CHOOSE database optimizer modes, it is important that the statistics are accurate and up-to-date. |
...
About the Association area in the Explore Objects view
The Association area, in the Objects tab, provides corresponding information on the entities that are related to or can be associated with the selected entity (the entity displayed in the Tab heading). You can view information on one type of associated entity at a time, such as Statements or Tablespaces, by selecting an entity from the Association Controls list. The selection you make is reflected in the Association area only; the Main area remains unchanged. For some entities, tabs above the Association area enable you to view additional information. Clicking a tab changes the columns of the table displayed for the associated entities.
...
The following table explains the standard tabs that are available for most entities in the Association area.
Table 6-2 Standard 2 Standard tabs in the Association area of the Objects tab
Tab Description
...
| Tab | Description |
|---|---|
| dictionary | Displays Oracle data dictionary information that can be found in DBA_OBJECTS, DBA_TABLES, etc. This information is then generally displayed in the Overview in the Main area when the entity is selected. |
| Storage |
...
| Displays extent information similar to that found in DBA_SEGMENTS. This information is then generally displayed in the Storage view in the Main area when the entity is selected. |
...
| Statistics | Displays some statistics generated by Oracle statistics collection mechanism (for example, distinct values for a column, or number of rows for a table). If you are using the COST or CHOOSE database optimizer modes, it is important that the statistics are accurate and up-to-date. You may want to sort by the Last Analyzed On date or use the Filter dialog to search for entities whose Last Analyzed On date is before a certain date. |
...
| Usage | Displays a breakdown of the different ways in which an object such as a table, index or column has been accessed within explain plans—for example the number of full table scans or index range scans. This information is only available for statements that have been explained. It can help you determine if your indexing strategy is working effectively. You may want to sort tables by the number of Full Scans or use the More feature to find tables that have been Accessed via Full Scan and have a large number of rows or blocks. The Access columns are specific to a type of object but they all share a References column. This represents the total of all individual usages, and provides an overall view of the usage of a particular object. |
See “About Objects tab entities” on page 95 .See and “About Precise for Oracle tabs” on page 21.
About the Tune Objects view
You can launch directly to the Tune Objects view of the Objects tab from the following tabs:
Table 6-3 Direct 3 Direct launch
| Tab |
|---|
...
| Description |
|---|
...
| Dashboard |
...
| From the launch icon for object findings. |
Table 6-3 Direct launch
Tab Description
...
| Activity | From the Association area, by clicking on the launch entity, or when clicking on the Objects workstation button when an Object entity is displayed in the Main area. |
| Objects |
...
| From the launch icon for an active object. |
| SQL |
...
| From the launch icon in the Objects tab, when tables and indexes are selected. |
The The Main area of the Tune Objects view displays information on the table you drilled down to and its indexes. You can also directly open a table by using the Open option.
Selecting a table to tune
You can select a table to tune by using the Open option. To open a table for tuning1 On
- On the Tune Objects tab in the Objects tab, click Open.
...
- In the Open Table dialog box, in the Instance drop-down list, select the instance related to the table you want to tune.
...
- In the Owner drop-down list, select the owner of the table you want to tune.
...
- In the Table drop-down list, select the name of the table you want to tune.
...
- Click Ok.
...
...
About the Main area in the Tune Objects view
The segment table, located in the upper left corner of the Main area of the Objects tab, displays information on the selected table and its corresponding indexes. Additional tabs (Details, Partitions, and Columns), located in the lower left corner, provide additional information on the selected table. You can view this information by clicking the + sign to expand the view.
The following table provides an explanation of the information displayed in the Segments table.
Table 6-4 Segments 4 Segments table
| Column |
|---|
...
| Description |
|---|
| Segment |
...
| icon | Icon indicating whether a segment is a table or an index. |
| Name |
...
| Displays the name of the segment. |
| In Oracle (Sum.) |
...
| Displays a breakdown of the total waits that contributed to the In Oracle time for the object. | |
| Logical |
...
| Reads | Summarizes the logical reads made on the object. |
| Physical I/ |
...
| Os | Summarizes the direct physical reads, direct physical writes, physical reads, and physical writes made on the object. |
...
| Statements | Displays the number of statements that accessed the table within the selected time frame. |
| Hit |
...
| Ratio | Displays the cache hit ration of the selected object. |
| Index |
...
| Columns | When the selected object is an index, displays the names of the index columns. |
The Details area displays relevant data dictionary information for the selected index, table or segments. The Columns area shows information on the columns of the selected tables or index.
The following table describes the information displayed in the Dictionary and Columns areas.
Table 6-5 Information 5 Information displayed in the Dictionary and Columns area
| Selection |
|---|
...
| Dictionary |
|---|
...
| Columns |
|---|
| All |
...
| Segments | Rows, Degree, Last analyzed on, Chained |
...
| rows | Column, Type, Distinct values, Nullable, Position in partition |
| Tables |
...
| Rows, Degree, Pct free, Last analyzed on, Chained rows, Partitioned, Number of partitions, Partition type, Partition columns, Number of subpartitions, Subpartition type, Subpartition |
...
| columns | Column, Type, Distinct values, Nullable, Position in partition |
| Indexes |
...
| Number of columns, Distinct keys, Leaf blocks, B-levels, Clustering factor, Columns Last analyzed on, Pct free, Partitioned, Locality, Partition type, Partition columns, Number of subpartitions, Subpartition type, Subpartition |
...
| columns | Column, Type, Distinct values, Nullable, Position in index, Position in partition |
...
| Info |
|---|
...
You can launch with the selected row of the Segments table in context to the Active Objects association in the |
...
Explore Objects view by clicking the Dictionary links. |
About the Details area in the Tune Objects view
The Details area, in the Objects tab, is divided into the following tabs:
- Highlights
...
- Overtime
...
- Statements
■ Overtime
■ Statements
■ Joins
■ Partitions
- Joins
- Partitions
About the Highlights tab
The Highlights tab shows the statement access type distribution for the segment, indicating how the segment was accessed. The Findings table displays information on problematic objects and provides links to the appropriate tabs where you can continue your analysis or tune the object. It displays the percentage of time the object spends in the Oracle database, with respect to the amount of time spent by all segments in the Oracle database.
...
If you want to continue your examination of a particular finding, click on the launch icon to launch to the appropriate tab with the selected finding in context.
About the Overtime tab
The Overtime tab shows the segment's I/O wait distribution, by read/writes, over time and the segment changes that took place during the selected time period.
The following table describes the information displayed in the Overtime tab.
Table 6-6 Overtime 6 Overtime graphs
| Graphs |
|---|
...
| Description |
|---|
| In |
...
| Oracle | Displays In Oracle resource consumption over time, broken down into In Oracle wait states. |
Table 6-6 Overtime graphs
Graphs Description
...
| Changes | Shows at which point in time database block changes occurred, and the space allocated to the segment by the data dictionary, on the DB Block Changes axis. Additional points on the graph indicate whether or not Statistics (analyze operations performed on the segment) or Schema Changes (structural changes made to the object) occurred at that point in time. This information helps you identify the impacts of a statistics or schema change on a database object. |
| Physical I/O vs. Logical |
...
| Reads | Summarizes physical I/O (includes physical reads direct, physical writes and physical writes direct) vs. logical reads on the selected segment, over time. |
...
About the Statements tab
The Statements tab shows the statement access type distribution for the segment, indicating how the segment was accessed. Each table is populated according to the row you select in the table above it. The Statements table will show information on the accessing statements using the access type you selected in the Access Types table. The Columns table provides information on how columns are being used in the statement.
The following table describes the information displayed in the Statement tab.
Table 6-7 Statement 7 Statement table
| Table |
|---|
...
| Description |
|---|
| Access |
...
| Types | The Access Types table shows the following information on the statement's access types: |
...
|
...
|
...
|
...
|
...
|
...
|
■ Statements
|
...
If you want to continue your examination of a particular access type, click on the launch icon to launch to the |
...
Activity tab with the selected access type in context. |
Table 6-7 Statement table
Table Description
...
| Statements | The Statements table shows the following information on the statements using the access type you selected in the Access Types table: |
■ Text
|
...
|
...
|
...
|
...
|
...
|
...
|
■ Executions
|
...
|
...
|
■ Statement
|
■ Programs
|
...
|
...
|
...
If you want to continue your examination of a particular statement, click on the launch icon to launch to the |
...
Activity tab with the selected statement in context. |
| Columns |
...
The Columns table shows the following information on the statement you selected in the Statements table: |
■ Column
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
|
...
About the Joins tab
The Joins tab displays information on the tables (and their corresponding statements), that participate in joins with the selected table.
| Info |
|---|
...
This tab is only displayed if a table is selected in the Segments table in the Main area. |
...
...
The following table describes the information displayed in the Joins tab.
Table 6-8 Joins 8 Joins Tables
| Table |
|---|
...
| Description |
|---|
...
| Tables |
...
The Tables table shows the following information on the tables that are joined with the selected segment, segments, or object: |
■ Name
|
■ Owner
|
...
|
...
|
...
|
...
|
...
|
...
If you want to continue your examination of a particular join table, click on the launch icon to launch to the Tune Object view with the selected join table in context. |
...
| Statements | The Statements table shows the following information on the statements in which both the selected segment or object, and the selected table appear: |
■ Text
|
...
|
...
|
...
|
...
|
■ Columns
|
■ Statement
|
...
If you want to continue your examination of a particular statement, click on the launch icon to launch to the Activity tab with the selected statement in context. |
About the Partitions tab
The Partitions tab displays partition details for the selected segment or object.
...
| Info |
|---|
...
This tab is only displayed if the object or segment you selected in the Segments table is partitioned. |
...
The following table describes the information displayed in the Partitions tab.
Table 6-9 Partitions 9 Partitions table
Column Description
...
| Column | Description |
|---|---|
| Partition | Displays the name of the segment partition. |
...
| Deleted | Indicates whether or not the partition was deleted. |
| In Oracle (Sum.) |
...
| Displays a breakdown of the total waits that contributed to the In Oracle time for the selected partition. | |
| Logical |
...
| Reads | Summarizes the logical reads made on the selected partition. |
...
...
Table 6-9 Partitions table
Column Description
| Physical I/ |
...
| Os | Summarizes the direct physical reads, direct physical writes, physical reads, and physical writes made on the selected partition. |
| Segment |
...
| Displays the name of the segment owning the partition. |
| Blocks |
...
| Displays the segment size in blocks. |
| Tablespace |
...
| Displays the name of the tablespace in which the partition resides. |
| Buffer |
...
| Pool | Displays the name of the buffer pool in which the partition resides. |
If If you want to continue your examination of a particular partition, click on the launch icon to launch to the Activity tab with the selected partition in context.
| Anchor | ||||
|---|---|---|---|---|
|
The Objects tab displays information on many different entities. This section provides an overview of all these entities, their meaning, and their views.
In the Objects tab, you can examine the following entities:
Table 6-10 Entities
Entity Entity
...
- Instance entity
- Oracle File entity
- Tablespace entity
- Table entity
- Index and unused index entities
- Column entity
- Statement entity
- PL/SQL entity
- Object entity
- View entity
- Attribute entity
- Cluster entity
- Constraint entity
- Index Partition and Index Sub-Partition entities
...
- Index-type entity
...
- LOB entity
...
- Materialized View entity
...
- Method entity
...
- Rollback entity
...
- Sequence entity
...
- Synonym entity
...
- Table Partition and Table Sub-Partition entities
...
- Trigger entity
...
- User entity
...
- User-defined type entity
...
Some entities are related to storage devices and are only available if you install the EMC Symmetrix and Clariion or HP SureStore versions of Precise for Storage. The Objects tab lets you see details for all the storage arrays connected to the server where the currently selected instance is running. You can then drill down inside an array and see details of its components. The performance counters are available for all devices and not just for those devices used by the selected instance. This gives you a view of the overall performance of the arrays and lets you identify less busy devices that you can move your Oracle files to.
The following entities are only available if you have installed Precise for Storage:
...
- EMC Units
...
- Disk director entity
...
- Port entity
...
- Hyper entity
...
- HP Storage Device entity
For more information on the supported platforms, see the Precise Installation Guide.
About the Instance entity
The Instance entity, in the Objects tab, shows object-related information on the instance level. The following views are available:
■ Overview
■ Init parameters
■ Database options
■ Database option changes
■ Parameter changes
■ Redo log changes
■ Rollback segment changes
■ Tablespace and datafile changes
...
- Overview
- Init parameters
- Database options
- Database option changes
- Parameter changes
- Redo log changes
- Rollback segment changes
- Tablespace and datafile changes
- Schema changes
It is possible to associate from an instance to Active Objects and to the Users and Tablespaces defined in the instance, and to the Oracle Files that make up the instance. You can display additional entities by using the More... option.
About the overview of instance-related objects
The Overview displays general instance information and an overtime graph that illustrates the time (Sum.) that the instance spent In Oracle during the selected time period.
The following table describes the general information displayed in this view.
Table 6-11 Instance 11 Instance Overview
Column Description
...
| Column | Description |
|---|---|
| Version | Displays which version of Oracle software is being used. |
| Parallel |
...
| Indicates whether the instance is part of an OPS or RAC cluster. |
| Status |
...
| Displays the status of the instance. |
| Database |
...
| Status | Displays the status of the entire database, in relation to the cluster. |
| Archiver |
...
| Status | Displays the status of the database log archiver. |
| Up |
...
| Time | Displays how long the database has been up. |
...
Additionally Logical Reads and Space Allocation graphs are shown.
About init parameters for an instance
The Init Parameters view displays all Oracle initialization or INIT.ORA parameters.
The following table describes the table shown in this view.
Table 6-12 Init 12 Init Parameters view
| Column |
|---|
...
| Description |
|---|
...
| Parameter |
...
| Displays the Parameter Name. |
| Values |
...
| Displays the Current Value. |
| Is |
...
| Default | Indicates whether the value displayed is the default value. |
| Is Session |
...
| Modifiable | Indicates whether this parameter can be changed to take effect according to session. |
| Is System |
...
| Modifiable | Indicates whether this parameter can be changed to take effect across the entire instance. |
| Is |
...
| Modified | Indicates whether the parameter has been modified after instance startup. |
| Is |
...
| Adjusted | Indicates whether Oracle adjusted the input value to a more suitable value. |
...
| Description | Provides a description of the parameter. |
...
About database options
The Database Options view displays the available database options. The following table describes the table shown in this view.
Table 6-13 Database 13 Database Options view
| Column |
|---|
...
| Description |
|---|
...
| Option |
...
| Displays the name of the database option. |
| Is |
...
| Enabled | Displays a True or False value indicating whether or not the option is enabled. |
...
About examining changes to database options
The Database Options Changes view displays the changes made to database options during the selected time period. The following table describes the table shown in this view.
Table 6-14 Database 14 Database Options Changes view
| Column |
|---|
...
| Description |
|---|
...
| Timestamp |
...
| Displays the date the change took place. |
| Component |
...
| Displays the name of the item changed. |
| Old |
...
| Value | Displays the old value of the component. |
| New |
...
| Value | Displays the new value of the component. |
...
About parameter changes
The Parameter Changes view displays the changes to the database initialization parameters during the selected time period.
The following table describes the table shown in this view.
Table 6-15 Parameter 15 Parameter Changes view
Column Description
...
| Column | Description |
|---|---|
| Timestamp | Displays the date the change took place. |
| Parameter |
...
| Displays the name of the item changed. |
Table 6-15 Parameter Changes view
Column Description
...
| Old Value | Displays the old value of the parameter. |
| New |
...
| Value | Displays the new value of the parameter. |
...
About changes to the redo logs
The Redo Log Changes view displays the changes to the redo logs during the selected time period. The following table describes the table shown in this view.
Table 6-16 Redo 16 Redo Log Changes view
| Column |
|---|
...
| Description |
|---|
...
| Timestamp |
...
| Displays the date the change took place. |
| Redo |
...
| Log | Displays the name of the redo log that was changed. |
| Change |
...
| Type | Displays the type of change that took place. |
...
| Field | Displays the type of change that took place—created, deleted or field changed. |
| Old |
...
| Value | Displays the old value of the parameter. |
| New |
...
| Value | Displays the new value of the parameter. |
...
About changes to rollback segments
The Rollback Segment Changes view displays the changes to rollback segments during the selected time period. The following table describes the table shown in this view.
Table 6-17 Rollback 17 Rollback Segment Changes view
| Column |
|---|
...
| Description |
|---|
...
| Timestamp |
...
| Displays the date the change took place. |
...
| Owner | Displays the Oracle user that owns the rollback segment. |
| Rollback |
...
| Segment | Displays the name of the rollback segment that was changed. |
| Change |
...
| Type | Displays the type of change that took place. |
...
| Field | Displays the type of change that took place—created, deleted or field changed. |
| Old |
...
| Value | Displays the old value of the parameter. |
| New |
...
| Value | Displays the new value of the parameter. |
...
About changes to tablespaces and datafiles
The Tablespace and Datafile Changes view displays the changes to tablespaces and datafiles during the selected time period.
The following table describes the table shown in this view.
Table 6-18 Tablespace 18 Tablespace and Datafile Changes view
| Column |
|---|
...
| Description |
|---|
...
| Timestamp |
...
| Displays the date the change took place. |
...
| <blank> | Datafile or Tablespace. |
Table 6-18 Tablespace and Datafile Changes view
Column Description
...
| Name | The name of the datafile or tablespace that was changed. |
| Change |
...
| Type | Indicates the type of change that took place—created, deleted or field changed. |
| Field |
...
| Displays which item was changed. |
| Old |
...
| Value | Displays the old value of the parameter. |
| New |
...
| Value | Displays the new value of the parameter. |
...
About schema changes
The Schema Changes view displays the changes made to schema objects, such as tables and indexes, during the selected time period, but expressed as DDL. For example: DROP INDEX or ALTER TABLE
...