RE: LOCALLY MANAGED EXTENT PERFORMANCE

From: Dogan, Ibrahim - Ibrahim <Ibrahim.Dogan_at_Lowes.com>
Date: Mon, 25 Apr 2005 16:58:54 -0400
Message-ID: <61C900F558E4184DBD8E177CC9D51F67035D76E1@msexdb06.lowes.com>

No, it tells you the last extent size. That's pretty much your next extent in aoutoalloc LMT unless it is switching to next gear which will be just couple of times during the lifetime of a table..

I'm still waiting your "alert" code...

Thanks,
=20
Ibrahim DOGAN
Sr. Sybase/Oracle DBA
www.lowes.com

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org=20
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman
> Sent: Monday, April 25, 2005 4:39 PM
> To: oracle-l_at_freelists.org
> Subject: Re: LOCALLY MANAGED EXTENT PERFORMANCE

>=20
>=20

> Doesn't do the job. This only tells me what the largest=20
> extent sizes are for segments. It does not tell me whether=20
> any of them are possible to run out of space within "N" extensions...
>=20
...
>=20

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Apr 25 2005 - 17:03:12 CDT