Re: object # of extents

From: Ben <balvey_at_comcast.net>
Date: 28 Jun 2006 11:28:23 -0700
Message-ID: <1151519303.043702.16410@i40g2000cwc.googlegroups.com>

gazzag wrote:
> Ben wrote:
> > > Frank van Bortel wrote:
> > > > Ben schreef:
> > > > > Running Oracle 9.2.0.5 Ent Ed, DMTs, UNIX AIX5L, compatible parameter =
> > > > > 8.1.0
> > > > >
> > > > On 9i, release 2, you should really get used to locally managed
> > > > tablespaces with auto segment space management.
> > > > In that case, you will probably never even *have* 1500 extents!
> > > >
> > > > And I start worrying at about 4000 (four thousand) extents. And
> > > > even then, I doubt it would be "a concern".
> > > >
> > > > --
> > > > Regards,
> > > > Frank van Bortel
> > > >
> > > > Top-posting is one way to shut me up...
> >
> > well, how about 8000 then?

> Other than a perceived excessive extent usage, what "problem" are you
> attempting to solve?

I was trying to find out if it IS a problem. I'm fairly new to being an Oracle DBA and this is something that I ran across, so I didn't know if it could possibly cause some problems if there are tons of extents. I would imagine if the datafiles for a tablespace are spread across several drives and a select had to query data from very many of those small extents it could possibly cause an I/O issue, couldn't it? Received on Wed Jun 28 2006 - 13:28:23 CDT