Re: files which cause oracle to trace???

What sort of trace do you want? SQL*Net trace? Turn on trace to capture statistics for tkprof?

For tkprof you can use the alter session set sql_trace=true command and then execute the
SQL statement(s) you want to trace. Then do an alter session set sql_trace=false statement
from the SQL prompt when you are done. The trace file will be placed in the udump directory specified
in the init.ora file.

I can't remember how to turn on sql trace for sql*net. It's probably in the init.ora file but I'm
sure someone else knows. Received on Mon Sep 18 2000 - 09:07:49 CDT