Skip to main content

Posts

Showing posts with the label Check the usage of SGA

Oracle Database Check the usage of SGA

SQL> show sga Total System Global Area 524288000 bytes Fixed Size                  2046008 bytes Variable Size             423626696 bytes Database Buffers           92274688 bytes Redo Buffers                6340608 bytes SQL> show parameter sga_max_size NAME                                 TYPE        VALUE ------------------------------------ ----------- ------------------------------ sga_max_size                         big integer 500M select value/1024/1024 shared_pool_size from v$parameter where name = 'shared_pool_size'; select * From v$sgastat; select 'Memo...