Search notes:
Oracle: X$KSMLRU
x$ksmlru stores the largest allocations of memory in the
Shared Pool that caused other objects in the shared pool to be flushed out.
It might help to identify what caused a large operation.
The contents of this table are erased when it is selected from.
This table always has eight (?) records although the data of the records is reset to zero when this table is queried.
It is unclear to me, if x$ksmlru lists the eight biggest memory chunks or the eight most recent object since this table was last queried.
select
lru.addr addr,
lru.indx indx,
lru.inst_id inst_id,
lru.con_id con_id,
lru.ksmlridx ksmlridx,
lru.ksmlrdur ksmlrdur,
lru.ksmlrshrpool ksmlrshrpool,
lru.ksmlrcom ksmlrcom,
lru.ksmlrsiz size_of_loaded_object,
lru.ksmlrnum nof_objects_flushed,
lru.ksmlrhon ksmlrhon,
lru.ksmlrohv ksmlrohv,
lru.ksmlrses addr_session, -- Join with x$ksuse
lru.ksmlradu ksmlradu,
lru.ksmlrnid ksmlrnid,
lru.ksmlrnsd ksmlrnsd,
lru.ksmlrncd ksmlrncd,
lru.ksmlrned ksmlrned
from
x$ksmlru lru;