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: 53

Reply to This

Replies to This Discussion

Hi,

 

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

 

Best regards,

 Rivero

Reply to Discussion

RSS

Oracle Jobs in US

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service