-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. —… READ MORE
|
Using “oradebug dump errorstack <dump level>” one can dump the call stack of the process after attaching to a running… READ MORE
Suspend a running process SQL> oradebug setorapid 12 Unix process pid: 10932, image: oracle@localhost.localdomain (TNS V1-V3) SQL> oradebug suspend Statement… READ MORE
The following example shows how to set event on a oracle session To turn on event, needs to be run… READ MORE
Link to oradebug – debug utility http://www.evdbt.com/Oradebug_Modrakovic.pdf READ MORE
To find the trace file one using oradebug one can find it using the example below: SQL> oradebug mysetpid Statement… READ MORE
Using oradebug unlimit one can set to unlimit the size of the trace file. SQL> oradebug setmypid Statement processed. SQL>… READ MORE
|
To use oradebug one first needs to connect to a session using the process id or ora pid. One can… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 