I am finally getting to practice some of the tracing functionality that is discussed here and ran into something I haven 't seen dicussed here. We had a complaint about a query that performs inconsistently and I enabled my session trigger on user logon to capture it. The server failed at a point shown below. The first entry is the alert log entry. The second is my trigger. The third is an error that is appearing frequently in my trace and lastly is the error that crashed the server. We have turned off tracing and haven 't had any other errors. Any thoughts? I haven 't submitted a TAR yet because I would like to know that it 's not something I am doing. I will submit one if advised because I want to be able to confidently use the tracing methodology. I
Errors in file d:\oracle\admin\nedssarp\udump\nedssarp_ora_2676_cognosop.trc:
Thu Jul 29 13:23:14 2004
Errors in file d:\oracle\admin\nedssarp\udump\nedssarp_ora_688_cognosop.trc:
ORA-12801 (See ORA-12801.ora-code.com): error signaled in parallel query server P002
ORA-27153 (See ORA-27153.ora-code.com): wait operation failed
ORA-27300 (See ORA-27300.ora-code.com): OS system dependent operation:spwat failed with status: 6
ORA-27301 (See ORA-27301.ora-code.com): OS failure message: The handle is invalid.
ORA-27302 (See ORA-27302.ora-code.com): failure occurred at: skgpwopwait
***********************************************************************************************************************************************
*** SESSION ID:(20.3685) 2004-07-29 13:23:08.828
APPNAME mod= 'impserver.exe ' mh=0 act= ' ' ah=0
=====================
PARSING IN CURSOR #5 len=68 dep=2 uid=0 oct=42 lid=0 tim=18446744069886947494 hv=2212335334 ad= '4f558260 '
alter session set events '10046 trace name context forever, level 8 '
END OF STMT
EXEC #5:c=0,e=73,p=0,cr=0,cu=0,mis=0,r=0,dep=2,og=4,tim=18446744069886840263
=====================
PARSING IN CURSOR #3 len=345 dep=1 uid=0 oct=47 lid=0 tim=18446744069886993066 hv=3240680083 ad= '48cc978c '
BEGIN
IF USER = 'COGNOSOP ' THEN
EXECUTE IMMEDIATE 'alter session set timed_statistics=true ';
EXECUTE IMMEDIATE 'alter session set max_dump_file_size= UNLIMITED ';
EXECUTE IMMEDIATE 'alter session set tracefile_identifier= COGNOSOP ';
EXECUTE IMMEDIATE 'alter session set events ' '10046 trace name context forever, level 8 ' ' ';
END IF;
END;
*************************************************************************************************************************************************
Error 1 ( non-fatal) frequently reoccurs throughout our tracing sessions.
