OS & Oracle

It should be boring to trace session with the session_id and serial#, as we will have to query the v$session firstly using other information we knew, such as username, osuser, program, machine, and sometimes, we will query v$sqltext for db objects the session acessed,  or query v$process with the session’s corresponding process’s pid. This staff [...]

There are various ways to enable trace.
1. alter session set sql_trace = true; require DBA privileage
2. alter session set events ‘10046 trace name context forever, level 8′;
3. oradebug setmypid;
4. execute dbms_session.session_trace_enable(waits default true, binds default false); can be invoked by any user to enable session-level [...]