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_at_cosmiccooler.org>
> Date: 2004/05/03 Mon AM 11:47:02 EDT
> To: oracle-l_at_freelists.org
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
To unsubscribe send email to: oracle-l-request_at_freelists.org
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
-----------------------------------------------------------------
Received on Mon May 03 2004 - 10:51:46 CDT
