|
[oracle-l]
||
[Date Prev]
[05-2004 Date Index]
[Date Next]
||
[Thread Prev]
[05-2004 Thread Index]
[Thread Next]
Re: testing sql and perf
- From: <ryan.gaffuri@xxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Mon, 3 May 2004 11:53:39 -0400
its compiling the sql the first time. So check it the second time. when oracle
compiles sql it hits the data dictionary several times. so your data is higher.
now if you are not using bind variables, then you are recompiling every time...
>
> From: "David Green" <thump@xxxxxxxxxxxxxxxx>
> Date: 2004/05/03 Mon AM 11:47:02 EDT
> To: oracle-l@xxxxxxxxxxxxx
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
|
|
