I was able to generate trace file with the following:
SQL> alter system set events '1410 trace name errorstack level 3';
Deepak
--- oracle-l-bounce@(protected) wrote:
> The message file is: > $ORACLE_HOME/rdbms/mesg/oraus.msg > I only mention it because I have been led to believe > that you can trace > any of those events/messages. > OBVIOUS WARNING: Be careful with some of those - > Oracle has stated that > you should only set them with direction from Oracle > Support > > > -- --Original Message-- -- > From: Schultz, Charles > Sent: Thursday, July 27, 2006 10:16 AM > To: 'sharmakdeep_oracle@(protected)'; > oracle-l@(protected) > Subject: RE: Tracing invalid rowid ora-01410 (See ora-01410.ora-code.com) > > I am thinking any of the errors can be traced with: > event="<nnn> trace name errorstack level <x>" > Not sure what the level would be for this error, but > you might be able > to start with 1. > > Now I just have to wait for someone to correct me if > I am wrong. =) I > know there is a mesg file in $OH that describes all > the events, but for > the life of me I cannot remember it. > > -- --Original Message-- -- > From: oracle-l-bounce@(protected) > [mailto:oracle-l-bounce@(protected)] On Behalf Of > Deepak Sharma > Sent: Thursday, July 27, 2006 9:58 AM > To: oracle-l@(protected) > Subject: Tracing invalid rowid ora-01410 (See ora-01410.ora-code.com) > > How do we force the generation of a trace file > whenever an error > (invalid rowid ora-01410 (See ora-01410.ora-code.com)) happens in the database. > Right now only some > of the ORA-01410 (See ORA-01410.ora-code.com) show up in alert log, but not all. > Is there a 'alter > system set event <nnn>' that can be done to achieve > this? > > Thanks, > Deepak >
__ ____ ____ ____ ____ ____ ____ ____ ____ ____ __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- http://www.freelists.org/webpage/oracle-l
