v$session.status
STATUS |
VARCHAR2(8) |
Status of the session:
|
v$process.background
BACKGROUND |
VARCHAR2(1) |
1 for a background process; NULL for a normal process |
null --》 客户端server 进程 ，及一些salve 进程（S000，D000，J000，P000）
P000 -->parallel query slaves
D000 -->dispatchers
S000 --> shared servers
J000 -->job queue slave processes