-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
One can disable parallel query at a session level by running the following ALTER SESSION statement. You can use this… READ MORE
|
Using oradebug one can get a dump of sessions parameters that are modified at session level, like optimization parameters. SQL>… READ MORE
|
Using “tracefile_identifier” Oracle will add that to the name of the user’s trace filename so the file can easily be… READ MORE
|
Using dbms_xplan.display_cursor one can see the execution plan of a SQL statement. The function takes following 3 parameters. SQL_ID (VARCHAR2)… READ MORE
If AUDIT_TRAIL is not set to NONE then using the following SQL one can find the statements that have auditing… READ MORE
|
SQL> select b.sid, b.serial#, a.spid processid, b.process clientpid from v$process a, v$session b where a.addr = b.paddr and b.audsid =… READ MORE
Tom Kyte’s following routine is a utility that can be used to to collect statistics of a session at the… READ MORE
|
By setting the parameter “AUDIT_TRAIL” to “DB” or “OS”, one can enable auditing in the database. To change the value… READ MORE
|
Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. —… READ MORE
|
In v$session the column last_call_et has value which tells us the last time (seconds) ago when the session performed any… 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
|
Using dbms_monitor.client_id_trace_enable to turn trace on for all sessions that have client identifier set to 'debug' and using dbms_session.set_identifier which… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 