|
aix下果然不一样:
SQL> select b.name,p.program,p.spid from v$session s,v$bgprocess b,v$process p
2 where b.paddr=p.addr
3 and p.addr=s.paddr;
NAME PROGRAM SPID
----- ------------------------------------------------ ------------
PMON oracle@data (PMON) 389336
DBW0 oracle@data (DBW0) 356590
LGWR oracle@data (LGWR) 221308
CKPT oracle@data (CKPT) 340154
SMON oracle@data (SMON) 413900
RECO oracle@data (RECO) 417998
CJQ0 oracle@data (CJQ0) 422096
QMN0 oracle@data (QMN0) 520192
8 rows selected. |
|