RE: Pl/SQL runtime dumps

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Wed, 7 Apr 2004 12:36:23 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A1CE0AA9F@USAHM018.amer.corp.eds.com>

But the error appears to be an Oracle 01652 which is basically an error on getting sort space.

01652, 00000, "unable to extend temp segment by %s in tablespace %s"

Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jamadagni, Rajendra Sent: Wednesday, April 07, 2004 11:40 AM To: oracle-l_at_freelists.org
Subject: RE: Pl/SQL runtime dumps

Here is a sample ...

*********START PLSQL RUNTIME DUMP************ ***Got ORA-1652 while running PLSQL***
PACKAGE BODY ST_DVDB2.STWRITER_PKG:
library unit=3D7000000299d4960 line=3D599 opcode=3D153 static link=3D0 = scope=3D1
FP=3D110592110 PC=3D70000003689c778 Page=3D2 AP=3D1104e4b70 = ST=3D1105949f0
DL0=3D110591088 GF=3D110591288 DL1=3D110591178 DPF=3D110591270 DS=3D700000057bedd58

DON library unit variable list instantiation
------ ------------ ------------- -------------

     0 7000000299d4960     110591288     1104fd0b8
     1
     2
     3
     4 70000002c3b5150     1104f40d0     1104fe2e0
     5 7000000214f6668     110595328     110594e10
     6
     7
     8 70000002a7c1b78     1105a2be0     1105a27b8
     9
    10
    11 70000002aaa4770     110a62ae0     110a627b8

    12
    13
    14 70000002a6ae1b0 110a60a80 110a605f8     15
    16
    17
    18
    19 70000002ad57fc0 1104ef8e0 1104ef3f8     20
    21
    22 70000002152df90 1104fc3d8 1104ff7f8     23
    24
    25 70000002aabb0f8 110a5ef18 110a5f4f8     26
    27
    28 70000002ad438f8 1105987b8 11059e438     29
   scope frame
-------- --------

       3        0
       2 110592110
       1        0
package variable  address     size


---------------- -------- --------

               0 110591368       16
               1 110591378       24

Raj

--------=20

Rajendra dot Jamadagni at nospamespn dot com=20 All Views expressed in this email are strictly personal.=20 select standard_disclaimer from company_requirements;=20 QOTD: Any clod can have facts, having an opinion is an art !

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Bobak, Mark Sent: Wednesday, April 07, 2004 11:35 AM To: oracle-l_at_freelists.org
Subject: RE: Pl/SQL runtime dumps

Well, clearly, by asking this question, I'll identify myself as one on the opposite end of the spectrum from the dump reading experts....

What is a PL/SQL dump? How do you take one? What does it contain?

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI
"Post Hoc Ergo Propter Hoc"

-----Original Message-----

From: Jamadagni, Rajendra [mailto:Rajendra.Jamadagni_at_espn.com]=3D20 Sent: Wednesday, April 07, 2004 11:30 AM To: oracle-l_at_freelists.org
Subject: Pl/SQL runtime dumps

Does anyone know how to read the pl/sql runtime dumps ??=3D20 There are = so
many 'dump' readers (experts) on this list, someone ought to have read a pl/sql dump instead of block dump ...=3D20

Thanks in advance
Raj

--------=3D20

Rajendra dot Jamadagni at nospamespn dot com=3D20 All Views expressed in this email are strictly personal.=3D20 select standard_disclaimer from company_requirements;=3D20
QOTD: Any clod can have facts, having an opinion is an art !

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------





----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com


----------------------------------------------------------------

To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Wed Apr 07 2004 - 14:40:24 CDT