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 AI Database 26ai.