"db file scattered read" and "db file sequential read" wait events

From: Roger Jackson <rjackson_at_wire.net.au>
Date: Tue, 10 Oct 2000 19:30:00 +1000
Message-ID: <8ruk6p$2nf3$1@news1.wire.net.au>

Hi.

While interpreting trace files using event 10046 I have observed the following:

During index scans the wait event is "db file sequential reads" and during table scans the wait event is "db file scattered reads"

Does anyone know why db file sequential read events refer to random reads, while db file scattered reads refer to sequential reads?

Should it be the other way around?

Thanks in advance.

Cheers,

Roger. Received on Tue Oct 10 2000 - 04:30:00 CDT