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
