Re: Inconsistent multi-block io
- From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
- Date: Tue, 8 Jul 2008 17:03:44 -0700 (PDT)
Hi,
It is because,
1. The missing blocks may be already in cache
(If the block 5 is already in cache, you will see two multiblock reads
of blocks 1-4 and 6-16)
2. You may be hitting extent boundary
(multiblock reads can not spawn extents)
3. You may be hitting the last block
(or hitting HWM)
There may be some more, but these are the most common .
-Gopal
.
- Follow-Ups:
- Re: Inconsistent multi-block io
- From: maks71
- Re: Inconsistent multi-block io
- References:
- Inconsistent multi-block io
- From: maks71
- Inconsistent multi-block io
- Prev by Date: Few big or many small datafiles per tablespace?
- Next by Date: Re: Partitioning Best Practices
- Previous by thread: Re: Inconsistent multi-block io
- Next by thread: Re: Inconsistent multi-block io
- Index(es):
Relevant Pages
|