DBA_HIST_SHARED_POOL_ADVICE

DBA_HIST_SHARED_POOL_ADVICE displays historical information about estimated parse time in the shared pool for different pool sizes. This view contains snapshots of V$SHARED_POOL_ADVICE.


Column Datatype NULL Description

SNAP_ID

NUMBER

NOT NULL

Unique snapshot ID

DBID

NUMBER

NOT NULL

Database ID for the snapshot

INSTANCE_NUMBER

NUMBER

NOT NULL

Instance number for the snapshot

SHARED_POOL_SIZE_FOR_ESTIMATE

NUMBER

NOT NULL

Shared pool size for the estimate (in megabytes)

SHARED_POOL_SIZE_FACTOR

NUMBER

 

Size factor with respect to the current shared pool size

ESTD_LC_SIZE

NUMBER

 

Estimated memory in use by the library cache (in megabytes)

ESTD_LC_MEMORY_OBJECTS

NUMBER

 

Estimated number of library cache memory objects in the shared pool of the specified size

ESTD_LC_TIME_SAVED

NUMBER

 

Estimated elapsed parse time saved (in seconds), owing to library cache memory objects being found in a shared pool of the specified size. This is the time that would have been spent in reloading the required objects in the shared pool had they been aged out due to insufficient amount of available free memory.

ESTD_LC_TIME_SAVED_FACTOR

NUMBER

 

Estimated parse time saved factor with respect to the current shared pool size

ESTD_LC_LOAD_TIME

NUMBER

 

Estimated elapsed time (in seconds) for parsing in a shared pool of the specified size.

ESTD_LC_LOAD_TIME_FACTOR

NUMBER

 

Estimated load time factor with respect to the current shared pool size

ESTD_LC_MEMORY_OBJECT_HITS

NUMBER

 

Estimated number of times a library cache memory object was found in a shared pool of the specified size

CON_DBID

NUMBER

 

The database ID of the PDB for the sampled session

CON_ID

NUMBER

 

The ID of the container that CON_DBID identifies. Possible values include:

  • 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.

  • 1: This value is used for rows containing data that pertain to only the root

  • n: Where n is the applicable container ID for the rows containing data


See Also:

"V$SHARED_POOL_ADVICE"