How to Check Shared Memory Usage in Oracle? DBA scripts to Check Shared Memory Usage in Oracle?
Amen Answered question 18/04/2023
DBA scripts to check the Free Memory of all SGA pools:
1 2 3 4 5 6 7 8 | SQL> SELECT * FROM v$sgastat WHERE name = 'free memory';Press Return to Continue POOL |NAME | BYTES| CON_ID------------|-----------------------------------|----------|----------shared pool |free memory |2269549760| 0large pool |free memory |4080599024| 0java pool |free memory |1073741824| 0SQL> |
And to check the Free memory of shared pool:
1 2 3 4 5 6 | SQL> select pool,name,bytes from v$sgastat where name='free memory' and pool='shared pool';Press Return to Continue POOL |NAME | BYTES------------|-----------------------------------|----------shared pool |free memory |2271877880SQL> |
Amen Answered question 18/04/2023