Re: parallel update and db file scattered read

Hi Srivenu ,

Thank you very much for your help.

My original query has two tables:

1. the table that is updated
2. the table that is selected.

I did not check for which of these tables db file scattered read is used , i will monitor it. The update operation must occur in sga , can you comment about the select part? Why does select operation not bypasses the sga ?

--Now if direct read occurs for the block how does oracle deal with
this
--scenario ?

When direct path read occurs , before reading the data from the disk , first slaves flush the blocks which have been updated but not yet written to disk from sga to disk.

Kind Regards,
tolga

slaves force blocks which have been updated, Received on Thu Nov 10 2005 - 01:27:14 CST