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

Home -> Community -> Usenet -> c.d.o.server -> Re: 'alter session set sql_trace=true' bug or feature ?

Re: 'alter session set sql_trace=true' bug or feature ?

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 22 Dec 2003 05:24:12 -0800
Message-ID: <cf90fb89.0312220524.3eb0d8d1@posting.google.com> 





SQL Trace is only used in those rare occaisons where you need to trace
each-and-every row touched to de-bug an SQL statement.



Sure, the SQL will run slower because it's writing every little detail
about the execution to a trace file. . . .



It's supposed to run slow because it's doing a LOT of work giving you
a detailed trace.
Received on Mon Dec 22 2003 - 07:24:12 CST












Original text of this message













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