Re: Trace files ...

From: Mark D Powell <mark.powell_at_eds.com>
Date: 28 Aug 2002 05:58:14 -0700
Message-ID: <178d2795.0208280458.2a1c1735@posting.google.com>

"Epicentre team A" <oracle_at_epicentre.fr> wrote in message news:<akhs0k$71h$1_at_wanadoo.fr>...
> Hi
> How to avoid "Trace file full". in trc file ?
>
> Epicentre Team A

Are you asking about how to keep the trace directory from filling or individual trace files from hitting their limits?

Oracle trace file size is limited by the setting of the init.ora parameter: max_dump_file_size. If your trace output hits this limit Oracle stops writing to the trace file. The v$parameter views shows that you can increase the limit at the session level if you know that your trace will exceed the system wide limit before you run a trace job.

If you are worried about or having problems filling the trace directory then the three things I can recommend are 1 - set the max_dump_file_size parameter to a reasonable size; 2 - allocate the trace directory to a file system that has adequate room, and 3 - run a daily or perhaps more frequent job that removes old trace files and perhaps files that exceed a certain limit.

HTH -- Mark D Powell -- Received on Wed Aug 28 2002 - 07:58:14 CDT