SGA
Da wiki.gienne.cloud.
SQL> SHOW SGA Total System Global Area 638670568 bytes Fixed Size 456424 bytes Variable Size 503316480 bytes Database Buffers 134217728 bytes Redo Buffers 679936 bytes
SQL> SELECT * FROM v$sga; NAME VALUE -------------------- ---------- Fixed Size 456424 Variable Size 503316480 Database Buffers 134217728 Redo Buffers 679936
SQL> select * from v$sgainfo; NAME BYTES RESIZEABLE -------------------------------- ---------------------- ---------- Fixed SGA Size 2109352 No Redo Buffers 13533184 No Buffer Cache Size 3103784960 Yes Shared Pool Size 822083584 Yes Large Pool Size 67108864 Yes Java Pool Size 134217728 Yes Streams Pool Size 134217728 Yes Shared IO Pool Size 0 Yes Granule Size 16777216 No Maximum SGA Size 4277059584 No Startup overhead in Shared Pool 251658240 No Free SGA Memory Available 0
