Database Memory & 4030/4031 (MOSC)

MOSC Banner

Oracle auto- tuning or self tuning

edited Mar 12, 2013 11:00PM in Database Memory & 4030/4031 (MOSC) 2 commentsAnswered ✓
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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center