Page History
...
Column | Description |
---|---|
Switches to the Plan view and displays the first access plan that was created by the Explain Statements process after the specified change was detected. | |
If the object that was changed is one of the entities in the Objects tab (table, view, index, or column), this icon will launch the Objects tab with the selected object in context. Also, if the change type is Access Plan Changed, the icon will launch the Compare view with the specified access plan compared to the last access path, as detected by the Explain Statements process. | |
Timestamp | Indicates the date that the change was detected. |
Change Type | Displays the type of change detected. Can be one of the following values:
|
Object |
...
Indicates the object that was changed, such as table or index. |
Change |
...
Details | Displays information about the change that was made. For example, if the Change Type is |
...
Different Execution Plan, the Change Details column gives the estimated cost. |
About schema changes
The Schema Changes view displays a list of all schema type changes made.
...
Table 8-13 Schema Changes table
Column Description
...
Column | Description |
---|---|
Switches to the Plan view and displays the first access plan that was created by the Explain Statements process after the specified change was detected. | |
...
If the object that was changed is one of the entities in the Objects tab (table, view, index, or column), this icon will launch the Objects tab with the selected object in context. |
Timestamp |
...
Indicates the date the change was detected. |
Change |
...
Type | Displays the type of change detected. It can be one of the following values: |
...
|
...
|
...
|
...
|
...
|
...
|
...
Object | Indicates the object that was changed, such as table or index. |
Columns |
...
Indicates the columns in the object that were affected by the change. |
About statistics changes
The Statistics Changes view displays a list of changes made to Oracle statistics on tables, indexes, and columns. The following table describes the information displayed in the Statistics Changes table.
Table 8-14 Statistics Changes table
Column Description
...
Column | Description |
---|---|
Switches to the Plan view and displays the first access plan that was created by the Explain Statements process after the specified change was detected. | |
...
Launches the Objects tab with the selected instance. |
...
Timestamp | Indicates the date the change was detected. |
...
Object | Indicates the object that was changed, such as table or index. |
Type |
...
Displays the type of object, such as table or index. |
...
Rows | A change in the number of rows. |
Non-Empty |
...
Blocks | A change in the number of non-empty blocks. |
Free Space (Avg.) A change in the average free space in a block.
...