How many extents is too many?
From: Dana Stockler <stockler_at_ingdata.no>
Date: 1996/11/18
Message-ID: <3290C249.1A06_at_ingdata.no>#1/1
Received on Mon Nov 18 1996 - 00:00:00 CET
Date: 1996/11/18
Message-ID: <3290C249.1A06_at_ingdata.no>#1/1
How many extents (table and index) are considered too many?
I realize that the question is simplistic and that the answer
depends on many different factors. What I am interested in is
the varied experiences of the DBAs and gurus participating in
this newsgroup. What is the number of extents that makes YOU
decide that it is time to defragment a table or index?
Regards,
Dana Stockler
Home: Solstadlia 10, 1364 Hvalstad, Norway ((+47) 66 78 97 41)
Work: IngeniørData as, Strøket 9, 1370 Asker, Norway
Email: stockler_at_ingdata.no
Received on Mon Nov 18 1996 - 00:00:00 CET