Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: files which cause oracle to trace???

Re: files which cause oracle to trace???

From: <Cherie_Machler_at_gelco.com>
Date: Mon, 18 Sep 2000 09:07:49 -0500
Message-Id: <10623.117249@fatcity.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US