-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Find SQL currently executing in a session: https://oraclespin.wordpress.com/2010/05/09/how-to-find-sql-running-for-a-usersid/ Session running waiting on SYS@TESTDB> SELECT event, state, p1, p2, p3, seconds_in_wait… READ MORE
|
Using the SQL below in which joining with V$session and V$sqlarea one can find the SQL currently running. In this… 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
|
To turn on trace for a specific event. exec dbms_system.set_ev(<SID>, <serial#>, <event>, 8, ''); Example: Enable trace at level 8… READ MORE
|
Using dbms_system.set_int_param_in_session, one can set max_dump_file_size of a running session. In the example it sets trace file to 100MB exec… READ MORE
There was an issue we ran into where one of the users ran out temporary tablespace (TEMP) we had message… READ MORE
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
|
One can’t grant direct access V$session as v$session is a synonym. SQL> GRANT SELECT ON v$session TO scott; grant select… READ MORE
|
— One can use the following query to find the name of the trace filename — To find the name… READ MORE
|
Using one of the following you can find your session id (SID). SQL> SELECT sid FROM v$mystat WHERE rownum =… READ MORE
|
The following example shows how to find lock on a store procedure, the following store procedure has infinite loop. A… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 