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: VC <boston103_at_hotmail.com>
Date: Mon, 22 Dec 2003 22:27:31 GMT
Message-ID: <ndKFb.625200$Tr4.1618024@attbi_s03>


Hello,

"Geomancer" <pharfromhome_at_hotmail.com> wrote in message news:cf90fb89.0312220524.3eb0d8d1_at_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.

You are missing the point(s):

  1. In 8.1.7, no such 'overhead' was observed.
  2. Generally, something called overhead amounts to 5-10-15% of the payload. Here, 'sql_trace' is not overhead for a query, rather the query is overhead for sql_trace.

VC Received on Mon Dec 22 2003 - 16:27:31 CST

Original text of this message

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