Is there any restriction
that the segments shouldn't cross more than 5 extents in oracle
7.3.
Pl. help me, as I heard
from somebody that the segments shouldn't cross more than 5 extents and my
indexes are in more than 20 extents.
Thanks in
advance
Anand
KumarDBA
ITW
Signode India
Ltd
Anand - This was the common wisdom several years ago. I used to rebuild
tables based on rules of thumb like this. Recently, several leading experts
have challenged this assumption, and now it is generally accepted that
trying to keep the number of extents below 5 wastes a lot of work for
nothing.
thanks a
lot...
- Original Message -
From:
DENNIS
WILLIAMS
To: Multiple recipients of list ORACLE-L
Sent: Sunday, December 01, 2002 4:03
AM
Subject: RE: Table - Extents
Anand - This was the common wisdom several years ago. I used to
rebuildtables based