Oracle Community Network
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
Tags:
Hi,
V$ACTIVE_SESSION_HISTORY, DBA_HIST_ACTIVE_SESS_HISTORY (provided you have the Diagnostic and Tuning Pack License).
Best regards,
Rivero
© 2024 Created by Maisam Agha.
Powered by