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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: tuning doubts....

Re: tuning doubts....

From: Don Seiler <don_at_seiler.us>
Date: Thu, 4 Oct 2007 11:32:53 -0500
Message-ID: <716f7a630710040932p5ffd820dod1d07351eb0ef995@mail.gmail.com>


sequential reads are usually the result index lookups. scattered reads are large multiblock reads, think full table scans.

Don.

On 4 Oct 2007 13:36:56 -0000, Aman Sharma <amansharma81_at_rediffmail.com> wrote:
>
>
> hi there,
>
> What is
> 1) Db File sequential read?
> 2) Db file scattered read?
> how they are impactful in the tuning?
> thnks and regards,
> Aman....
> "As our circle of knowledge expands, so does the circumference of darkness
> surrounding it."-
> Einstein
> -------------------------------------------------
> Aman Sharma
>
>
>

-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 04 2007 - 11:32:53 CDT

Original text of this message

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