Subscriber Count

    464

Subscribe to Posts by Email

Pages

Tracing Sessions: Single SQL_ID, Single Process, New 11g Event Syntax

Happy Reading!!!

Hope you already aware of tracing sessions with different methods

11g onwards, you can trace a session (other session) with in the alter system command itself , no worries of finding pid etc etc. for example like below

SQL> alter session set events ‘sql_trace {process : pid = <pid>, pname = <pname>, […]