1. 显示SGA
SQL> show sga
Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 92276304 bytes
Database Buffers 188743680 bytes
Redo Buffers 2973696 bytes
2. 现实SGA中各个内存的大小
SQL> select * from v$sgainfo;
NAME BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size 1218992 No
Redo Buffers 2973696 No
Buffer Cache Size 188743680 Yes
Shared Pool Size 83886080 Yes
Large Pool Size 4194304 Yes
Java Pool Size 4194304 Yes
Streams Pool Size 0 Yes
Granule Size 4194304 No
Maximum SGA Size 285212672 No
Startup overhead in Shared Pool 37748736 No
Free SGA Memory Available 0
3. 查看数据库正在使用的后台进程
SQL> select paddr, name, description
2 from v$bgprocess
3 where paddr <> '00';
PADDR NAME DESCRIPTION
-------- ----- ----------------------------------------------------------------
30E16830 PMON process cleanup
30E16DE4 PSP0 process spawner 0
30E17398 MMAN Memory Manager
30E1794C DBW0 db writer process 0
30E17F00 LGWR Redo etc.
30E184B4 CKPT checkpoint
30E18A68 SMON System Monitor Process
30E1901C RECO distributed recovery
30E195D0 CJQ0 Job Queue Coordinator
30E1B808 QMNC AQ Coordinator
30E19B84 MMON Manageability Monitor Process
30E1A138 MMNL Manageability Monitor Process 2
4.