How to get dump or list parameters set at session level?

Using oradebug one can get a dump of sessions parameters that are modified at session level, like optimization parameters. SQL> alter session set sql_trace=true; Session altered. SQL> alter session set optimizer_mode=first_rows; Session altered. -- connect to session SQL> oradebug setmypid Statement processed. SQL> oradebug dump modified_parameters 1; Statement processed. SQL> oradebug tracefile_name; i:\db\oracle\testdb\diagnostic_dest\diag\rdbms\testdb_a\testdb\trace\testdb_ora_4908.trc Contents of the tracefile: … *** 2012-05-28 14:35:25.005 Processing Oradebug command ‘dump … Continue reading How to get dump or list parameters set at session level?

How to generate systemdump when the instance is hung?

Using oradebug one can analyze if an instance is hung $ sqlplus “/as sysdba” SQL> oradebug mysetpid Statement processed. — no limit on trace file SQL> oradebug unlimit Statement processed. SQL> oradebug hanganalyze 3 Hang Analysis in /u01/oradata/admin/TEST/udump/test_ora_11852.trc — Wait for couple of minutes SQL> oradebug hanganalyze 3 Hang Analysis in /u01/oradata/admin/TEST/udump/test_ora_11852.trc — Wait for couple of minutes and get systemstate dump SQL> oradebug dump … Continue reading How to generate systemdump when the instance is hung?

How to find/list the events set in a session?

Using “oradebug dump events 1” one can find/list events set in a session. For example: In a session events 10046 and 1410 events are set SQL> ALTER SESSION SET EVENTS='10046 trace name context forever, level 12'; Session altered. SQL> ALTER SESSION SET EVENTS='1410 trace name context forever, level 12'; Session altered. SQL> SELECT distinct sid FROM v$mystat SID ———- 131 In another session login as … Continue reading How to find/list the events set in a session?

How to find shared libraries needed to run a binary?

Depending on the platform different command may be available, below are the commands for AIX and SUN to find the shared libraries needed to run a binary. This may not show all the libraries needed as the application may be referenced in the code and dynamically loading them during different phases of execution of a program. For AIX # if the binary is 64bit one … Continue reading How to find shared libraries needed to run a binary?