Hi Stefania,
AFAIK, there are several bugs, all having to do with problems in processing
the cursor queries. Try searching metalink. Possible solutions are:
- add aliases for every table/view in the from-clause
- don't use parallel query for the cursor query
- don't use functions in the group by- or order by-clause
HTH, Remco
-----Oorspronkelijk bericht-----
Van: Dati Tecnici [mailto:dadostecnicos_at_hotmail.com]
Verzonden: woensdag 16 mei 2001 11:21
Aan: Multiple recipients of list ORACLE-L
Onderwerp: ORA-3113 and PLSQL Runtime Dump
Hi all,
lately for few packages I am getting this dump. A sample is attached below.
Is there a way to read this stuff to pinpoint where exactly in code this is
happening? How to read this? or this is *oracle only* stuff (I guess ..)
Thaks in advance
Stefania Pessoz
Trace file:
Oracle8i Release 8.1.5.0.0 - Production
With the Java option
PL/SQL Release 8.1.5.0.0 - Production
ORACLE_HOME = /export/home/orasw/production/8.1.5
System name: SunOS
Node name: oracle8
Release: 5.6
Version: Generic_105181-16
Machine: sun4u
Instance name: fineco
Redo thread mounted by this instance: 1
Oracle process number: 13
Unix process pid: 9981, image: oracle_at_oracle8 (TNS V1-V3)
- 2001.05.16.08.58.16.000
- SESSION ID:(7.2427) 2001.05.16.08.58.16.000
*********START PLSQL RUNTIME DUMP************
***Got ORA-3113 while running PLSQL***
PACKAGE BODY SYS.DBMS_OUTPUT:
library unit=820f1bb0 line=73 opcode=32 static link=0 scope=1
FP=16c3474 PC=81809751 Page=0 AP=16c324c ST=16c3494
DL0=167a66c GF=167a698 DL1=167a67c DPF=167a690 DS=81809bb8
DON library unit variable list instantiation
------ ------------ ------------- -------------
0 820f1bb0 167a698 1675480
1
2
3
scope frame
-------- --------
2 16c3474
1 0
package variable address size
---------------- -------- --------
0 167a714 8
1 167a71c 8
2 167a724 20
3 167a738 8
4 167a740 8
5 167a748 8
6 167a750 8
7 167a758 8
8 167a760 20
9 167a774 8
10 167a77c 4
11 167a780 2
12 167a784 4
13 167a788 2
14 167a78c 509
15 167a98c 2
16 167a990 4
17 167a994 2
18 167a998 4
19 167a99c 2
20 167a9a0 4
21 167a9a4 2
22 167a9a8 4
23 167a9ac 2
24 167a9b0 4
25 167a9b4 2
26 167a9b8 4
27 167a9bc 2
28 167a9c0 20
29 167a9d4 4
30 167a9d8 2
version=43123476 instantiation size=876
line pcode offset
-------- ------------
2 14
4 19
5 24
6 29
7 34
8 39
9 44
18 63
19 68
20 89
21 100
22 121
24 132
26 137
31 200
33 205
34 210
35 215
36 220
42 241
43 255
49 276
50 290
56 316
57 330
63 351
64 365
65 372
71 398
72 412
73 424
79 450
80 464
81 476
88 502
89 516
90 530
91 535
92 540
93 545
96 557
97 577
98 593
99 598
103 637
104 653
105 669
106 674
110 737
111 769
112 791
113 796
116 808
117 860
118 895
125 922
126 942
127 957
130 958
132 978
133 1010
134 1032
136 1037
137 1042
138 1047
141 1052
142 1068
143 1123
144 1139
145 1211
146 1246
147 1261
149 1268
150 1290
153 1301
154 1316
158 1335
161 1350
162 1370
163 1385
165 1386
166 1402
167 1463
168 1484
169 1506
171 1507
173 1535
174 1557
PACKAGE BODY FINECO.PKG_ORDRE_ATS_IDEM_RT:
library unit=82481f94 line=747 opcode=38 static link=0 scope=1
FP=16c324c PC=822b7087 Page=3 AP=16c3194 ST=16c3410
DL0=167aca8 GF=167ad60 DL1=167acfc DPF=167ad54 DS=820e70b0
DON library unit variable list instantiation
------ ------------ ------------- -------------
0 82481f94 167ad60 1682638
1
2
3
4
5
6
7
8 820f1bb0 167c0f8 1675480
9
10
11
12
13
14
15
16
17
18
19
20
scope frame
-------- --------
3 0
2 16c324c
1 0
package variable address size
---------------- -------- --------
0 167ad88 120
1 167ae00 120
2 167ae78 120
3 167aef0 120
4 167af68 120
5 167afe0 120
6 167b058 120
7 167b0d0 120
8 167b148 120
9 167b1c0 120
version=43123476 instantiation size=1420
exception id error DON offset begin end DID
--------- ------ ----- ------ ------ ------ ------ ------
0 0 0 1 6820 6707 6819
1 0 0 1 6874 6837 6873
2 0 0 1 6928 6891 6927
3 0 0 1 6982 6945 6981
4 0 0 1 7015 6999 7014
5 0 0 1 7048 7032 7047
6 0 0 1 7081 7065 7080
7 0 0 1 8954 28 8953
8 0 0 1 11357 11244 11356
9 0 0 1 11475 11424 11474
10 0 0 1 11850 11492 11849
11 0 0 1 12222 11864 12221
12 0 0 1 12322 12242 12321
13 0 0 1 12466 12349 12465
14 0 0 1 12670 12473 12669
15 0 0 1 13063 9054 13062
16 0 0 1 15560 15263 15559
line pcode offset
-------- ------------
1037 9
119 28
120 118
124 208
125 298
126 388
127 478
128 568
129 658
130 748
131 838
132 928
133 1018
134 1108
135 1199
136 1290
137 1406
138 1522
139 1638
140 1754
141 1845
142 1936
143 2027
144 2118
145 2209
146 2300
147 2391
148 2483
149 2575
150 2667
151 2759
152 2851
153 2943
154 3035
155 3127
156 3219
157 3311
158 3403
159 3495
160 3587
161 3679
162 3771
163 3863
164 3955
165 4047
166 4147
167 4239
168 4332
169 4424
170 4517
171 4609
172 4726
173 4843
174 4935
175 5027
176 5131
177 5235
178 5327
179 5419
180 5511
181 5603
182 5695
183 5787
184 5879
185 5971
186 6063
187 6155
188 6247
189 6339
190 6431
191 6523
192 6615
195 6707
196 6741
197 6756
198 6789
200 6804
204 6820
209 6837
212 6874
216 6891
219 6928
223 6945
226 6982
230 6999
233 7015
237 7032
240 7048
244 7065
247 7081
251 7098
252 7154
253 7210
254 7252
257 7294
258 7361
259 7428
261 7495
262 7560
264 7615
265 7670
267 7725
268 7781
270 7837
271 7893
272 7966
275 8039
426 8954
495 9054
496 9144
500 9234
501 9324
502 9414
503 9504
504 9595
505 9686
506 9777
507 9868
508 9959
509 10050
510 10141
511 10232
512 10324
513 10417
514 10509
515 10601
516 10693
517 10785
518 10876
519 10968
520 11060
521 11152
525 11244
526 11278
527 11293
528 11326
530 11341
534 11357
539 11364
543 11382
547 11388
551 11394
555 11400
559 11406
563 11412
567 11418
571 11424
574 11475
578 11492
581 11850
585 11864
588 12222
592 12236
596 12242
599 12322
603 12342
607 12349
608 12384
609 12400
610 12434
612 12450
616 12466
620 12473
623 12670
627 12677
631 12684
635 12703
639 12710
643 12717
647 12736
650 12743
708 13063
730 13163
728 13169
734 13169
735 13175
736 13191
737 13207
739 13213
743 13245
744 13262
747 13279
748 13297
749 13317
750 13335
754 13352
760 13414
761 13432
765 13449
766 13465
772 13471
773 13509
779 13515
780 13553
786 13559
787 13596
793 13602
722 13656
815 14303
817 14303
832 14303
830 14309
836 14309
838 14649
843 14669
846 14676
849 14683
852 14690
853 14714
856 14721
863 14728
865 14757
866 14764
867 14771
868 14778
873 14790
878 15064
882 15097
884 15103
885 15121
886 15134
887 15152
889 15165
894 15172
897 15184
900 15250
904 15263
910 15325
913 15349
967 15560
968 15576
970 15608
825 15860
ANONYMOUS BLOCK:
library unit=81a6fc68 line=7 opcode=38 static link=0 scope=0
FP=16c3194 PC=81adeaf9 Page=0 AP=0 ST=16c31e8
DL0=16819c0 GF=16819e8 DL1=16819d0 DPF=16819e4 DS=820b1d64
DON library unit variable list instantiation
------ ------------ ------------- -------------
0 81a6fc68 16819e8 16751b0
1 822ae29c 16783f8 1678158
2 82481f94 167a354 1682638
3
scope frame
-------- --------
1 16c3194
version=43123476 instantiation size=36
line pcode offset
-------- ------------
4 14
5 43
6 48
7 65
***********END PLSQL RUNTIME DUMP************
oracle_at_oracle8> sqlplus
SQL*Plus: Release 8.1.5.0.0 - Production on Wed May 16 09:52:39 2001
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dati Tecnici
INET: dadostecnicos_at_hotmail.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Daemen, Remco
INET: R.Daemen_at_facent.nl
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed May 16 2001 - 04:39:44 CDT
