檢視當前系統程式

SQL> select name,pga_used_mem,pga_used_mem,pga_alloc_mem from v$bgprocess b,v$process p where b.paddr=p.addr;

NAME  PGA_USED_MEM PGA_USED_MEM PGA_ALLOC_MEM                                  
----- ------------ ------------ -------------                                  
PMON        437890       437890        716366                                  
VKTM        437078       437078        716366                                  
DIAG        433902       433902        716366                                  
DBRM        510242       510242        781902                                  
PSP0        437078       437078        716366                                  
DSKM       4663670      4663670       9629262                                  
LGWR       4663670      4663670       9629262                                  
DIA0        455858       455858        699338                                  
MMAN        437078       437078        716366                                  
DBW0       2211446      2211446       2363106                                  
CKPT        480946       480946       1002818                                  

NAME  PGA_USED_MEM PGA_USED_MEM PGA_ALLOC_MEM                                  
----- ------------ ------------ -------------                                  
SMON        792534       792534       1109582                                  
RECO        577650       577650        912974                                  
MMON       1798722      1798722       2468810                                  
MMNL        438150       438150        716366                                  
ARC0       4639554      4639554       9760334                                  
ARC1       4639554      4639554       9760334                                  
ARC2       4639554      4639554       9760334                                  
ARC3       4697766      4697766       9760334                                  
FBDA       1073734      1073734       1813450                                  
SMCO        433722       433722        716366                                  
QMNC        506734       506734        781902                                  

已選擇22行。

SQL> spool off