Re: Oracle Caching

From: Joe Maloney <mpir_at_bellsouth.net>
Date: 27 Jul 2001 10:46:09 -0700
Message-ID: <d17bad25.0107270946.4358dad0@posting.google.com>

Two different areas.

Identical queries will execute faster because a new explain/execute plan does not have to be derived (and the SQL reparsed, etc.).

Irrespective of whether the query is reparsed or not, once Oracle determines what to look for and how to look for it, it checks the blocks in the SGA first.

woodworth_at_acm.org (Matt Woodworth) wrote in message news:<a063f3c2.0107270645.2c5d0a5c_at_posting.google.com>...
> One other thing.
>
> The oracle experts around here seem to think that the execute portion
> of the query will run faster if the same explain plan is followed.
> Even if different records are retrieved. Have you heard of that? Any
> thoughts?
Received on Fri Jul 27 2001 - 12:46:09 CDT