4.29 DBA_ADVISOR_OBJECT_TYPES
DBA_ADVISOR_OBJECT_TYPES
displays information about the object types used by all advisors in the database.
In addition to the regular database object types (such as TABLE
and INDEX
), the following types are defined:
-
SYSTEM
-
I/O
-
SGA
-
PGA
-
SHARED POOL
-
BUFFER CACHE
-
LIBRARY CACHE
-
PROCESS
-
SESSION
-
ENQUEUE
-
LATCH
-
ROLLBACK SEGMENT
-
FILE
-
PARAMETER
-
CURSOR
-
SQL
-
SQL WORKLOAD
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Type identifier |
|
|
|
Type name |