RE: Pl/SQL runtime dumps
- From: "Jamadagni, Rajendra" <Rajendra.Jamadagni@xxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 7 Apr 2004 11:40:26 -0400
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Bobak, Mark
Sent: Wednesday, April 07, 2004 11:35 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxx]=3D20
Sent: Wednesday, April 07, 2004 11:30 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
