Oracle V$SESSION to take a trace of inactive sessions
We have used Oracle V$SESSION to take a trace of inactive sessions between
Client server and Oracle DB. V$SESSION Querry is below
SELECT
to_char(sysdate,'MM-DD HH24:MI:SS') ||','|| USER# ||',' || USERNAME ||',' || STATUS ||',' || SCHEMANAME ||',' || OSUSER ||',' || PROCESS ||',' || MACHINE ||',' || PORT ||',' || TERMINAL ||',' || PROGRAM ||',' || TYPE ||',' || PREV_EXEC_START ||',' || LOGON_TIME ||',' || LAST_CALL_ET ||',' || BLOCKING_SESSION_STATUS ||',' || BLOCKING_INSTANCE ||',' || BLOCKING_SESSION ||',' || FINAL_BLOCKING_SESSION_STATUS ||',' || FINAL_BLOCKING_INSTANCE ||',' || FINAL_BLOCKING_SESSION ||',' || EVENT ||',' || WAIT_TIME ||',' || SECONDS_IN_WAIT ||',' || STATE ||',' || WAIT_TIME_MICRO ||',' || TIME_REMAINING_MICRO