trace file

[lee]

Hi,
I wnted to know what exactly does a trace file do? Does it only report errors? Please help.

Thanks.

[mike73]

you can backup the controlfile to trace for recovery purpose

[marist89]

Typically, when you are talking about a trace file, you are talking about a SQL Trace. The Trace file will contain the queries being executed as well as timing information. To view this trace file in a readable format, you will probably use tkprof.

[lee]

I have a trace file which I was asked to look at. I am not sure for what.
Does it show any errors?

[marist89]

No, typically a SQL Trace file will not show errors.

[lee]

then what does it show?

[marist89]

The Trace file will contain the queries being executed as well as timing information. To view this trace file in a readable format, you will probably use tkprof.