Re: Extents and Fragmentation

From: duffybj1@my-deja.com > >I'm a pretty new DBA, so if I sound ignorant, forgive me. > >In one of my busiest databases, we have a 40 million row table with 212 >extents (about 3 MB)and several 4-10 million row tables with close to >200 extents. From what I read read in the past two weeks, this is a >very bad thing. > >I am under the impression that I will soon need to bring down the >database, write out these tables, drop the tables, and import the >tables back in. The problem I have now was caused by someone setting >the first extent size to 8 pages; what is a logical setting? Should the >entire table fit into one extent? Ideally, everything would fit into one extent, but you could just set your initial and next size to be 1/10th of the total size of the tables....or some other fraction. You probably want to look at fragmentation as well... ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com