Re: Getting Oracle to tell me why it's unhappy

In <3AF74024.332D2D79_at_more.net> Ricky Sanchez <rsanchez_at_more.net> writes:

>In you init<sid>.ora file, put the following event
>event = "1401 trace name processstate level 10"
 

>Then bounce the instance and recreate the problem.
 

>If you can recreate the evil sql statement at will from a user session, then
>you don't have to bounce the instance. You just do this from a sql prompt:
 

>alter session set events '1401 trace name processstate level 10';
 

>Then recreate the problem.
 

>This will create a trap for an error 1401, which will force a process state
>dump into a trace file for the session that encounters that error. Buried in
>the maze of details will be the current sql statement.

OK, I feel stupid here :-(

I set up this trap, bounced the DB, waited for the event to happen (only happens once an hour), and now that it should have happened, I can't seem to find where this dump went :-(

Would it be a .trc file? I did a find for such, and did not find one that seemed to have the correct timepstamp.

I have the follwing setings in the init files for this isntance:

background_dump_dest    = /oracle_home/app/oracle/admin/pwhse/bdump
core_dump_dest          = /oracle_home/app/oracle/admin/pwhse/cdump
user_dump_dest          = /oracle_home/app/oracle/admin/pwhse/udump

Would it be in one of these? If so, I must be overlooking it.

And thanks again for the help. Received on Tue May 08 2001 - 09:33:36 CDT