Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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