Oracle 19c: how to dump events for a session

Home /Soluții /Oracle 19c: how to dump events for a session

Configurare noua (How To)

sqlplus as / sysdba

SELECT pid, spid FROM v$process where addr IN (SELECT paddr FROM V$session where sid = 131);

oradebug setorapid <PID from v$process>
oradebug eventdump session ;
oradebug tracefile_name
quit

Next, go to the file and search for “eventdump session” and/or “Dumping Event (group=SESSION”

Permanent

Up Down

(5 din 9 persoane apreciaza acest articol)