[code]</pre>
21:41:18 SYSTEM/bitst/BITST>set lines 10000
21:41:29 SYSTEM/bitst/BITST>column current_size format 999999
21:41:29 SYSTEM/bitst/BITST>column min_size format 9999999
21:41:29 SYSTEM/bitst/BITST>column max_size format 9999999
21:41:29 SYSTEM/bitst/BITST>
21:41:29 SYSTEM/bitst/BITST>select component,current_size/(1024*1024*1024) current_size ,min_size/(1
024*1024*1024) min_size ,max_size/(1024*1024*1024) max_size from v$sga_dynamic_components
21:41:29 2 /
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
—————————————————————- ———— ——– ——–
shared pool 3 3 3
large pool 0 0 0
java pool 0 0 0
streams pool 0 0 0
DEFAULT buffer cache 5 5 5
KEEP buffer cache 0 0 0
RECYCLE buffer cache 0 0 0
DEFAULT 2K buffer cache 0 0 0
DEFAULT 4K buffer cache 0 0 0
DEFAULT 8K buffer cache 0 0 0
DEFAULT 16K buffer cache 0 0 0
COMPONENT CURRENT_SIZE MIN_SIZE MAX_SIZE
—————————————————————- ———— ——– ——–
DEFAULT 32K buffer cache 0 0 0
Shared IO Pool 0 0 0
ASM Buffer Cache 0 0 0
14 rows selected.
<pre>[/code]