Re: Is there an Event for Capturing Oracle Errors in a Trace File?
- From: "biti_rainy" <biti_rainy@xxxxxxxxx>
- To: "zitelli@xxxxxxxxxxxx" <zitelli@xxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 17 Sep 2004 11:03:04 +0800
hi,Andrew V Zitelli
the EVENT# like sqlcode ,for example
select count(*) from (select * from member order by member_level)
*
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace FCPTEST
################
sqlcode = 1652
you can set event 1652
##########################
ALTER SESSION SET EVENTS '1652 trace name errorstack level 1';
or
alter system set events '1652 trace name errorstack level 1';
alter system set events '1652 trace name errorstack off';
then generate the trace file
[oracle@oradev udump]$ more ocndev_ora_15452.trc
/opt/oracle/admin/ocn/udump/ocndev_ora_15452.trc
Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production
JServer Release 9.2.0.3.0 - Production
ORACLE_HOME = /opt/oracle/products/9.2.0
System name: Linux
Node name: oradev
Release: 2.4.9-e.3
Version: #1 Fri May 3 17:02:43 EDT 2002
Machine: i686
Instance name: ocndev
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 15452, image: oracle@oradev (TNS V1-V3)
*** SESSION ID:(85.639) 2004-08-24 17:50:19.030
*** 2004-08-24 17:50:19.030
ksedmp: internal or fatal error
ORA-01652: unable to extend temp segment by 128 in tablespace FCPTEST
Current SQL statement for this session:
select count(*) from (select * from alibaba.member order by member_level)
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+269 call ksedst()+0 0 ? 0 ? 0 ? 0 ? 71417550 ?
70ECF9B8 ?
ksddoa()+446 call ksedmp()+0 1 ? AA703A8 ? 40622470 ?
674 ? 1 ? 406224D4 ?
ksdpcg()+521 call ksddoa()+0 40622470 ? AA703A8 ?
ksdpec()+220 call ksdpcg()+0 674 ? BFFE8D88 ? 1 ?
ksfpec()+133 call ksdpec()+0 674 ? 674 ? AA6D304 ?
Best regards
msn: biti_rainy@xxxxxxxxxxx
a dba from alibaba(china)
---- from the mail-----
>Is there an Oracle event that can be set, to capture the details of the
>database session's errors in a trace file ? Use of Oracle event 10046
>provides only a simple indication that an error was raised, but does not
>provide details. For example:
>
> EXEC
>#1:c=10000,e=10498,p=0,cr=10,cu=9,mis=0,r=0,dep=0,og=4,tim=1526794508053
> ERROR #1:err=1 tim=156343757
>
>I would like to capture the error number (e.g. ORA-12345) and pertinent
>text if possible. I do not require the entire error stack, simply the
>error as returned to a client application. Can anyone point me to details
>on an event like this? I am using Oracle 9.2 and 10.1 under Solaris.
>
>Kind regards,
>
>Andy Zitelli,
>Raytheon, Fullerton, CA
>
>--
>//www.freelists.org/webpage/oracle-l
>
>.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
