The SHOW SGA command shows the current allocations of the SGA memory. : SGA « SQL Plus « Oracle PL / SQL

1. Oracle PL / SQL
2. SQL Plus
3. SGA

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>

--

 

Related examples in the same category