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
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