| v$session | x$ksuse |
|
|
|
|
|
|
|
|
|
|
|
| |||||||||
|
|
s.inst_id |
| ||||||||
| SADDR | s.addr |
| ||||||||
| SID | s.indx |
| ||||||||
| SERIAL# | s.ksuseser |
| ||||||||
| AUDSID | s.ksuudses |
| ||||||||
| PADDR | s.ksusepro |
| ||||||||
| USER# | s.ksuudlui |
| ||||||||
| USERNAME | s.ksuudlna |
| ||||||||
| COMMAND | s.ksuudoct |
| ||||||||
| OWNERID | s.ksusesow |
| ||||||||
| TADDR | decode(s.ksusetrn,hextoraw('00'),null,s.ksusetrn) |
| ||||||||
| LOCKWAIT | decode(s.ksqpswat,hextoraw('00'),null,s.ksqpswat) |
| ||||||||
| STATUS | decode(bitand(s.ksuseidl,11),1,'ACTIVE',0,decode(bitand(s.ksuseflg,4096),0,'INACTIVE','CACHED'),2,'SNIPED',3,'SNIPED', 'KILLED') |
| ||||||||
| SERVER | decode(s.ksspatyp,1,'DEDICATED',2,'SHARED',3,'PSEUDO','NONE') |
| ||||||||
| SCHEMA# | s.ksuudsid |
| ||||||||
| SCHEMANAME | s.ksuudsna |
| ||||||||
| OSUSER | s.ksuseunm |
| ||||||||
| PROCESS | s.ksusepid |
| ||||||||
| MACHINE | s.ksusemnm |
| ||||||||
| TERMINAL | s.ksusetid |
|
| |||||||
| PROGRAM | s.ksusepnm |
| ||||||||
| TYPE | decode(bitand(s.ksuseflg,19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?') |
| ||||||||
| SQL_ADDRESS | s.ksusesql |
| ||||||||
| SQL_HASH_VALUE | s.ksusesqh |
| ||||||||
| SQL_ID | s.ksusesqi |
| ||||||||
| SQL_CHILD_NUMBER | decode(s.ksusesch, 65535, to_number(null), s.ksusesch) |
| ||||||||
| PREV_SQL_ADDR | s.ksusepsq |
| ||||||||
| PREV_HASH_VALUE | s.ksusepha |
| ||||||||
| PREV_SQL_ID | s.ksusepsi |
| ||||||||
| PREV_CHILD_NUMBER | decode(s.ksusepch, 65535, to_number(null), s.ksusepch) |
| ||||||||
| PLSQL_ENTRY_OBJECT_ID | decode(s.ksusepeo,0,to_number(null),s.ksusepeo) |
| ||||||||
| PLSQL_ENTRY_SUBPROGRAM_ID | decode(s.ksusepeo,0,to_number(null),s.ksusepes) |
| ||||||||
| PLSQL_OBJECT_ID | decode(s.ksusepco,0,to_number(null),s.ksusepco) |
| ||||||||
| PLSQL_SUBPROGRAM_ID | decode(s.ksusepco,0,to_number(null),s.ksusepcs) |
| ||||||||
| MODULE | s.ksuseapp |
| ||||||||
| MODULE_HASH | s.ksuseaph |
| ||||||||
| ACTION | s.ksuseact |
| ||||||||
| ACTION_HASH | s.ksuseach |
| ||||||||
| CLIENT_INFO | s.ksusecli |
| ||||||||
| FIXED_TABLE_SEQUENCE | s.ksusefix |
| ||||||||
| ROW_WAIT_OBJ# | s.ksuseobj |
| ||||||||
| ROW_WAIT_FILE# | s.ksusefil |
| ||||||||
| ROW_WAIT_BLOCK# | s.ksuseblk |
| ||||||||
| ROW_WAIT_ROW# | s.ksuseslt |
| ||||||||
| LOGON_TIME | s.ksuseltm |
| ||||||||
| LAST_CALL_ET | s.ksusectm |
| ||||||||
| PDML_ENABLED | decode(bitand(s.ksusepxopt, 12),0,'NO','YES') |
| ||||||||
| FAILOVER_TYPE | decode(s.ksuseft, 2,'SESSION', 4,'SELECT',8,'TRANSACTIONAL','NONE') |
| ||||||||
| FAILOVER_METHOD | decode(s.ksusefm,1,'BASIC',2,'PRECONNECT',4,'PREPARSE','NONE') |
| ||||||||
| FAILED_OVER | decode(s.ksusefs, 1, 'YES', 'NO') |
| ||||||||
| RESOURCE_CONSUMER_GROUP | s.ksusegrp |
| ||||||||
| PDML_STATUS | decode(bitand(s.ksusepxopt,4),4,'ENABLED', decode(bitand(s.ksusepxopt,8),8,'FORCED','DISABLED')) |
| ||||||||
| PDDL_STATUS | decode(bitand(s.ksusepxopt,2),2,'FORCED',decode(bitand(s.ksusepxopt,1),1,'DISABLED','ENABLED')) |
| ||||||||
| PQ_STATUS | decode(bitand(s.ksusepxopt,32),32,'FORCED',decode(bitand(s.ksusepxopt,16),16,'DISABLED','ENABLED')) |
| ||||||||
| CURRENT_QUEUE_DURATION | s.ksusecqd |
| ||||||||
| CLIENT_IDENTIFIER | s.ksuseclid |
| ||||||||
| BLOCKING_SESSION_STATUS | decode(s.ksuseblocker,4294967295,'UNKNOWN', 4294967294 , 'UNKNOWN',4294967293,'UNKNOWN',4294967292,'NO HOLDER', 4294967291,'NOT IN WAIT','VALID') |
| ||||||||
| BLOCKING_INSTANCE | decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker, 2147418112)/65536) | |||||||||
| BLOCKING_SESSION | decode(s.ksuseblocker, 4294967295,to_number(null),4294967294,to_number(null), 4294967293,to_number(null), 4294967292,to_number(null),4294967291, to_number(null),bitand(s.ksuseblocker,65535)) |
| ||||||||
| SEQ# | s.ksuseseq |
| ||||||||
| EVENT# | s.ksuseopc |
| ||||||||
| EVENT | e.kslednam |
| ||||||||
| P1TEXT | e.ksledp1 |
| ||||||||
| P1 | s.ksusep1 |
| ||||||||
| P1RAW | s.ksusep1r |
| ||||||||
| P2TEXT | e.ksledp2 |
| ||||||||
| P2 | s.ksusep2 |
| ||||||||
| P2RAW | s.ksusep2r |
| ||||||||
| P3TEXT | e.ksledp3 |
| ||||||||
| P3 | s.ksusep3 |
| ||||||||
| P3RAW | s.ksusep3r |
| ||||||||
| WAIT_CLASS_ID | e.ksledclassid |
| ||||||||
| WAIT_CLASS# | e.ksledclass# |
| ||||||||
| WAIT_CLASS | e.ksledclass |
| ||||||||
| WAIT_TIME | decode(s.ksusetim,0,0,-1,-1,-2,-2, decode(round(s.ksusetim/10000),0,-1,round(s.ksusetim/10000))) |
| ||||||||
| SECONDS_IN_WAIT | s.ksusewtm |
| ||||||||
| STATE | decode(s.ksusetim, 0, 'WAITING', -2, 'WAITED UNKNOWN TIME', -1, 'WAITED SHORT TIME', decode(round(s.ksusetim/10000),0,'WAITED SHORT TIME','WAITED KNOWN TIME') |
| ||||||||
| SERVICE_NAME | s.ksusesvc |
| ||||||||
| SQL_TRACE | decode(bitand(s.ksuseflg2,32),32,'ENABLED','DISABLED') |
| ||||||||
| SQL_TRACE_WAITS | decode(bitand(s.ksuseflg2,64),64,'TRUE','FALSE') |
| ||||||||
| SQL_TRACE_BINDS | decode(bitand(s.ksuseflg2,128),128,'TRUE','FALSE') |
|
|
|
|
|
|
|
|
|
转载：http://blog.itpub.net/16976507/viewspace-754440/