Re: Next Extent Failure Notification for Locally Managed Tablespaces

Hi

It is going to be somewhat difficult to do what you want, unfortunately. The allocation type you have means that the next extent size is indeterminate to the dba (hence the null value in next_extent column). We do know what *valid* values for the next extent are, but I am not aware of anyone who has determined reliably what size will be picked next. I'd welcome finding out if someone has determined this.

Richard Foote (I think) and I had a couple of different scripts which ran drops, extends etc. In his example system managed allocation efficiently reused space, in mine it didn't (which is to say I had 'holes' in the tablespace that could have been reused, except Oracle decided it wanted a larger next extent than (IMO) it should have done. I don't think we ever got as far as deciding why Oracle was picking the extent sizes that it did.

It probably doesn't help to point out that you can avoid this effort entirely with uniform extents does it?

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com

On Mon, 21 Jun 2004 22:48:35 -0600, Wales, Stephen (RTSI)
<stephen.wales_at_riotinto.com> wrote:


> 

> No - had I the luxury of doing it over, they would be.  But they are =

> ALLOCATION_TYPE =3D SYSTEM

> 

> Steve

> 

> -----Original Message-----

> From: oracle-l-bounce_at_freelists.org

> [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of DENNIS WILLIAMS

> Sent: Monday, June 21, 2004 2:05 PM

> To: 'oracle-l_at_freelists.org'

> Subject: RE: Next Extent Failure Notification for Locally Managed

> Tablespaces

> 

> Stephen

>    Uniform extents?

> 

> 

> 

> ----------------------------------------------------------------

> Please see the official ORACLE-L FAQ: http://www.orafaq.com

> ----------------------------------------------------------------

> To unsubscribe send email to:  oracle-l-request_at_freelists.org

> put 'unsubscribe' in the subject line.

> --

> Archives are at http://www.freelists.org/archives/oracle-l/

> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

> -----------------------------------------------------------------

>
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------