Tuesday, January 29, 2013

Instance Memory Usage


Instance Memory Usage:
set linesize 100
set pagesize 50
col component format a35
col size_mb format 999,999
select component,
       current_size/1024/1024 size_mb
  from v$memory_dynamic_components
 order by current_size desc
/
!free
exit
/

Sample Output:
COMPONENT                            SIZE_MB
----------------------------------- --------
SGA Target                            92,160
DEFAULT buffer cache                  85,504
PGA Target                            30,720
shared pool                            5,376
streams pool                             256
java pool                                256
large pool                               256
RECYCLE buffer cache                       0
DEFAULT 2K buffer cache                    0
DEFAULT 4K buffer cache                    0
DEFAULT 8K buffer cache                    0
KEEP buffer cache                          0
DEFAULT 32K buffer cache                   0
Shared IO Pool                             0
ASM Buffer Cache                           0
DEFAULT 16K buffer cache                   0

16 rows selected.

No comments:

Post a Comment