Re: 10046 trace restart?

You can restart the trace.

If you ever need to do this on 8i+, ou can also 'alter system set max_dump_file_size=unlimited;'.

Jared

On Tuesday 13 August 2002 15:06, Baker, Barbara wrote:
> Can I stop and then restart a 10046 level 12 trace while the process is
> continuing to run?
>
> (After running for 1 hour, my dump file has reached it's limit, and I
> haven't hit the bad code yet. This version of OS/Oracle will not let me
> set dump file unlimited. It's a bug/feature.)
>
> I'd like to just stop the trace, delete the dump file, and restart the
> trace without killing the job and starting over (thereby losing the hour of
> processing I've already incurred.)
>
> I started the trace in svrmgrl with
> oradebug setorapid 10
> oradebug event 10046 trace name context forever, level 12
>
> OpenVMS 7.2-1
> Oracle 7.3.4.4
> Thanks for any help.
>
> Barb

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).