Seems to be hard to find some doc about Oracle trace.
I still don't know what it does and how it can be useful. If someone could
help !
I just remember than on older versions of Oracle 7.x ( before 7.3.3 I think
), letting these files grow can lead to some performance problems, so,we are
deleting these files, thus stopping Oracle trace feature.
> ----------
> From: Smith, Andy[SMTP:andy.smith_at_gwl.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Tuesday, July 11, 2000 00:39
> To: Multiple recipients of list ORACLE-L
> Subject: OTRACE Archeology
>
> I've been reviewing and rewriting some old cleanup scripts created by DBAs
> long since gone.
>
> For each 7.3 version database, they do the following:
>
> rm -f $ORACLE_HOME/otrace/admin/*.dat
>
> $ORACLE_HOME/bin/otrccref
>
> The first clears out three files, collect.dat, process.dat, and regid.dat.
>
> The second seems to reinitialize them.
>
> I've looked through the 7.3 docs, but can't find anything specific on
> this.
>
> Does anybody have any idea what these files are and is the above an
> appropriate thing to do on a nightly basis. The files do seem to grow
> over
> time.
>
> Thanks.
>
> --
> Author: Smith, Andy
> INET: andy.smith_at_gwl.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).
Received on Mon Jul 10 2000 - 19:33:10 CDT
