bdump trc files
581926Sep 3 2009 — edited Sep 3 2009Hello all, this is my first post here so please excuse me if I violate proper posting etiquette.
I've been seeing several .trc files in the bdump directory created on a regular basis over the last few days. Can anyone shed some light on what they mean?
Dump file e:\oracle\product\10.2.0\admin\juaora03\bdump\juaora03_p000_5912.trc
Thu Sep 03 02:21:27 2009
ORACLE V10.2.0.3.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Production
With the Partitioning, OLAP and Data Mining options
Windows NT Version V5.2 Service Pack 2
CPU : 4 - type 586, 2 Physical Cores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:1855M/4090M, Ph+PgF:3991M/5972M, VA:1413M/3071M
Instance name: juaora03
Redo thread mounted by this instance: 1
Oracle process number: 47
Windows thread id: 5912, image: ORACLE.EXE (P000)
*** 2009-09-03 02:21:27.508
*** SERVICE NAME:(SYS$USERS) 2009-09-03 02:21:27.493
*** SESSION ID:(68.50487) 2009-09-03 02:21:27.493
---------------------- Dumping Query Warning -------------------
SQL Text (sql_id=5gx9qgyqcxjnp):
SELECT A.LOT, A.STOCKROLL, A.POSITION, A.CARTSEQ, S.GENERATIONWOUND, A.SSN, A.INKJET, A.TESTTYPE, B.LASTTEST, A.PASS AS LASTRESULT, B.TOTALTESTS, A.BLOCKSWRITTEN, A.TRACKSEQUENCE, A.COMMENTS, A.SWRUNNUM, CASE WHEN A.PASS = 1 THEN 'Pass' WHEN A.PASS = 0 AND TOTALTESTS >= 2 THEN 'Fail' WHEN A.PASS = 0 AND TOTALTESTS < 2 THEN 'First Pass Fail' ELSE 'Undetermined' END AS FINALSTATUS FROM VW_EPTDATA_BY_STOCKROLL A INNER JOIN (SELECT SSN, MAX(ENDTIME) AS LASTTEST, COUNT(*) AS TOTALTESTS FROM VW_EPTDATA_BY_STOCKROLL WHERE LOT = :B2 AND STOCKROLL = :B1 GROUP BY SSN ) B ON A.SSN = B.SSN AND A.ENDTIME = B.LASTTEST INNER JOIN MEDIA_STRANDS S ON A.LOT = S.LOT AND A.STOCKROLL = S.STOCKROLL AND A.POSITION = S.POSITION WHERE TESTTYPE = 'G1 End Point Test' AND TRACKSEQUENCE = 0
Dumping stream from 0 to 526
----------------------------------
0000: 143 92 231 189 80 143 124 1 0 38 40 3 192 88 196 3 1 15 5 1 .\..P.|..&(..X......
0020: 2 194 70 41 3 4 14 0 0 0 225 7 3 5 12 8 106 108 109 224 ..F)............jlm.
0040: 152 228 163 113 111 6 46 7 129 204 0 111 5 46 8 129 204 0 110 9 ...qo......o......n.
0060: 110 7 46 10 129 204 0 110 11 110 8 46 12 129 204 0 110 13 110 10 n......n.n......n.n.
0080: 110 3 110 12 46 14 129 204 0 110 15 110 14 46 16 129 204 0 110 17 n.n......n.n......n.
0100: 110 16 1 5 15 18 52 5 16 22 5 2 19 21 19 20 34 101 5 16 n.....4........."e..
0120: 30 15 7 23 20 23 24 23 25 23 26 23 27 23 28 23 29 34 101 5 ................."e.
0140: 3 4 9 4 2 24 2 25 2 26 2 31 34 40 5 4 15 18 16 22 ............"(......
0160: 16 30 3 4 19 5 16 22 19 5 16 30 19 5 3 4 101 6 10 30 ................e...
0180: 17 8 23 24 23 25 23 26 23 20 23 33 23 29 23 34 23 32 34 101 ...........!...". "e
0200: 6 10 22 7 3 19 20 19 21 19 35 34 40 6 2 10 30 10 22 19 ..........#"(.......
0220: 6 10 22 0 0 143 40 214 189 80 4 2 2 0 128 167 224 116 166 52 ......(..P.......t.4
0240: 128 166 1 129 7 0 143 212 180 189 80 4 3 2 0 128 167 224 116 153 ..........P.......t.
0260: 224 128 165 1 128 248 0 143 48 150 189 80 4 4 2 0 128 166 224 116 ........0..P.......t
0280: 145 113 128 165 1 128 199 0 143 196 165 188 80 134 20 5 53 0 128 164 .q..........P...5...
0300: 224 116 78 165 128 163 5 128 140 6 15 18 0 143 88 167 188 80 20 6 .tN...........X..P..
0320: 103 57 128 164 224 106 163 181 128 163 5 129 29 6 0 143 128 148 188 80 g9...j.............P
0340: 7 7 19 0 0 0 0 143 208 148 188 80 4 8 2 0 128 163 211 140 ...........P........
0360: 221 128 163 5 129 29 0 143 232 117 188 80 134 124 9 23 12 3 192 163 .........u.P.|......
0380: 86 3 80 140 128 6 1 36 192 201 82 10 30 1 143 212 150 188 80 134 V.P....$..R.......P.
0400: 252 9 2 23 12 2 188 133 2 1 17 6 1 37 192 201 56 10 22 2 .............%..8...
0420: 143 92 215 188 80 134 252 5 2 38 40 3 192 96 48 3 1 128 171 5 .\..P....&(..`0.....
0440: 1 19 192 200 254 16 22 14 143 228 180 188 80 134 124 6 23 12 2 187 ............P.|.....
0460: 189 2 1 0 5 1 38 192 201 55 16 22 2 143 152 148 189 80 134 252 ......&..7.......P..
0480: 4 2 23 12 2 188 183 2 1 49 5 1 39 194 120 205 16 30 2 143 .........1..'.x.....
0500: 212 198 189 80 134 252 3 2 23 12 2 187 189 2 1 0 5 1 40 194 ...P..............(.
0520: 163 163 3 4 1 142 ......
============
Plan Table
============
------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 167 | |
| 1 | TABLE ACCESS BY INDEX ROWID | MEDIA_STRANDS | 1 | 15 | 3 | 00:00:01 |
| 2 | NESTED LOOPS | | 1 | 263 | 167 | 00:00:03 |
| 3 | NESTED LOOPS | | 1 | 248 | 167 | 00:00:03 |
| 4 | NESTED LOOPS | | 1 | 199 | 166 | 00:00:02 |
| 5 | VIEW | | 5 | 140 | 164 | 00:00:02 |
| 6 | HASH GROUP BY | | 5 | 285 | 164 | 00:00:02 |
| 7 | FILTER | | | | | |
| 8 | NESTED LOOPS | | 5 | 285 | 163 | 00:00:02 |
| 9 | INDEX RANGE SCAN | IDX_LOT_STOCKROLL | 80 | 3200 | 3 | 00:00:01 |
| 10 | INDEX RANGE SCAN | IDX_SSN_EPTTIME_SWRUNNUM| 1 | 17 | 2 | 00:00:01 |
| 11 | TABLE ACCESS BY INDEX ROWID | EPTDATA | 1 | 171 | 3 | 00:00:01 |
| 12 | INDEX RANGE SCAN | IDX_EPTTIME_SSN | 1 | | 2 | 00:00:01 |
| 13 | INDEX RANGE SCAN | IDX_PF_FIRSTLAST | 1 | 49 | 2 | 00:00:01 |
| 14 | INDEX RANGE SCAN | PK_MS_RETRY | 1 | | 2 | 00:00:01 |
------------------------------------------------------------------------------------------------------
Predicate Information:
----------------------
7 - filter(:B2<>'C000')
9 - access("P"."LOT"=:B2 AND "P"."STOCKROLL"=:B1)
9 - filter("P"."LOT"<>'C000')
10 - access("E"."SSN"="P"."SSN")
10 - filter(("E"."ENDTIME">"P"."WDDATE" OR "P"."WDDATE" IS NULL))
11 - filter(("E"."TRACKSEQUENCE"=0 AND CASE WHEN (UPPER("E"."DRIVETYPE")='IBM ULT3580-TD4' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G4 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULT3580-TD4' AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G4 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD4' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G4 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD4' AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G4 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM3-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 HP Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD3' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM3' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 Certance Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='HP ULTRIUM3-SCSI' OR UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD3' OR UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM3') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G3 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM2-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 HP Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD2' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM2' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 Certance Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='HP ULTRIUM2-SCSI' OR UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD2' OR UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM2') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G2 End Point Test' WHEN ((UPPER("E"."DRIVETYPE")='SEA ULTRIUM06242-' OR UPPER("E"."DRIVETYPE")='SEAGATE ULTRIUM06242-') AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 Certance Audit Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM1-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 HP Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD1' OR UPPER("E"."DRIVETYPE")='IBM ULT3580-TD1' OR UPPER("E"."DRIVETYPE")='IBM3580-TD1' OR UPPER("E"."DRIVETYPE")='IBMRIUM-TD1') AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 IBM Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='SEA ULTRIUM06242-' OR UPPER("E"."DRIVETYPE")='SEAGATE ULTRIUM06242-') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G1 End Point Test' ELSE 'Unknown Test Type' END ='G1 End Point Test'))
12 - access("E"."ENDTIME"="B"."LASTTEST" AND "E"."SSN"="B"."SSN")
13 - access("E"."SSN"="P"."SSN")
13 - filter(("P"."LOT"<>'C000' AND ("E"."ENDTIME">"P"."WDDATE" OR "P"."WDDATE" IS NULL)))
14 - access("P"."LOT"="S"."LOT" AND "P"."STOCKROLL"="S"."STOCKROLL" AND "P"."POSITION"="S"."POSITION")
14 - filter("S"."LOT"<>'C000')
Content of other_xml column
===========================
db_version : 10.2.0.3
parse_schema : ASSEMBLY
plan_hash : 3602539306
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"SEL$55F9DEAE")
MERGE(@"SEL$6BD737F4")
OUTLINE_LEAF(@"SEL$49BF9492")
MERGE(@"SEL$114A7E2C")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$6BD737F4")
MERGE(@"SEL$5")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$114A7E2C")
MERGE(@"SEL$73112EEC")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$73112EEC")
MERGE(@"SEL$64EAE176")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$64EAE176")
MERGE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$2")
NO_ACCESS(@"SEL$49BF9492" "B"@"SEL$1")
INDEX_RS_ASC(@"SEL$49BF9492" "E"@"SEL$2" ("EPTDATA"."ENDTIME" "EPTDATA"."SSN"))
INDEX(@"SEL$49BF9492" "P"@"SEL$2" ("PASSFAIL"."SSN" "PASSFAIL"."LOT" "PASSFAIL"."STOCKROLL" "PASSFAIL"."POSITION" "PASSFAIL"."CARTSEQ" "PASSFAIL"."INKJET" "PASSFAIL"."WDDATE"))
INDEX(@"SEL$49BF9492" "S"@"SEL$7" ("MEDIA_STRANDS"."LOT" "MEDIA_STRANDS"."STOCKROLL" "MEDIA_STRANDS"."POSITION" "MEDIA_STRANDS"."BARCODE"))
LEADING(@"SEL$49BF9492" "B"@"SEL$1" "E"@"SEL$2" "P"@"SEL$2" "S"@"SEL$7")
USE_NL(@"SEL$49BF9492" "E"@"SEL$2")
USE_NL(@"SEL$49BF9492" "P"@"SEL$2")
USE_NL(@"SEL$49BF9492" "S"@"SEL$7")
INDEX(@"SEL$55F9DEAE" "P"@"SEL$5" ("PASSFAIL"."LOT" "PASSFAIL"."STOCKROLL" "PASSFAIL"."POSITION" "PASSFAIL"."SSN" "PASSFAIL"."REASON" "PASSFAIL"."WDDATE" "PASSFAIL"."EPTDATE" "PASSFAIL"."PASS"))
INDEX(@"SEL$55F9DEAE" "E"@"SEL$5" ("EPTDATA"."SSN" "EPTDATA"."ENDTIME" "EPTDATA"."SWRUNNUM"))
LEADING(@"SEL$55F9DEAE" "P"@"SEL$5" "E"@"SEL$5")
USE_NL(@"SEL$55F9DEAE" "E"@"SEL$5")
END_OUTLINE_DATA
*/
WATSON_PRAGMA BEGINAPPEND file=pq.wat
com='soft_assert' sql_id=5gx9qgyqcxjnp fi='#FILE' li=#LINE mesg=qkaParallelizePost: Slave has SERIAL plan. Abort.
WATSON_PRAGMA ENDAPPEND
----------------------------------------------------------------
Cursor Hash Value: 2899232405
kxfxsStatus
joining FALSE ParseState KXFXUPARSE1 (1). Try Plan B
kxfxProcCursorError
Error 12872 trapped during phase KXFXUPARSE1 (1). Resig from client.
opiSem
Plan B reparse in ParseState = 3
kxfxsStatus
joining TRUE ParseState KXFXUPARSE2 (3)
*** SERVICE NAME:(SYS$USERS) 2009-09-03 02:21:34.618
*** SESSION ID:(126.59589) 2009-09-03 02:21:34.618
---------------------- Dumping Query Warning -------------------
SQL Text (sql_id=8r85c5mw5bfn1):
SELECT A.LOT, A.STOCKROLL, A.POSITION, A.CARTSEQ, S.GENERATIONWOUND, A.SSN, A.INKJET, A.TESTTYPE, B.LASTTEST, A.PASS AS LASTRESULT, B.TOTALTESTS, A.BLOCKSWRITTEN, A.TRACKSEQUENCE, A.COMMENTS, A.SWRUNNUM, CASE WHEN A.PASS = 1 THEN 'Pass' WHEN A.PASS = 0 AND TOTALTESTS >= 2 THEN 'Fail' WHEN A.PASS = 0 AND TOTALTESTS < 2 THEN 'First Pass Fail' ELSE 'Undetermined' END AS FINALSTATUS FROM VW_EPTDATA_BY_STOCKROLL A INNER JOIN (SELECT SSN, MAX(ENDTIME) AS LASTTEST, COUNT(*) AS TOTALTESTS FROM VW_EPTDATA_BY_STOCKROLL WHERE LOT = :B2 AND STOCKROLL = :B1 GROUP BY SSN ) B ON A.SSN = B.SSN AND A.ENDTIME = B.LASTTEST INNER JOIN MEDIA_STRANDS S ON A.LOT = S.LOT AND A.STOCKROLL = S.STOCKROLL AND A.POSITION = S.POSITION WHERE TESTTYPE LIKE 'G' || TO_CHAR(S.GENERATIONWOUND) || '%Audit Test' AND A.PASS = 1
Dumping stream from 0 to 526
----------------------------------
0000: 143 220 195 159 80 143 124 1 0 38 40 3 192 88 196 3 1 15 5 1 ....P.|..&(..X......
0020: 2 194 70 41 3 4 14 0 0 0 225 7 3 5 12 8 106 108 109 224 ..F)............jlm.
0040: 152 228 163 113 111 6 46 7 129 204 0 111 5 46 8 129 204 0 110 9 ...qo......o......n.
0060: 110 7 46 10 129 204 0 110 11 110 8 46 12 129 204 0 110 13 110 10 n......n.n......n.n.
0080: 110 3 110 12 46 14 129 204 0 110 15 110 14 46 16 129 204 0 110 17 n.n......n.n......n.
0100: 110 16 1 5 15 18 52 5 16 22 5 2 19 21 19 20 34 101 5 16 n.....4........."e..
0120: 30 15 7 23 20 23 24 23 25 23 26 23 27 23 28 23 29 34 101 5 ................."e.
0140: 3 4 9 4 2 24 2 25 2 26 2 31 34 40 5 4 15 18 16 22 ............"(......
0160: 16 30 3 4 19 5 16 22 19 5 16 30 19 5 3 4 101 6 10 30 ................e...
0180: 17 8 23 24 23 25 23 26 23 20 23 33 23 29 23 34 23 32 34 101 ...........!...". "e
0200: 6 10 22 7 3 19 20 19 21 19 35 34 40 6 2 10 30 10 22 19 ..........#"(.......
0220: 6 10 22 0 0 143 16 179 159 80 4 2 2 0 128 168 224 116 191 128 .........P.......t..
0240: 128 167 1 129 7 0 143 192 145 159 80 4 3 2 0 128 168 224 116 179 ..........P.......t.
0260: 44 128 166 1 128 248 0 143 48 115 159 80 4 4 2 0 128 166 224 116 ,.......0s.P.......t
0280: 145 113 128 165 4 131 28 0 143 68 50 159 80 134 20 5 53 0 128 164 .q.......D2.P...5...
0300: 224 116 78 165 128 163 5 128 140 6 15 18 0 143 216 51 159 80 20 6 .tN............3.P..
0320: 103 57 128 164 224 106 163 181 128 163 5 129 29 6 0 143 0 33 159 80 g9...j...........!.P
0340: 7 7 19 0 0 0 0 143 80 33 159 80 4 8 2 0 128 163 211 140 ........P!.P........
0360: 221 128 163 5 129 29 0 143 104 2 159 80 134 124 9 23 12 3 192 163 ........h..P.|......
0380: 86 3 80 140 128 6 1 36 192 201 82 10 30 1 143 84 35 159 80 134 V.P....$..R....T#.P.
0400: 252 9 2 23 12 2 188 133 2 1 17 6 1 37 192 201 56 10 22 2 .............%..8...
0420: 143 220 99 159 80 134 252 5 2 38 40 3 192 96 48 3 1 128 171 5 ..c.P....&(..`0.....
0440: 1 19 192 200 254 16 22 14 143 100 65 159 80 134 124 6 23 12 2 187 .........dA.P.|.....
0460: 189 2 1 0 5 1 38 192 201 55 16 22 2 143 152 113 159 80 134 252 ......&..7.....q.P..
0480: 4 2 23 12 2 188 183 2 1 49 5 1 39 194 120 205 16 30 2 143 .........1..'.x.....
0500: 84 163 159 80 134 252 3 2 23 12 2 187 189 2 1 0 5 1 40 194 T..P..............(.
0520: 163 163 3 4 1 142 ......
============
Plan Table
============
------------------------------------------------------------------------------------------------------
| Id | Operation | Name | Rows | Bytes | Cost | Time |
------------------------------------------------------------------------------------------------------
| 0 | SELECT STATEMENT | | | | 168 | |
| 1 | TABLE ACCESS BY INDEX ROWID | MEDIA_STRANDS | 1 | 15 | 3 | 00:00:01 |
| 2 | NESTED LOOPS | | 1 | 263 | 168 | 00:00:03 |
| 3 | NESTED LOOPS | | 1 | 248 | 168 | 00:00:03 |
| 4 | NESTED LOOPS | | 4 | 796 | 166 | 00:00:02 |
| 5 | VIEW | | 5 | 140 | 164 | 00:00:02 |
| 6 | HASH GROUP BY | | 5 | 285 | 164 | 00:00:02 |
| 7 | FILTER | | | | | |
| 8 | NESTED LOOPS | | 5 | 285 | 163 | 00:00:02 |
| 9 | INDEX RANGE SCAN | IDX_LOT_STOCKROLL | 80 | 3200 | 3 | 00:00:01 |
| 10 | INDEX RANGE SCAN | IDX_SSN_EPTTIME_SWRUNNUM| 1 | 17 | 2 | 00:00:01 |
| 11 | TABLE ACCESS BY INDEX ROWID | EPTDATA | 1 | 171 | 3 | 00:00:01 |
| 12 | INDEX RANGE SCAN | IDX_EPTTIME_SSN | 1 | | 2 | 00:00:01 |
| 13 | INDEX RANGE SCAN | IDX_PF_FIRSTLAST | 1 | 49 | 2 | 00:00:01 |
| 14 | INDEX RANGE SCAN | PK_MS_RETRY | 1 | | 2 | 00:00:01 |
------------------------------------------------------------------------------------------------------
Predicate Information:
----------------------
1 - filter(CASE WHEN (UPPER("E"."DRIVETYPE")='IBM ULT3580-TD4' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G4 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULT3580-TD4' AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G4 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD4' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G4 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD4' AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G4 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM3-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 HP Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD3' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM3' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G3 Certance Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='HP ULTRIUM3-SCSI' OR UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD3' OR UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM3') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G3 End Point Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM2-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 HP Audit Test' WHEN (UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD2' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 IBM Audit Test' WHEN (UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM2' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G2 Certance Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='HP ULTRIUM2-SCSI' OR UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD2' OR UPPER("E"."DRIVETYPE")='CERTANCE ULTRIUM2') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G2 End Point Test' WHEN ((UPPER("E"."DRIVETYPE")='SEA ULTRIUM06242-' OR UPPER("E"."DRIVETYPE")='SEAGATE ULTRIUM06242-') AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 Certance Audit Test' WHEN (UPPER("E"."DRIVETYPE")='HP ULTRIUM1-SCSI' AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 HP Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='IBM ULTRIUM-TD1' OR UPPER("E"."DRIVETYPE")='IBM ULT3580-TD1' OR UPPER("E"."DRIVETYPE")='IBM3580-TD1' OR UPPER("E"."DRIVETYPE")='IBMRIUM-TD1') AND "E"."TESTCOMMENT" LIKE '%Wrt: 100%') THEN 'G1 IBM Audit Test' WHEN ((UPPER("E"."DRIVETYPE")='SEA ULTRIUM06242-' OR UPPER("E"."DRIVETYPE")='SEAGATE ULTRIUM06242-') AND "E"."TESTCOMMENT"<>'None' AND "E"."TESTCOMMENT" NOT LIKE '%Wrt: 100%') THEN 'G1 End Point Test' ELSE 'Unknown Test Type' END LIKE 'G'||TO_CHAR("S"."GENERATIONWOUND")||'%Audit Test')
7 - filter(:B2<>'C000')
9 - access("P"."LOT"=:B2 AND "P"."STOCKROLL"=:B1)
9 - filter("P"."LOT"<>'C000')
10 - access("E"."SSN"="P"."SSN")
10 - filter(("E"."ENDTIME">"P"."WDDATE" OR "P"."WDDATE" IS NULL))
11 - filter("E"."PASS"=1)
12 - access("E"."ENDTIME"="B"."LASTTEST" AND "E"."SSN"="B"."SSN")
13 - access("E"."SSN"="P"."SSN")
13 - filter(("P"."LOT"<>'C000' AND ("E"."ENDTIME">"P"."WDDATE" OR "P"."WDDATE" IS NULL)))
14 - access("P"."LOT"="S"."LOT" AND "P"."STOCKROLL"="S"."STOCKROLL" AND "P"."POSITION"="S"."POSITION")
14 - filter("S"."LOT"<>'C000')
Content of other_xml column
===========================
db_version : 10.2.0.3
parse_schema : ASSEMBLY
plan_hash : 3602539306
Outline Data:
/*+
BEGIN_OUTLINE_DATA
IGNORE_OPTIM_EMBEDDED_HINTS
OPTIMIZER_FEATURES_ENABLE('10.2.0.3')
ALL_ROWS
OUTLINE_LEAF(@"SEL$55F9DEAE")
MERGE(@"SEL$6BD737F4")
OUTLINE_LEAF(@"SEL$49BF9492")
MERGE(@"SEL$114A7E2C")
OUTLINE(@"SEL$4")
OUTLINE(@"SEL$6BD737F4")
MERGE(@"SEL$5")
OUTLINE(@"SEL$8")
OUTLINE(@"SEL$114A7E2C")
MERGE(@"SEL$73112EEC")
OUTLINE(@"SEL$6")
OUTLINE(@"SEL$5")
OUTLINE(@"SEL$7")
OUTLINE(@"SEL$73112EEC")
MERGE(@"SEL$64EAE176")
OUTLINE(@"SEL$1")
OUTLINE(@"SEL$64EAE176")
MERGE(@"SEL$2")
OUTLINE(@"SEL$3")
OUTLINE(@"SEL$2")
NO_ACCESS(@"SEL$49BF9492" "B"@"SEL$1")
INDEX_RS_ASC(@"SEL$49BF9492" "E"@"SEL$2" ("EPTDATA"."ENDTIME" "EPTDATA"."SSN"))
INDEX(@"SEL$49BF9492" "P"@"SEL$2" ("PASSFAIL"."SSN" "PASSFAIL"."LOT" "PASSFAIL"."STOCKROLL" "PASSFAIL"."POSITION" "PASSFAIL"."CARTSEQ" "PASSFAIL"."INKJET" "PASSFAIL"."WDDATE"))
INDEX(@"SEL$49BF9492" "S"@"SEL$7" ("MEDIA_STRANDS"."LOT" "MEDIA_STRANDS"."STOCKROLL" "MEDIA_STRANDS"."POSITION" "MEDIA_STRANDS"."BARCODE"))
LEADING(@"SEL$49BF9492" "B"@"SEL$1" "E"@"SEL$2" "P"@"SEL$2" "S"@"SEL$7")
USE_NL(@"SEL$49BF9492" "E"@"SEL$2")
USE_NL(@"SEL$49BF9492" "P"@"SEL$2")
USE_NL(@"SEL$49BF9492" "S"@"SEL$7")
INDEX(@"SEL$55F9DEAE" "P"@"SEL$5" ("PASSFAIL"."LOT" "PASSFAIL"."STOCKROLL" "PASSFAIL"."POSITION" "PASSFAIL"."SSN" "PASSFAIL"."REASON" "PASSFAIL"."WDDATE" "PASSFAIL"."EPTDATE" "PASSFAIL"."PASS"))
INDEX(@"SEL$55F9DEAE" "E"@"SEL$5" ("EPTDATA"."SSN" "EPTDATA"."ENDTIME" "EPTDATA"."SWRUNNUM"))
LEADING(@"SEL$55F9DEAE" "P"@"SEL$5" "E"@"SEL$5")
USE_NL(@"SEL$55F9DEAE" "E"@"SEL$5")
END_OUTLINE_DATA
*/
WATSON_PRAGMA BEGINAPPEND file=pq.wat
com='soft_assert' sql_id=8r85c5mw5bfn1 fi='#FILE' li=#LINE mesg=qkaParallelizePost: Slave has SERIAL plan. Abort.
WATSON_PRAGMA ENDAPPEND
----------------------------------------------------------------
Cursor Hash Value: 4166367873
kxfxsStatus
joining FALSE ParseState KXFXUPARSE1 (1). Try Plan B
kxfxProcCursorError
Error 12872 trapped during phase KXFXUPARSE1 (1). Resig from client.
kxfxsStatus
joining TRUE ParseState KXFXUPARSE2 (3)