V$SHARED_POOL_LRU

10.55 V$SHARED_POOL_LRU_EFFORT

V$SHARED_POOL_LRU_EFFORT displays information about shared pool LRU scans.

This view allows you to determine the amount of time spent scanning the shared pool LRU in an effort to free up space.

Column	Datatype	Description
`DSIDX`	`NUMBER`	Shared pool subpool to which this data pertains
`SECONDS_AGO`	`NUMBER`	Number of seconds that have elapsed since this scan row was performed
`MS_SPENT`	`NUMBER`	Number of milliseconds spent performing the scan
`REQUEST_SIZE`	`NUMBER`	Size of the memory request
`REQ_COMMENT`	`VARCHAR2(20)`	Comment for the chunk being requested
`BYTES_FREED`	`NUMBER`	Number of bytes freed to satisfy this request
`OBJECTS_FREED`	`NUMBER`	Number of objects evicted to satisfy this request
`RETURN_ZERO`	`NUMBER`	Number of times an eviction request was rejected
`RETURN_ZERO_COMMENT`	`VARCHAR2(20)`	Comment for the first `RETURN_ZERO` object
`LATCH_SKIPPED`	`NUMBER`	Number of times an object was skipped because of an incompatible latch
`TIMESTAMP`	`NUMBER`	Time at which the scan was performed
`SID`	`NUMBER`	ID of the session that requested the scan
`REPORT_TIME`	`NUMBER`	Time at which the report was run You can compare to this column to the `TIMESTAMP` column.
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. 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

Note:

This view is available starting with Oracle Database 23ai.