Re: Oracle cache

From: <steveee_ca_at_my-deja.com>
Date: Thu, 21 Dec 2000 13:54:29 GMT
Message-ID: <91t22k$3ei$1@nnrp1.deja.com>

In article <3A41FE17.9A4A2A7B_at_Unforgetable.com>, Walter T Rejuney <BlueSax_at_Unforgetable.com> wrote:
> When a DML which performs an insert occurs, the engine will parse the
> statement and then build the row for insertion into the logical table
> located within the physical tablespace. So far so good.
>
> Question: If a query for that same row occurs almost immediately
> afterwards will Oracle physically read the table to get the values or
> will it recognize that the values are already in memory and pass the
> memory contents back to the caller?
>
> Hi Walter,

I hope I don't get flamed on this one..I believe that because the transaction is still in progress, the read consistent image for the select is taken from the rollback segment.

Best regards,

Steve

Sent via Deja.com
http://www.deja.com/ Received on Thu Dec 21 2000 - 07:54:29 CST