Page History
This section includes the following topics:
- About the Objects tab
- How the Objects tab is structured
- About Objects tab entities
- How the Objects tab can help you identify performance problems
| Anchor | ||||
|---|---|---|---|---|
|
It is important to understand the relationship between database objects and statements to make sound and well-founded tuning decisions.
The Objects tab is a comprehensive browser that lets you understand the relationships and associations between database schema objects. It also provides further understanding into the relationships between data dictionary components and the statements that access them. This information lets you identify the statements that will be affected by changes to a database object, and the schema relationship impacts that are associated with an object change. The Objects tab also lets you observe storage utilization, over time and at varying levels, such as double-space, table, index, and Oracle file.
...
Because Precise for Oracle tracks changes in the database objects, the effect of schema changes on performance can be easily observed.
...
| Info |
|---|
...
This section provides a general description of how to use the Objects tab in your analysis of Oracle objects. For further information on a specific Oracle object, see Oracle's relevant documentation. |
| Anchor |
|---|
...
|
...
|
...
The Objects tab consists of two different views: Explore Objects and Tune Objects.
The Explore Objects view displays information on a selected entity and its associated entities. The selected parent entity is always reflected in the Tab heading, which serves as a point of orientation. The highest-level entity you can view information for in the Objects tab is Instance. You can choose another instance from the Instance selector.
The Tune Objects view displays performance and usage information per table or index, based on new and existing data sources.
About the Explore Objects view
When you open the Objects tab from the Activity tab (and the selected entity is Statement, Table, Index, Oracle File or Storage Device) or the SQL tab (Table, Index or Column) you launch to the tab in context, and information on the entity you selected is displayed. In all other circumstances the settings from your last visit to the Objects tab are retained. This is similar to clicking the History button and returning to a previous tab.
Although a large number of entities can be displayed in the Objects tab, they nearly all share the same set of Main Area views and Associations.
About the Main area in the Explore Objects view
The Main area, in the Objects tab, shows comprehensive information on the selected entity. You can choose from several views to examine the entity from different angles. For example, you can focus exclusively on Instance Parameters, or Instance Parameters Changes.
The following table explains the standard views that are available for most entities in the Objects tab.
Table 6-1 Standard 1 Standard views in the Objects tab
...
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.
...
You can associate an EMC unit in the Main area of the Objects tab with the disk directors, front end directors, remote directors, and devices configured for the unit. You can display additional entities by using the More... option.
| Anchor | ||||
|---|---|---|---|---|
|
The Objects tab helps you understand the relationship between database objects and statements. You can identify a performance problem by doing one or more of the following:
...