Re: db file sequential/scattered read

From: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Wed, 10 Jan 2001 10:27:57 +0100
Message-ID: <93h9us$fqf$1@news.inet.tele.dk>

Correction:
It's 2.37 db file scattered read and not 2.36

"Ivan Bajon" <bajon_at_nospam@worldonline.dk> wrote in message news:93h9gi$eof$1_at_news.inet.tele.dk...
> Could someone please clarify whether full table scans cause waits for db
> file sequential read or scattered reads. I've seen claims on both.
>
> Steve Adams says:
> "Sequential reads occur mainly in connection with full table scans and
fast
> full index scans." (Taken from Tips->Disk Configuration for Sequential
Scans
> on Ixora)
>
> In "Description of Oracle7 Wait Events and Enqueues" (2.36 db file
scattered
> read) Anjo Kolk says:
> "This event is normally an indicator that a Full Table Scan is happening
on
> the object identified before."
>
> This leaves me confused. Which is it? Both?
>
> Regards,
> Ivan Bajon, ocp
>
>
Received on Wed Jan 10 2001 - 03:27:57 CST