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

OBJECT_TYPE_ID

NUMBER

Type identifier

OBJECT_TYPE

VARCHAR2(64)

Type name