Step from pid to sqltext of active session on single instance database Oracle

If you have the process ID (PID) you can back to sqltext active session associated on database using the following steps: 1) Run the statement by inserting PID alter session set nls_date_format = ‘dd-mm-yyyy hh24:mi:ss’; col machine for a20 col username for a15 col OSUSER for a15 col spid for a8 col program for a35…
Leggi tutto

17 Marzo 2015 0