Oracle auto- tuning or self tuning
Hello,I have oracle :
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
installed in SPARC-Enterprise-T5120
How to know if
-My database is auto-tuning or self tuning in Memory.
-If AMM is enable at my Configuration
SQL> set pagesize 50
SQL> col COMPONENT format a30
SQL> select COMPONENT,CURRENT_SIZE from V$MEMORY_DYNAMIC_COMPONENTS;
COMPONENT CURRENT_SIZE
------------------------------ ------------
shared pool 889192448
large pool 16777216
java pool 100663296
streams pool 33554432
SGA Target 6442450944
DEFAULT buffer cache 5351931904
KEEP buffer cache 0
RECYCLE buffer cache 0
DEFAULT 2K buffer cache 0
DEFAULT 4K buffer cache 0
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
PL/SQL Release 11.2.0.2.0 - Production
CORE 11.2.0.2.0 Production
TNS for Solaris: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production
installed in SPARC-Enterprise-T5120
How to know if
-My database is auto-tuning or self tuning in Memory.
-If AMM is enable at my Configuration
SQL> set pagesize 50
SQL> col COMPONENT format a30
SQL> select COMPONENT,CURRENT_SIZE from V$MEMORY_DYNAMIC_COMPONENTS;
COMPONENT CURRENT_SIZE
------------------------------ ------------
shared pool 889192448
large pool 16777216
java pool 100663296
streams pool 33554432
SGA Target 6442450944
DEFAULT buffer cache 5351931904
KEEP buffer cache 0
RECYCLE buffer cache 0
DEFAULT 2K buffer cache 0
DEFAULT 4K buffer cache 0
0