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@xxxxxxxxxxxxx=20 > [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Tim Gorman > Sent: Monday, April 25, 2005 4:39 PM > To: oracle-l@xxxxxxxxxxxxx > 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 -- //www.freelists.org/webpage/oracle-l