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

▶ Reply to This

Replies to This Discussion

Permalink Reply by Harry Rivero on August 1, 2013 at 10:15am

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

Groups

Videos

  • Add Videos
  • View All

© 2024   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service