00041.Oracle 内存缓冲区信息获取

SQL> show sga

Total System GlobalArea  835104768 bytes

Fixed Size                  2217952 bytes

Variable Size             629147680 bytes

DatabaseBuffers          197132288 bytes

Redo Buffers                6606848 bytes

SQL> col namefor a20

SQL> col valuefor a20

SQL> set line120

SQL> select  name,type,value from v$parameter where name ='sga_max_size';

 

NAME                       TYPE VALUE

------------------------------ --------------------

sga_max_size                  6 8388608000