ORA-3113 and PLSQL Runtime Dump

From: Dati Tecnici <dadostecnicos_at_hotmail.com>
Date: Wed, 16 May 2001 02:20:15 -0700
Message-ID: <F001.003048EB.20010516020555@fatcity.com>

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).

Received on Wed May 16 2001 - 04:20:15 CDT