How to Check SGA Component Status in Oracle? DBA scripts to Check SGA Component Status in Oracle?
Amen Answered question 18/04/2023
We can check the SGA component status using the following SQL statement:
1 | SELECT COMPONENT, CURRENT_SIZE, MIN_SIZE,USER_SPECIFIED_SIZE, OPER_COUNT, LAST_OPER_TYPE FROM V$SGA_DYNAMIC_COMPONENTS; |
Example:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | SQL> SELECT COMPONENT, CURRENT_SIZE, MIN_SIZE,USER_SPECIFIED_SIZE, OPER_COUNT, LAST_OPER_TYPE FROM V$SGA_DYNAMIC_COMPONENTS;Press Return to Continue COMPONENT |CURRENT_SIZE| MIN_SIZE|USER_SPECIFIED_SIZE|OPER_COUNT|LAST_OPER_TYP-----------------------------------|------------|----------|-------------------|----------|-------------shared pool | 7784628224|7784628224| 0| 0|STATIClarge pool | 4294967296|4294967296| 4294967296| 0|STATICjava pool | 1073741824|1073741824| 0| 0|STATICstreams pool | 0| 0| 0| 0|STATICDEFAULT buffer cache | 6.1740E+10|6.1740E+10| 0| 0|STATICKEEP buffer cache | 0| 0| 0| 0|STATICRECYCLE buffer cache | 0| 0| 0| 0|STATICDEFAULT 2K buffer cache | 0| 0| 0| 0|STATICDEFAULT 4K buffer cache | 0| 0| 0| 0|STATICDEFAULT 8K buffer cache | 0| 0| 0| 0|STATICDEFAULT 16K buffer cache | 0| 0| 0| 0|STATICDEFAULT 32K buffer cache | 0| 0| 0| 0|STATICShared IO Pool | 0| 0| 0| 0|STATICData Transfer Cache | 0| 0| 0| 0|STATICIn-Memory Area | 0| 0| 0| 0|STATICASM Buffer Cache | 0| 0| 0| 0|STATICSQL> |
Amen Answered question 18/04/2023