Problem Diagnosis - Expert Oracle RAC Performance Diagnostics and Tuning - page 623

[oracle@prddb1 incdir_52777]$ ls -ltr
total 5648
-rw-r----- 1 oracle dba 413783 Nov 19 16:58 PRDDB_1_ora_3956_i52777.trm
-rw-r----- 1 oracle dba 5339461 Nov 19 16:58 PRDDB_1_ora_3956_i52777.trc
-rw-r----- 1 oracle dba 206 Nov 19 16:58 PRDDB_1_m000_5015_i52777_a.trm
-rw-r----- 1 oracle dba 1299 Nov 19 16:58 PRDDB_1_m000_5015_i52777_a.trc
[oracle@prddb1 incdir_52777]$ more PRDDB_1_ora_3956_i52777.trc
Dump file /app/oracle/diag/rdbms/prddb/PRDDB_1/incident/incdir_52777/PRDDB_1_ora_3956_
i52777.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage
. . . . . . . . . . .
. . . . . . . . . . . .
*** 2010-11-19 16:58:13.942
*** SESSION ID:(750.2230) 2010-11-19 16:58:13.942
*** CLIENT ID:() 2010-11-19 16:58:13.942
*** SERVICE NAME:(BIAPPS) 2010-11-19 16:58:13.942
*** MODULE NAME:(nqsserver@prdapp3 (TNS V1-V3)) 2010-11-19 16:58:13.942
*** ACTION NAME:() 2010-11-19 16:58:13.942
Dump continued from file: /app/oracle/diag/rdbms/prddb/PRDDB_1/trace/PRDDB_1_ora_3956.trc
ORA-00600: internal error code, arguments: [kkqsMapExp:badleaf], [], [], [], [], [], [],
[], [], [], [], []
========= Dump for incident 52777 (ORA 600 [kkqsMapExp:badleaf]) ========
*** 2010-11-19 16:58:13.943
dbkedDefDump(): Starting incident default dumps (flags=0x2, level=3, mask=0x0)
----- Current SQL Statement for this session (sql_id=c7x8nxwzf42ac) -----
select distinct T537387.SRV_REQ_NUM as c1,
T537387.INCIDENT_TYPE_CD as c2,
T534609.DAY_DT as c3,
T501320.NAME as c4,
T512643.INSTANCE_NUM as c5,
T512643.SERIAL_NUM as c6,
T32069.X_PROD_HIER8_NAME as c7,
T595543.NOTE_TYPE_NAME as c8,
. . . . . . . . . . .
. . . . . . . . . . .

2. Another method of checking if there are SQL queries associated with the incident is to

query the V$DIAG_DDE_USER_ACTION:

Script Name:MVRACTnTop_adrddeuseraction.sql
Action Incident invocation
ADR Home Name id id
---------------------------- ---------- -------- ----------
diag/rdbms/prddb/PRDDB_1 SQLTCB 52777 1
diag/rdbms/prddb/PRDDB_1 SQLTCB 52849 1
The preceding output contains the action names SQLTCB (SQL Test Case Builder) associated with each incident,
indicating that both these incidents involve SQL statements.