Page History
...
The following table explains the standard views that are available for most entities in the Objects tab.
Table 6- 1 Standard views in the Objects tab
| 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 following table explains the standard tabs that are available for most entities in the Association area.
Table 6- 2 Standard tabs in the Association area of the Objects tab
| 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 and “About Precise for Oracle tabs” on page 21.
...
You can launch directly to the Tune Objects view of the Objects tab from the following tabs:
Table 6- 3 Direct launch
| Tab | Description |
|---|---|
| Dashboard | From the launch icon for object findings. |
| 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 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.
...
The following table provides an explanation of the information displayed in the Segments table.
Table 6- 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 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. |
...
The following table describes the information displayed in the Overtime tab.
Table 6- 6 Overtime graphs
| Graphs | Description |
|---|---|
| In Oracle | Displays In Oracle resource consumption over time, broken down into In Oracle wait states. |
| 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 table
| Table | Description |
|---|---|
| Access Types | The Access Types table shows the following information on the statement's access types:
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. |
| Statements | The Statements table shows the following information on the statements using the access type you selected in the Access Types table:
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:
|
About the Joins tab
The Joins tab displays information on the tables (and their corresponding statements), that participate in joins with the selected table.
...
The following table describes the information displayed in the Joins tab.
Table 6- 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:
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:
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.
...
The following table describes the information displayed in the Partitions tab.
Table 6- 9 Partitions table
| 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. |
| 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 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.
...
The following table describes the general information displayed in this view.
Table 6-1110 Instance Overview
| 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.
...
The following table describes the table shown in this view.
Table 6-1211 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-1312 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-1413 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-1514 Parameter Changes view
| Column | Description |
|---|---|
| Timestamp | Displays the date the change took place. |
| Parameter | Displays the name of the item changed. |
| 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-1615 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-1716 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 following table describes the table shown in this view.
Table 6-1817 Tablespace and Datafile Changes view
| Column | Description |
|---|---|
| Timestamp | Displays the date the change took place. |
| <blank> | Datafile or Tablespace. |
| 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
The following table describes the table shown in this view.
Table 6-1918 Schema Changes view
| Column | Description |
|---|---|
| Timestamp | Displays the date the change took place. |
| Change Type | Provides a description of the change, for example, Create TABLE CUSTOMER. |
About the Oracle File entity
...
The Overview, in the Objects tab, displays general Oracle file information and several overtime graphs. The following table describes how the general information is structured.
Table 6-2019 Structure of general information for an Oracle file
| Item | Description |
|---|---|
| File Name | Displays the name of the Oracle file. |
| Folder | Displays the Operating System folder where the file is located. |
| Created on | Displays the date the file was created. |
| Status | Displays the status of the file—Online, Offline, Recover, System. |
| Tablespace | Displays the name of the Tablespace supported by the Oracle file. |
| File Type | Indicates whether the file is a datafile, or a temp file. |
The following table describes the overtime graphs for an Oracle file.
Table 6-2120 Overtime graphs for an Oracle file
| Graph | Description |
|---|---|
| Physical I/O Operations | Illustrates the physical reads and physical writes over time. |
| Physical Read Time (Avg.) | Illustrates the average read times. |
| I/O Waits (Sum.) | Illustrates the numbers of I/O waits according to wait state. |
| Physical Write Time (Avg.) | Illustrates the average write times. |
About the RAC Database of an Oracle file
...
The following table describes the information displayed on Oracle files in the RAC Database view.
Table 6-2221 Information displayed on Oracle files in the RAC Database view
| 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 graphs that compare the Oracle file activity of the entire database to the Oracle file activity of the selected instance, over the selected time period:
|
About the dictionary of an Oracle file
The Dictionary view, in the Objects tab, displays the general properties of the Oracle File. The following table describes how the information in the Dictionary view is structured.
Table 6-2322 Structure of information in the Dictionary view
| Item | Description |
|---|---|
| File | Displays the full path of the Oracle file. |
| Name | Displays the name of the Oracle file. |
| Folder | Displays the Operating System folder where the file is located. |
| Tablespace | Displays the name of the Tablespace supported by the Oracle file. |
| File ID | Displays the Oracle ID for the file. |
| File Type | Indicates whether the file is a datafile or temp file. |
| Status | Displays the status of the file—Online, Offline, Recover, System. |
| Autoextension | Indicates whether the file can be autoextended. |
| Created on | Displays the date the file was created. |
| Accessibility | Indicates whether or not the file can be written to: Read Write, or Read Only. |
About storage information related to an Oracle file
The Storage view, in the Objects tab, displays storage information related to the Oracle File. The following table describes how the information in the Storage view is structured.
Table 6-2423 Structure of information in the Storage view
| Item | Description |
|---|---|
| File Size | Displays the current size of the file. |
| Blocks | Displays the number of blocks in the file. |
| Block Size | Displays the block size of the file. |
| Autoextension | Indicates whether or not the file can autoextended. |
| Max. File Size | Displays the maximum size the file can be extended to. |
| Max. Blocks | Displays the maximum number of blocks the file can be extended to. |
| Increment by | Displays the size allocated for further extension when auto-extending. |
Associating an Oracle file with other entities
...
The following table describes how the general information is structured.
Table 6-2524 Structure of general information for a tablespace
| Item | Description |
|---|---|
| Status | Displays the status of the tablespace—online, or offline. |
| Datafiles | Displays the number of datafiles supporting the tablespace. |
| Contents | Indicates whether the tablespace is Temporary or Permanent. |
| Logging | Indicates whether the Tablespace has logging enabled. |
| Extent Management | Indicates whether the tablespace is locally managed or dictionary managed. |
| Allocation Type | Specifies how Oracle manages extents within the Tablespace. Values are System or Uniform. |
| Plugged in | Indicates whether a transportable tablespace is available. |
| Block Size | Displays the underlying block size of the tablespace. |
Additionally a Physical I/O Operations graph is shown.
...
The following table describes the information displayed on tablespaces in the RAC Database view.
Table 6-2625 Information displayed in the RAC Database view for tablespaces
| 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 Database physical I/O operations in the overtime graph. The graph compares the tablespace activity of the entire database to the tablespace activity of the selected instance, over the selected time period. |
About the dictionary of a tablespace
The Dictionary view, in the Objects tab, displays the general properties of the tablespace. The following table describes how the information in the Dictionary view is structured.
Table 6-2726 Structure of information in the Dictionary view
| Item | Description |
|---|---|
| Name | Displays the name of the tablespace. |
| Datafiles | Displays the number of datafiles supporting the tablespace. |
| Status | Displays the status of the tablespace—online, or offline. |
| Contents | Indicates whether the tablespace is Temporary or Permanent. |
| Logging | Indicates whether the tablespace has logging enabled. |
| Extent Management | Indicates whether the tablespace is managed locally or by dictionary. |
| Allocation Type | Specifies how Oracle manages extents within the Tablespace.Values are System, or Uniform. |
| Plugged in | Indicates whether a transportable tablespace is available. |
About storage information related to a tablespace
...
The following table describes how the information in the Storage view is structured.
Table 6-2827 Structure of information in the Storage view
| 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
...
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-2928 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-3029 Overtime graphs for an table
| 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.
...
The following table describes the information displayed on tables in the RAC Database view.
Table 6-3130 Information displayed on tables in the RAC Database view
| 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-3231 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. |
...
The following table describes how the information in the Storage view is structured.
Table 6-3332 Structure of information in the Storage view
| 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. |
...
The following table describes how the information in the Statistics view is structured.
Table 6-3433 Structure of information in the Statistics view
| 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 following table describes how the information in the Changes view is structured.
Table 6-3534 Structure of information in the Changes view
| 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
...
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-3635 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-3736 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.
...
The following table describes the information displayed on indexes in the RAC Database view.
Table 6-3837 Information displayed on indexes in the RAC Database view
| 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-3938 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. |
...
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-4039 Structure of information in the Storage view
| 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. |
...
The following table describes how the information in the Statistics view is structured.
Table 6-4140 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-4241 Structure of the information in the Changes view
| 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
...
The following table describes how the general information is structured.
Table 6-4342 Structure of general information for a column
| 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.
...
The following table describes how the information in the Statistics view is structured.
Table 6-4443 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 following table describes how the information in the Buckets view is structured.
Table 6-4544 Structure of information in the Buckets view
| 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
...
The following table describes how the information in the Workshop view is structured.
Table 6-4645 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
...
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-4746 Structure of general information for a PL/SQL
| 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 following table describes how the general information is structured.
Table 6-4847 Structure of general information for a view
| 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 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.
...
For example, the number of physical reads from all the tables in tablespace XDB has increased over time. This is probably due to index range scans or full table scans that need to return more rows.
...
.
...