====== x$ksuse ====== Documentation on the fixed view x$ksuse - Kernel Service User Session Event indx SESSION_ID, decode(ksusetim, 0,'WAITING','ON CPU') SESSION_STATE, ksuseser SESSION_SERIAL#, ksuudlui USER_ID, ksusesql SQL_ADDRESS, ksusesph SQL_PLAN_HASH_VALUE, decode(ksusesch, 65535, to_number(null), ksusesch) SQL_CHILD_NUMBER, ksusesqh SQL_HASH , ksusesqi PREV_SQL_ID , ksusepsi SQL_ID , ksuudoct SQL_OPCODE ksuseflg SESSION_TYPE decode(bitand(ksuseflg,19),17,'BACKGROUND',1,'USER',2,'RECURSIVE','?') ksuseopc EVENT#, ksuseseq SEQ# ksusep1 P1 ksusep2 P2 ksusep3 P3 ksusetim WAIT_TIME ksusewtm TIME_WAITED ksuseobj CURRENT_OBJ#, ksusefil CURRENT_FILE#, ksuseblk CURRENT_BLOCK#, ksusepnm PROGRAM, ksuseaph MODULE_HASH, ksuseach ACTION_HASH, ksusefix FIXED_TABLE_SEQUENCE ksuudsna USERNAME