How to view connected session's SQL history

Using the below query, I can see whos connected.
select username,last_call_et,status,machine from v$session

How can I see the SQL history for a particular connected session?

DB version 10gR2

Views: 46

Reply to This

Replies to This Discussion



V$ACTIVE_SESSION_HISTORY, DBA_HIST_ACTIVE_SESS_HISTORY (provided you have the Diagnostic and Tuning Pack License).


Best regards,


Reply to Discussion


Oracle Jobs in US

© 2022   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service