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:
SELECT COMPONENT, CURRENT_SIZE, MIN_SIZE,USER_SPECIFIED_SIZE, OPER_COUNT, LAST_OPER_TYPE FROM V$SGA_DYNAMIC_COMPONENTS;
Example:
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|STATIC large pool | 4294967296|4294967296| 4294967296| 0|STATIC java pool | 1073741824|1073741824| 0| 0|STATIC streams pool | 0| 0| 0| 0|STATIC DEFAULT buffer cache | 6.1740E+10|6.1740E+10| 0| 0|STATIC KEEP buffer cache | 0| 0| 0| 0|STATIC RECYCLE buffer cache | 0| 0| 0| 0|STATIC DEFAULT 2K buffer cache | 0| 0| 0| 0|STATIC DEFAULT 4K buffer cache | 0| 0| 0| 0|STATIC DEFAULT 8K buffer cache | 0| 0| 0| 0|STATIC DEFAULT 16K buffer cache | 0| 0| 0| 0|STATIC DEFAULT 32K buffer cache | 0| 0| 0| 0|STATIC Shared IO Pool | 0| 0| 0| 0|STATIC Data Transfer Cache | 0| 0| 0| 0|STATIC In-Memory Area | 0| 0| 0| 0|STATIC ASM Buffer Cache | 0| 0| 0| 0|STATIC SQL>
Amen Answered question 18/04/2023