SQL> select program,status from v$session where type='BACKGROUND';
PROGRAM STATUS
---------------------------------------------------------------- --------
ORACLE.EXE (CJQ0) ACTIVE
ORACLE.EXE (q001) ACTIVE
ORACLE.EXE (q000) ACTIVE
ORACLE.EXE (QMNC) ACTIVE
ORACLE.EXE (W000) ACTIVE
ORACLE.EXE (SMCO) ACTIVE
ORACLE.EXE (FBDA) ACTIVE
ORACLE.EXE (ARC4) ACTIVE
ORACLE.EXE (ARC3) ACTIVE
ORACLE.EXE (ARC2) ACTIVE
ORACLE.EXE (ARC1) ACTIVE
PROGRAM STATUS
---------------------------------------------------------------- --------
ORACLE.EXE (ARC0) ACTIVE
ORACLE.EXE (MMNL) ACTIVE
ORACLE.EXE (MMON) ACTIVE
ORACLE.EXE (RECO) ACTIVE
ORACLE.EXE (SMON) ACTIVE
ORACLE.EXE (CKPT) ACTIVE
ORACLE.EXE (LGWR) ACTIVE
ORACLE.EXE (DBW0) ACTIVE
ORACLE.EXE (MMAN) ACTIVE
ORACLE.EXE (DIA0) ACTIVE
ORACLE.EXE (PSP0) ACTIVE
PROGRAM STATUS
---------------------------------------------------------------- --------
ORACLE.EXE (DBRM) ACTIVE
ORACLE.EXE (DIAG) ACTIVE
ORACLE.EXE (VKTM) ACTIVE
ORACLE.EXE (PMON) ACTIVE
已选择26行。