Re: help: local managed tablespace, next extent

From: joel garry <>
Date: Tue, 24 Sep 2013 08:42:49 -0700 (PDT)
Message-ID: <>

On Monday, September 23, 2013 1:02:46 PM UTC-7, wrote:
> Dear group,

> I have a tablespace which is 300G and devided into 15 datafiles.

> The tablespace is local managed.

> But recently when it expends, it took 14G of free space.

> How does Oracle decide next extent when it comes to datafile expansion? is this adjustable?

> Thanks for your help

> Charlie


Are you adding and modifying large objects? Are you using ASSM? You might be hitting bugs or application oddities. Always remember to state your exact oracle version. You can google Jonathan Lewis ASSM for some things to watch for.

You can modify the data file NEXT size with the ALTER DATABASE alter data file clause

This type of administration may be easier with dbconsole - almost too easy, so be careful.


-- is bogus.
These must be the end times:
Received on Tue Sep 24 2013 - 17:42:49 CEST

Original text of this message