Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: parallel update and db file scattered read

Re: parallel update and db file scattered read

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 9 Nov 2005 23:27:14 -0800
Message-ID: <1131607634.019129.113530@o13g2000cwo.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US