msimons4
asked on
historical tables
There is a column in the dba_hist_sqltext called sql_text and there is another column called sql_id. So, If I can get the sql_id, I can get the sql_text. All I have is the sid and serial number for a session that is no longer active. How can I get the sid_id from an inactive session when I know the sid and serial number?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think that query is for active sessions since it is using V$SESSIONS. Any idea for inactive sessions?
How are you defining 'inactive' sessions?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oops sorry
from V$SESSION
where .......
from V$SESSION
where .......
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER