Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Who so much "db block gets" in Oracle 8i?
nothing is free.
if you enable sql_trace in your session and examine the resulting trace
file, you'll see the recursive sql executed in order to execute your
foreground statement.
If you re-execute the same statement that has already been parsed,
you'll likely see the amount of recursive sql decrease.
-bdbafh Received on Tue May 17 2005 - 00:45:30 CDT