Hello,
how can I identify objects that are freeable from the SQL AREA namespace? is it only possible with querying x$ksmsp or is there a view with a column already?
select * from V$LIBRARY_CACHE_MEMORY ;
LC_NAMESPACE LC_INUSE_MEMORY_OBJECTS LC_INUSE_MEMORY_SIZE LC_FREEABLE_MEMORY_OBJECTS LC_FREEABLE_MEMORY_SIZE CON_ID
--------------- ----------------------- -------------------- -------------------------- ----------------------- ----------
BODY 2 0 55 8 0
CLUSTER 0 0 0 0 0
INDEX 0 0 0 0 0
JAVA DATA 0 0 0 0 0
JAVA RESOURCE 0 0 0 0 0
JAVA SOURCE 0 0 0 0 0
OBJECT 0 0 0 0 0
OTHER/SYSTEM 0 0 0 0 0
PIPE 0 0 0 0 0
SQL AREA 13984 107 70558 3466 0
TABLE/PROCEDURE 215 0 1268 23 0
TRIGGER 0 0 0 0 0
select inst_id, namespace, sum(SHARABLE_MEM/1024/1024) from gv$db_object_cache group by namespace,inst_id having sum(SHARABLE_MEM/1024/1024)>1000 order by 3 asc ;
INST_ID NAMESPACE SUM(SHARABLE_MEM/1024/1024)
---------- ---------------------------------------- ---------------------------
2 SQL AREA 3681.78602
1 SQL AREA 3800.08973
Thank you