Mega Code Archive

 

Categories / Oracle PLSQL / SQL Plus

 

The SHOW SGA command shows the current allocations of the SGA memory

SQL> SHO SGA Total System Global Area  285212672 bytes Fixed Size    1287016 bytes Variable Size   92277912 bytes Database Buffers  188743680 bytes Redo Buffers    2904064 bytes SQL> / After the first 20 c continue on the seco PL/SQL procedure successfully completed. SQL> SQL> --