Oracle cache

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? Received on Thu Dec 21 2000 - 06:56:55 CST