SGA library cache hit ratio usage
Hi all,
DB ver: 12.1.0.2 Std Edition
OS type : Red hat linux 6
I captured DB memory related components as below;
MB_TOTAL_DB
-----------
884422
1.0 Info about SGA size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sga_max_size big integer 28864M
sga_target big integer 28864M
unified_audit_sga_queue_size integer 1048576
2.0 Info about PGA size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_limit big integer 19206M
pga_aggregate_target big integer 9603M
3.0 Info about Memory size
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
hi_shared_memory_address integer 0
inmemory_clause_default string
inmemory_force string DEFAULT
inmemory_max_populate_servers integer 0