Need info on trace files, how to empty them!

From: Jerra <jerra_at_aland.net>
Date: 2000/09/21
Message-ID: <8qdsro$750$1@gandalf.alcom.aland.fi>#1/1

I have an app that is doing tables scans like there was no tomorrow.

Been tracing it.

Question:
Between runs I'd like to cp the trace file to another directory to be able to separate the different runs (index testing). The problem is that I don't know how to empty the file in use without getting into trouble when doing the next runs.

I tried "echo > trace.trc", it resulted in a file that tkprof could not interpret, a lot of empty rows in the beginning and no "header" in the file. I deleted the hoping that Oracle would create a new one but no, no trace output was generated for that run.

So do you have any good advice regarding this?

TIA! /Jerra

Solaris 2.6
Oracle 8.0.5.2.1 Received on Thu Sep 21 2000 - 00:00:00 CDT