Page History
...
Table 6-28 Structure of information in the Storage view
Item Description
...
Item | Description |
---|---|
Datafiles | Displays the number of datafiles supporting the tablespace. |
Total |
...
Space | Displays the total space available in the tablespace. |
Used |
...
Space | Displays the amount of used space in the tablespace. |
Free |
...
Space | Displays the amount of free space in the tablespace. |
Free |
...
Extents | Displays the number of free extents in the tablespace. |
Largest Free |
...
Extent | Displays the size of the largest free extent in the tablespace. |
Initial |
...
Extent | Displays the default size allocated to the first extent when creating a table in the tablespace. |
Next |
...
Extent | Displays the default size allocated to subsequent extents when creating a table in the tablespace. |
Pct. |
...
Increase | Displays the default percentage increase in size on each subsequent extent allocation. |
Min. Extent |
...
Size | Displays the smallest extent size Oracle may use. |
Min. |
...
Extents | Displays the minimum default number of extents allowed for tables within the tablespace. |
Max. |
...
Extents | Displays the maximum default number of extents allowed for tables within the tablespace. |
Associating a tablespace with other entities
You can associate a tablespace in the Main area of the Objects tab with the following entities in the Association area:
...
- Dictionary tab. Displays general properties of the Tablespace.
- Storage tab. Displays storage information related to the tablespace, including used and free space, and extent information.
- Physical I/O tab. Displays a table of total I/O activity against the tablespace, over the selected time period. On this tab, the table contains the following columns:
- File. The name of the file.
- Physical I/O Operations. A bar graph showing the number of physical reads and writes.
- Avg. Read REQ Time (Msec.). Average Average read request time in miliseconds.
- Avg. Write REQ Time (Msec.). Average write request time in miliseconds.
About the Table entity
The Table entity, in the Objects tab, displays general details, storage information, statistical information, and change-related information for the selected table.
...
- Overview
- RAC Database
- Dictionary
- Storage
- Statistics
- Changes
About the overview of a table
The Overview, in the Objects tab, displays general table information and several overtime graphs. The following table describes how the general information is structured.
Table 6-29 Structure of general information for a table
Item |
---|
...
Description |
---|
Created |
...
on | Displays the date the table was created. |
Status |
...
Displays the status of the table—whether it is valid or invalid. |
Partitioned |
...
Indicates whether the table is partitioned. |
Nested |
...
Indicates whether the table is nested. |
Temporary |
...
Indicates whether the table is temporary or permanent. |
Index |
...
Organized | Indicates whether the table is Index Organized. |
Cluster |
...
Indicates whether the table is part of a cluster. |
Tablespace |
...
Displays the tablespace in which the table is created. |
Logging |
...
Indicates whether updates to the table are logged. |
Cache |
...
Indicates whether the table is cached in the buffer cache. |
Rows |
...
Displays the number of rows in the table. |
Last Analyzed |
...
on | Displays the date on which the table was last analyzed. |
The following table describes the overtime graphs for a table.
Table 6-30 Overtime graphs for an tableGraph Description
Graph | Description |
---|---|
In Oracle (Sum.) |
...
Displays the relevant In Oracle wait states. | |
Changes |
...
Displays the changes made over time where each point on the overtime graph represents a separate statistics or schema change. |
Blocks |
...
Displays the number of blocks allocated, split, empty or used. |
...
Rows | Displays the number of rows in the table. |
The changes, blocks and rows data is dependent on the Collect Schema Changes process. Precise for Oracle reports statistical changes when this process is run.
About the RAC Database of a Table
The RAC Database view, in the Objects tab, compares the table activity of the entire RAC database to the table activity of the selected RAC instance. This view shows aggregated wait states, and load balancing and indicates whether only the specific instance is effected by an event, or whether the entire database is effected by the event.
...
Table 6-31 Information displayed on tables in the RAC Database view
Item Description
...
Item | Description |
---|---|
Database | Displays the logical name of the RAC database. |
DB |
...
Name | Displays the Oracle database name. |
DB |
...
ID | Displays the Oracle database ID. |
Instance |
...
Number | Displays the number of the instance in the RAC database. |
...
Instances | Displays the number of instances that share the same RAC database with the selected instance. |
Overtime |
...
graphs | Displays the following overtime graph that compares the table activity of the entire database to the table activity of the selected instance, over the selected time period: |
...
|
...
About the dictionary of a Table
The Dictionary view, in the Objects tab, displays the general properties of the table. The following table describes how the information in the Dictionary view is structured.
Table 6-32 Structure of information in the Dictionary view
Item |
---|
...
Description |
---|
Created |
...
on | Displays the date the table was created. |
Last Modified |
...
on | Displays the date on which the table was last modified. |
Status |
...
Displays the status of the table—whether it is valid, or invalid. |
Cache |
...
Indicates whether the table is cached in the buffer cache. |
Degree |
...
Specifies the degree of parallelism to be used when performing full table scans using parallel query. |
Partitioned |
...
Indicates whether the table is partitioned. |
...
Nested | Indicates whether the table is nested. |
...
Temporary | Indicates whether the table is temporary or permanent. |
Index |
...
Organized | Indicates whether the table is Index Organized. |
cluster |
...
Indicates whether the table is clustered. |
Logging |
...
Contains “Yes” if logging is enabled for all operations or “NO” if minimal logging is enabled whenever applicable. For more information, see Oracle’s documentation. |
Info |
---|
...
If the selected table is partitioned, some of these fields will not be displayed in Precise for Oracle, but they will be displayed in the table partition itself. |
About storage information related to a table
The Storage view, in the Objects tab, displays storage information related to the table, including used and free space, and extent information.
...
Table 6-33 Structure of information in the Storage view
Item Description
...
Item | Description |
---|---|
Table | Name of the table |
...
. | |
Owner | Owner |
...
of the table. |
...
Tablespace | Displays the tablespace where the table is located. |
Segment |
...
Blocks | Displays the number of segment blocks in the table |
...
. | |
Extents | Displays |
...
the number of extents in the table. |
Initial |
...
Extent | Displays the size allocated to the first extent when the table was created. |
Next |
...
Extent | Displays the size allocated when the table size is not sufficient. |
Pct. |
...
Increase | Displays the default percentage increase in size on each subsequent extent allocation. |
Pct. |
...
Used | Displays the percentage of used space in each data block. |
Pct. |
...
Free | Displays the percentage of space reserved in each data block for updates. |
Min. |
...
Extents | Displays the minimum number of extents allowed. |
Max. |
...
Extents | Displays the maximum number of extents allowed. |
Init. Trans. |
...
Displays the initial number of transaction slots in each block. | |
Max. Trans. |
...
Displays the maximum number of transaction slots in each block. | |
Free |
...
Lists | Displays the number of free lists. |
Type |
...
Displays Type of the object. |
Table |
...
# | Displays table id as shown in Oracle dictionary. |
Info |
---|
...
If the selected table is partitioned, some of these fields are not displayed in Precise for Oracle, but they will be displayed in the table partition itself. |
About the statistics of a table
The Statistics view, in the Objects tab, displays statistics on the table. This information is generated by the Oracle statistics collection mechanism.
...
Table 6-34 Structure of information in the Statistics view
Item Description
...
Item | Description |
---|---|
Rows | Indicates the number of rows. |
Chained |
...
Rows | Indicates the number of chained rows. |
Row Length (Avg.) |
...
Indicates the average row length. | |
Recent |
...
Growth | Indicates the growth of the table (in blocks) since the previous statistics collection and from the |
...
Collect Schema Changes process. |
Last Analyzed |
...
on | Displays the date of the last analysis. |
Empty |
...
Blocks | Displays the number of empty blocks. |
Non-empty |
...
Blocks | Displays the number of non-empty blocks. |
Free |
...
space per Block (Avg.) |
...
Displays the average amount of free space per block. |
About table-related changes
The Changes view, in the Objects tab, displays details of the changes that were made to the table and the indexes defined on the table.
...
Table 6-35 Structure of information in the Changes view
Column Description
...
Column | Description |
---|---|
Timestamp | Displays the date the change took place. |
Change |
...
Type | Displays a description of the change. For example: EMPLOYEE.DENSITY modified from 0.00201 to 0.00203. |
Associating a table with other entities
You can associate a table in the Main area of the Objects tab with the following entities in the Association area:
...
- Dictionary tab. Displays data dictionary information for the selected table.
- Storage tab. Displays storage information for the selected table.
- Statistics tab. Displays the statistics for the table, generated by the Oracle statistics collection mechanism
About the Index and Unused Index entities
The Index entity, in the Objects tab, displays general details, storage information, Oracle statistics information, and change-related information for the selected index or unused index.
...
- Overview
- RAC Database
- Dictionary
- Storage
- Statistics
- Changes
About the overview of an index
The Overview, in the Objects tab, displays general index information and several overtime graphs. The following table describes how the general information is structured.
Table 6-36 Structure of general information for an index
Item |
---|
...
Description |
---|
Created |
...
on | Displays the creation date of the index. |
Status |
...
Displays the status of the index—indicates whether it is valid, or invalid. |
Type |
...
Displays the type of index—Normal or Bitmap. |
Unique |
...
Indicates whether the key values are unique. |
Partitioned |
...
Indicates whether the index is partitioned. |
Table |
...
Displays the name of the table that the selected index is referring to. |
Owner |
...
Displays the Oracle user that owns the index. |
Distinct |
...
Keys | Displays the number of distinct values in the index. |
Clustering |
...
Factor | Displays the clustering factor of the index. The clustering factor is an important factor in determining how efficiently an index range scan will retrieve data from the table. It measures the degree to which the data in the index and its table are in the same order or, put another way, the probability that the next row to be fetched from the table is in the same block as the current row. It can vary between the number of blocks in the table (the best case because they are in the same order) and the number of rows in the table (the worst case because they are completely out of sync). The clustering factor tends to become worse over time as data is inserted and deleted. Note that the clustering factor makes no difference for a unique index lookup. |
Leaf |
...
Blocks | Displays the number of blocks at the lowest index level. |
B- |
...
Levels | Displays the number of levels above the leaf blocks in the index (indicates the depth of the index). |
Last Analyzed |
...
on | Displays the date when the index was last analyzed. |
The following table describes the overtime graphs for a table.
Table 6-37 Overtime graphs for a table
Graph |
---|
...
Description |
---|
In Oracle (Sum.) |
...
Displays the relevant In Oracle wait states. | |
Changes |
...
Displays the number of changes that took place. |
Distinct |
...
Keys | Displays the number of distinct keys in the index. |
Clustering |
...
Factor | Displays the clustering factor of the index. |
The changes, distinct keys, and clustering factor data is dependent on the Collect Schema Changes process. Precise for Oracle reports statistical changes when this process is run.
About the RAC Database of an index
The RAC Database view, in the Objects tab, compares the index activity of the entire RAC database to the index activity of the selected RAC instance. This view shows aggregated wait states, and load balancing and indicates whether only the specific instance is effected by an event, or whether the entire database is effected by the event.
...
Table 6-38 Information displayed on indexes in the RAC Database view
Item Description
...
Item | Description |
---|---|
Database | Displays the logical name of the RAC database. |
DB |
...
Name | Displays the Oracle database name. |
DB |
...
ID | Displays the Oracle database ID. |
Instance |
...
Number | Displays the number of the instance in the RAC database. |
Instances |
...
Displays the number of instances that share the same RAC database with the selected instance. |
Overtime |
...
Graphs | Displays the In Oracle (Sum.) overtime graph. The graph compares the index or unused index activity of the entire database, to the index or unused index activity of the selected instance, over the selected time period |
...
. |
About the dictionary of an index
The Dictionary view, in the Objects tab, displays the general properties of the index. The following table describes how the information in the Dictionary view is structured.
Table 6-39 Structure of information in the Dictionary view
Item |
---|
...
Description |
---|
Created |
...
on | Displays the creation date of the index. |
Last Modified |
...
on | Displays the date on which the index was last modified. |
Status |
...
Displays the status of the index (valid or invalid). |
Table |
...
Displays the name of the table that the selected index is referring to. |
Owner |
...
Displays the Oracle user that owns the index. |
Type |
...
Displays the type of index—Normal, Bitmap. |
Unique |
...
Indicates whether the key values are unique. |
Partitioned |
...
Indicates whether the index is partitioned. |
Compression |
...
Indicates whether the index has been defined with the COMPRESSES attribute. |
Logging |
...
Indicates whether updates to the index are logged. |
Columns |
...
Displays the number of columns in the index. |
Info |
---|
...
If the selected index or unused index is partitioned, some of these fields will not be displayed in Precise for Oracle, but they will be displayed in the index partition itself. |
About storage information related to an index
The Storage view, in the Objects tab, displays storage information related to the index. The following table describes how the information in the Storage view is structured.
Table 6-40 Structure of information in the Storage view
Item Description
...
Item | Description |
---|---|
Tablespace | Displays the Tablespace in which the index is located. |
Blocks |
...
Displays the number of blocks in the index. |
Extents |
...
Displays the number of extents in the index. |
Initial |
...
Extent | Displays the size allocated to the first extent when the index was created. |
Logging |
...
Indicates whether updates to the index are logged. |
Compression |
...
Indicates whether the index has been defined with the COMPRESSES attribute. |
Table |
...
Displays the name of the table that the selected index is referring to. |
Owner |
...
Displays the Oracle user that owns the index. |
Info |
---|
...
If the selected index or unused index is partitioned, some of these fields will not be displayed, but they will be displayed in the index partition itself. |
About the statistics of an index
The Statistics view, in the Objects tab, displays statistics that are related to the index and generated by the Oracle statistics collection mechanism.
...
Table 6-41 Structure of information in the Statistics view
Item |
---|
...
Description |
---|
Distinct |
...
Keys | Displays the number of distinct values in the index. |
Clustering |
...
Factor | Displays the clustering factor of the index. The clustering factor is an important factor in determining how efficiently an index range scan will retrieve data from the table. It measures the degree to which the data in the index and its table are in the same order or, put another way, the probability that the next row to be fetched from the table is in the same block as the current row. It can vary between the number of blocks in the table (the best case because they are in the same order) and the number of rows in the table (the worst case because they are completely out of sync). The clustering factor tends to become worse over time as data is inserted and deleted. Note that the clustering factor makes no difference for a unique index lookup. |
Leaf |
...
Blocks | Displays the number of blocks at the lowest index level. |
Leaf Blocks per |
...
Key | Displays the average number of leaf blocks in which each distinct key value appears. There must be at least one leaf block for a unique key. |
Data Blocks per |
...
Key | Displays the average number of data blocks in which each distinct key value appears. There must be at least one leaf block for a unique key. |
B- |
...
levels | Displays the number of levels above the leaf blocks in the index (indicates the depth of the index). |
Last Analyzed |
...
on | Displays the date when the index was last analyzed. |
About changes to indexes
The Changes view, in the Objects tab, displays details of the changes made to the index. The following table describes how the information in the Storage view is structured.
Table 6-42 Structure of the information in the Changes view
Column Description
...
Column | Description |
---|---|
Timestamp | Displays the date of the change. |
Change |
...
Type | Displays a description of the change. For example, EMP_DEPT_FK.DISTINCT_KEYS modified from 25 to 30. |
Associating an index with other entities
You can associate an index in the Main area of the Objects tab with the following entities in the Association area:
...
The information in the Association area is displayed on the following tabs:
- Columns tab. Displays information about the columns that make up the index.
- Name. Displays the name of the index.
- Owner. Displays the Oracle user that owns the index.
- Columns. Displays the number of columns that make up the index.
- Column List. Displays the names of the columns that make up the index.
- Dictionary tab. Displays data dictionary information for the selected index, similar to that described in the Main area.
- Storage tab. Displays storage information for the selected index, similar to that described in the Main area.
- Statistics tab. Ddisplays statistics related to the index, as generated by the Oracle statistics collection mechanism.
- Index. Displays the name of the index.
- Owner. Displays the Oracle user that owns the index.
- Distinct keys. Displays the number of distinct values in the index.
- Clustering Factor. Displays the clustering factor of the index. The clustering factor is an important factor in determining how efficiently an index range scan will retrieve data from the table. It measures the degree to which the data in the index and its table are in the same order or, put another way, the probability that the next row to be fetched from the table is in the same block as the current row. It can vary between the number of blocks in the table (the best case because they are in the same order) and the number of rows in the table (the worst case because they are completely out of sync). The clustering factor tends to become worse over time as data is inserted and deleted. Note that the clustering factor makes no difference for a unique index lookup.
- Leaf Blocks. Displays the number of blocks at the lowest index level.
- Leaf Blocks per Key. Displays the average number of leaf blocks in which each distinct key value appears. There must be at least one leaf block for a unique key.
- Data Blocks per Key. Displays the average number of data blocks in which each distinct key value appears. There must be at least one leaf block for a unique key.
- B-Levels. Displays the number of levels above the leaf blocks in the index (indicates the depth of the index).
- Last Analyzed on. Displays the date when the index was last analyzed.
About the Column entity
The Column entity, in the Objects tab, displays general details and Oracle analysis statistics for the selected column. The following views are available:
- Overview
- Statistics
- Buckets
About the overview of a column
The Overview, in the Objects tab, displays general column information and three overtime graphs that show the variation in the number of distinct values, the number of nulls, and the density. Density is the proportion of selective values divided by the number of distinct selective values. For uniformly distributed data, this equates to one over the number of distinct values.
...
Table 6-43 Structure of general information for a column
Item Description
...
Item | Description |
---|---|
Table | Displays the name of the table to which the column belongs. |
Owner |
...
Displays the Oracle-owning user. |
Position |
...
Displays the numeric position of the column within the table. |
Predefined |
...
Type | Indicates whether the column is a predefined data type. |
Type |
...
Displays the data type of the column. |
Length |
...
Displays the length of the column. |
Nullable |
...
Indicates whether the column is allowed to hold null values. |
Default |
...
Value | Displays a default value for the column, if any. |
Additionally the Distinct Values, Null Values, and Density graphs are shown.
About the statistics of a column
The Statistics view, in the Objects tab, displays statistics related to the column and generated by the Oracle statistics collection mechanism.
...
Table 6-44 Structure of information in the Statistics view
Item |
---|
...
Description |
---|
Value (Min.) |
...
Displays the lowest value for the column. | |
Value (Max.) |
...
Displays the highest value for the column. | |
Distinct |
...
values | Displays the number of different values. |
Null |
...
values | Displays the number of nulls. |
Density |
...
Displays the proportion of selective values divided by the number of distinct selective values. For uniformly distributed data this equates to one over the number of distinct values. |
Time |
...
Displays the date of the analyses. |
Sample |
...
Size | Displays the number of rows sampled. |
Length (Avg.) |
...
Displays the average length of the column. |
About the buckets of a column
The Buckets view, in the Objects tab, displays the distribution of column data in the Oracle statistics that were gathered. This information is typically generated for indexed columns with skewed data by running a statistics collection.
...
Table 6-45 Structure of information in the Buckets view
Column Description
...
Column | Description |
---|---|
Bucket | The divisions of the Oracle statistics histograms. |
Bucket |
...
Limit | The data value at the upper limit of each bucket. |
Associating a column with other entities
You can associate a column in the Main area of the Objects tab with the following entities in the Association area:
...
The information in the Association area table is displayed on the following tabs:
- Dictionary tab. Displays data dictionary properties of the column similar to those displayed in the Main area overview.
- Statistics tab. Displays statistics on the column, as generated by the Oracle statistics collection mechanism.
- Usage tab. Displays information on how the column has been accessed within explain plans.
- Column. Displays the name of the column.
- References. Displays the total of the counts displayed in the columns that followed, viewed as a numeric figure or bar chart.
- As Indexable. Displays the number of times a column could have been used as part of an index.
- In Select. Displays the number of times a column appeared in a Select clause.
- In Where. Displays the number of times a column appeared in a Where clause.
- In Update. Displays the number of times a column appeared in an Update clause.
- In Join. Displays the number of times a column appeared in a Join predicate.
- In Aggregate. Displays the number of times a column appeared in an Aggregate function.
- In Distinct. Displays the number of times a column appeared in a Distinct clause.
- In Order. Displays the number of times a column appeared in a Sort by clause.
- In Group. Displays the number of times a column appeared in Group by clause.
- Position. Displays the numeric position of the column within the entities.
About the Statement entity
The Statement entity, in the Objects tab, displays activity information, In Oracle performance, the text of the statement, and the storage location for the selected statement.
...
- In Oracle
- Overall activity
- Text
- Workshop
About In Oracle information for a statement
The In Oracle view, in the Objects tab, displays an overtime graph of the In Oracle wait states. See “Wait States” on page 35.
About the overall activity of a statement
The Overall Activity view, in the Objects tab, displays a graph that illustrates the statement's overall activity over the selected time period. See “Wait States” on page 35.
About the text of a statement
The Text view, in the Objects tab, displays the full SQL text of the selected statement.
About information on the cabinet or folder related to a statement
The Workshop view, in the Objects tab, displays details on the cabinet or folder where the statement or PL/SQL is saved and on how it will be explained.
In general, if you prefer that a statement be referenced by a user-defined name in all tabs, rather than by a numeric identifier, you can save it to a particular cabinet or folder and assign a name to it. If required, you can also edit it later or add a tuning comment. See “Editing the properties of a statement” on page 31 . See and “About Precise for Oracle tabs” on page 21.
...
Table 6-46 Structure of information in the Workshop view
Item |
---|
...
Description |
---|
Explained |
...
on | Displays the date on the which the statement was last explained. |
...
Optimizer Mode | Displays the Oracle optimizer mode. |
Cost |
...
Displays the optimizer cost. |
Parsing |
...
User | Displays the Oracle user that the explain plan is generated for. |
Cabinet |
...
Displays the cabinet where the statement is stored. |
Folder |
...
Displays the folder within the cabinet where the statement is stored. |
Origin |
...
Indicates where the statement originated from, for example, automatically collected. |
Saved |
...
on | Displays the date statement was saved. |
Comment |
...
Displays a textual comment associated with the statement. |
About associating a statement with other entities
You can associate a statement in the Main area of the Objects tab with the following entities in the Association area:
...
The information in the Association area table is displayed on the following tabs:
- General tab. Displays the statement name and a portion of the SQL. You can also click on the tuning icon to launch the SQL tab to further your analysis.
- Workshop tab. Displays similar information to the information displayed in the Workshop view in the Main area. It is possible to associate from a Statement to the Tables, Indexes, and Views that it accesses.
About the PL/SQL entity
The PL/SQL entity, in the Objects tab, displays general details and the text of the selected PL/SQL. The following views are available:
- Overview
- Text
About the overview of a PL/SQL
The Overview, in the Objects tab, displays general information on the selected PL/SQL. The following table describes how the general information is structured.
Table 6-47 Structure of general information for a PL/SQL
Item Description
...
Item | Description |
---|---|
Name | Displays the name of the PL/SQL. |
Owner |
...
Displays the Oracle user to which the PL/SQL belongs. |
Type |
...
Displays the type of PL/SQL. Possible values are:
|
Created |
...
on | Displays the date on which the PL/SQL was created. |
Last Modified |
...
on | Displays the date on which the PL/SQL was last updated. |
Status |
...
Displays the status of the PL/SQL (valid or invalid). |
About the text of a PL/SQL
The Text view, in the Objects tab, displays the full text of the selected PL/SQL.
Associating a PL/SQL with other entities
You can associate a PL/SQL in the Main area of the Objects tab with the following entities in the Association area:
...
You can display additional entities by using the More... option.
About the View entity
The View entity, in the Objects tab, displays general details and the text for the selected view. The following views are available:
- Overview
- Text
About the overview of a view
The Overview, in the Objects tab, displays general information on the selected view.
...
Table 6-48 Structure of general information for a view
Item Description
...
Item | Description |
---|---|
Name | Displays the name of the view. |
Owner |
...
Displays the Oracle user to which the view belongs. |
Created |
...
on | Displays the date on which the view was created. |
Last Modified |
...
on | Displays the date on which the view was last updated. |
...
Type | View |
Status | Displays |
Type View
...
the status of the view—whether it is valid or invalid. |
Object |
...
ID | Displays the unique Oracle object ID for the view. |
About the text of a view
The Text view, in the Objects tab, displays the full text of the selected view.
Associating a view with other entities
You can associate a view in the Main area of the Objects tab with the following entities in the Association area:
...
You can display additional entities by using the More... option.
About the Attribute entity
The Attribute entity, in the Objects tab, displays general information (Overview) that is retrieved from the data dictionary.
Associating an attribute with other entities
You can associate an attribute, in the Objects tab, with the following entities:
...
You can display additional entities by using the More... option.
About the Cluster entity
The Cluster entity, in the Objects tab, displays information from the data dictionary (Overview and Storage view) and lists the schema changes that have been made to the cluster during the selected time period (Schema Changes view).
Associating a cluster with other entities
You an associate a cluster in the Objects tab with the following entities:
...
The information in the Association area table is displayed on the following tabs:
- Dictionary tab. Displays data dictionary information for the associated clusters, such as status, cache, creation date and when they were last modified.
- Storage tab. Display storage information related to the associated clusters, such as tablespace, initial extent and next extent, and percent increased, used and free.
About the Constraint entity
The Constraint entity, in the Objects tab, displays general information that is retrieved from the data dictionary.
Associating a constraint with other entities
You can associate a constraint with the following entities:
...
You can display additional entities by using the More... option.
About the Index Partition and Index Sub-Partition entities
When an index partition (or index sub-partition) is displayed in the Main area of the Objects tab, the Overview and the Storage view are available. Both views display information from the data dictionary.
Associating an index partition or sub-partition with other entities
You can associate an index partition or sub-partition in the Main area of the Objects tab with the following entities in the Association area:
...
The information in the Association area table is displayed on the following tabs:
- Dictionary tab. Displays information from the data dictionary.
- Storage tab. Displays information from the data dictionary.
- Statistics tab. Displays Oracle analysis statistics.
About the Indextype entity
When an indextype is displayed in the Main area of the Objects tab, the Overview provides general information from the data dictionary.
About associating an indextype with other entities
You can associate an indextype in the Main area of the Objects tab with User Defined Types and PL/SQLs. You can display additional entities by using the More... option.
About the LOB entity
When an LOB is displayed in the Main area of the Objects tab, the Overview provides general information from the data dictionary.
About associating an LOB with other entities
You can associate an LOB in the Main area of the Objects tab with the table that it belongs to. You can display additional entities by using the More... option.
The information in the Association area is displayed on the Dictionary and Storage tabs. Both display information from the data dictionary.
About the Materialized View entity
When a materialized view is displayed in the Main area of the Objects tab, it shows general information from the data dictionary (Overview) and the definition of the materialized view (Text view).
Associating a materialized view with other entities
You can associate a materialized view in the Main area of the Objects tab with its related tables, views, and nested materialized views. You can display additional entities by using the More... option.
The information in the Association area is displayed on the Dictionary tab, which shows information from the data dictionary, and the Text tab, which shows the view's definition.
About the Method entity
When a method is displayed in the Main area of the Objects tab, it shows general information from the data dictionary (Overview) and the definition of the method (Text view).
Associating a method with other entities
You can associate a method in the Main area of the Objects tab with its return type, that is, a user-defined type. You can display additional entities by using the More... option.
About the Rollback entity
When a rollback is displayed in the Main area of the Objects tab, the following views are available:
- Overview. Displaying information from the data dictionary.
- Statistics. Displays information relating to the Oracle analysis statistics.
- Rollback Wait Graph. Displays a graphical view of the rollback wait activity. You cannot drill down from an imported statement to other entities.
When the rollback is selected in the Association area, information is displayed on the following tabs:
- Details. Displays the same information as the Overview in the Main area.
- Statistics. Displays Oracle analysis statistics; lists only rollback segments with an online status.
You can display additional entities by using the More... option.
About the Sequence entity
When a sequence is displayed in the Main area of the Objects tab, the Overview provides general information from the data dictionary.
Associating a sequence with other entities
You can associate a sequence in the Main area of the Objects tab with PL/SQLs or other objects that use it, for example triggers and synonyms. You can display additional entities by using the More... option.
About the Synonym entity
When a synonym is displayed in the Main area of the Objects tab, the Overview displays general information from the data dictionary.
When a synonym is displayed in the Association area, it displays data dictionary information.
Associating a synonym with other entities
You can associate a synonym in the Main area of the Objects tab with its referenced object. You can display additional entities by using the More... option.
About the Table Partition and Table Sub-Partition entities
When a table partition or sub-partition is displayed in the Main area of the Objects tab, the Overview and the Storage view are available. Both views display information from the data dictionary.
When a table partition or table sub-partition is displayed in the Association area, information is displayed on the following tabs:
- Dictionary. Displays data dictionary information.
- Storage. Displays data dictionary information.
- Statistics. Displays Oracle analysis statistics.
...
You can display additional entities by using the More... option.
About the Trigger entity
When a trigger is displayed in the Main area of the Objects tab, the following views are available:
- Overview. Displays information from the data dictionary.
- Text. Displays the trigger definition.
- SchemaChanges. Displays changes that have been made to the trigger during the selected time period.
When a trigger is displayed in the Association area, it displays data dictionary information.
Associating a trigger with other entities
You can associate a trigger in the Main area of the Objects tab with the table or view that the trigger is defined for. You can display additional entities by using the More... option.
About the User entity
When a user is displayed in the Main area of the Objects tab, the Overview displays general information from the data dictionary.
When a user is displayed in the Association area, it displays data dictionary information.
Associating a user with other entities
You can associate a user in the Main area of the Objects tab with the tables, indexes, or views owned by the user, or with the statements that the user has executed. You can display additional entities by using the More... option.
About the User-Defined Type entity
When a user-defined type is displayed in the Main area of the Objects tab, the following views are available:
- Overview. Displays information from the data dictionary.
- Text. Displays a definition of the user defined type.
When a user-defined type is displayed in the Association area, it displays data dictionary information.
Associating a user-defined type with other entities
You can associate a user-defined type in the Main area of the Objects tab with attributes of that type, its own attributes and methods, and the objects where it is declared. You can display additional entities by using the More... option.
About the EMC Unit entity
This entity is only available, on the Objects tab, if you have installed Precise for Database & Storage. For more information on the supported platforms, see the Precise Installation Guide. For more information on the Storage Device entity, see “Storage Device entities” on page 123.
...
To determine if a unit is used by the selected instance, check the Used by Instance
check box in the Association area. For more information on counters that are related to the current instance, drill down to the device level in either the Objects or Activity tabs.
...
- Overview
- Performance
- Load
- Throughput
About the overview of an EMC unit
The Overview, in the Objects tab, displays general information on the Symmetrix unit, such as ID, model, and number of physical disks.
About the performance of an EMC unit
The Performance view, in the Objects tab, displays two overtime graphs that illustrate the following information:
- The number of sequential reads and the total number of read and write requests during the selected time period.
- The read, write, and overall cache hit ratios over the same time period.
About the load of an EMC unit
The Load view, in the Objects tab, displays an overtime graph that illustrates the megabytes of data read and written during the selected time period.
About the throughput of an EMC unit
The Throughput view, in the Objects tab, displays an overtime graph that illustrates the I/O rate (requests per second) and the throughput (megabytes per second) over the selected time period.
Associating an EMC unit with other entities
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.
...
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:
Anchor | ||||
---|---|---|---|---|
|
INIT.ORA parameters can help you when tuning a statement, object or instance in the Objects tab. To examine INIT.ORA parameters
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance list, choose the instance you want to view.
- In the Main area, observe the Init Parameters view.
Anchor | ||||
---|---|---|---|---|
|
You can observe information on the schema changes in the Objects tab, by selecting an instance and the Schema Changes view.
...
- In the Time Frame list, choose the period of time you want to analyze.
- In the Instance list, choose the instance you want to analyze.
- On the View controls in the Main area, click Schema Changes to open a view for that instance.
- Now take a look at the Tablespaces entities, to understand how objects grow over time and what effect their growth has on performance. For example, the Objects tab shows storage information on tablespaces in Instance ora920, including the used and free space. Clicking a tablespace reveals details of an individual tablespace.
...