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