Monday, September 15, 2008

SGA close look?

SQL> select * from x$ksmsd;

ADDR INDX INST_ID KSMSDNAM KSMSDVAL
---------------- ---------- ---------- -------------------- ----------
000000006000C1D0 0 1 Fixed Size 2144824
000000006000C1F0 1 1 Variable Size 687867336
000000006000C210 2 1 Database Buffers 905969664
000000006000C230 3 1 Redo Buffers 7430144

SQL> show sga

Total System Global Area 1603411968 bytes
Fixed Size 2144824 bytes
Variable Size 687867336 bytes
Database Buffers 905969664 bytes
Redo Buffers 7430144 bytes

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home