Re: Moving/compressing *.trc files.

From: Matthias Hoys <anti_at_spam.com>
Date: Tue, 29 Jul 2008 19:31:28 +0200
Message-ID: <488f53fb$0$2864$ba620e4c@news.skynet.be>

"Frank R." <trek1s_at_gmail.com> wrote in message news:37021d84-44df-4108-998c-32a4d0c3bf7b_at_y38g2000hsy.googlegroups.com...
> Hello all,
>
> Is it safe to move/compress (gzip) *.trc files from oracle [b|u]dump
> directories while database instance is up?
>
> I'm getting some of these files growing much more than expected (due
> to a known bug...) and would like to know if i can safely move them
> automatically to another directory using an script or similar.
>
> Thanks in advance.
>
> Regards.

There might be a session still running with sql_trace=true (or a after-logon trigger ?). So you might check your system, this can negatively impact performance (and available diskspace ...).

Matthias Received on Tue Jul 29 2008 - 12:31:28 CDT

Original text of this message