db file sequential/scattered read

From: Ivan Bajon <bajon_at_nospam@worldonline.dk>
Date: Wed, 10 Jan 2001 10:20:19 +0100
Message-ID: <93h9gi$eof$1@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:20:19 CST