Re: UNDO poll - was undo segments vs. rbs

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 21 May 2004 01:39:08 +0300
Message-ID: <004701c43ebb$44109380$5af923d5@porgand>

> event="1555 trace name errorstack level 3"
> event="4031 trace name errorstack level 3"
> event="1652 trace name processstate level 10"
>
> Note though, that you will have to keep *all* event lines TOGETHER in the
> init.ora lines, otherwise only the last ones will take effect. (Same
problem
> with multiple utl_file_dir lines!)

If you use spfile and have to set all these events in spfile with a single command, you can issue all these event definitions in one alter system call, separating different events with a colon:

alter system set event='1555 trace name errorstack level 3:4031 trace name errorstack level 3:1652 trace name processstate level 10' scope=spfile;

Tanel.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu May 20 2004 - 17:36:08 CDT