Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: Locally Managed Tablespaces

Re: RE: Locally Managed Tablespaces

From: Jared Still <>
Date: Sat, 22 Mar 2003 15:47:36 -0800
Message-Id: <>

AUTOEXTEND can be abused for sure, but it can also be a big time saver.

Say you want to load 100 gigabytes of data, and you have 5 disks to spread it out on. You opt for 5 files of 4 gig each on each disk.

That gives you 20 files to create in your tablespace. Creating 100 gig of datafiles takes awhile. If you start each file out as 500m with a next size of 500m and a max of 4g, you can defer the time spent creating the files to load time, rather than waiting around for 100g of files to be created before you start loading.

Still takes the same amount of time, but you get to go home earlier. :)


On Friday 21 March 2003 18:23, Jacques Kilchoer wrote:
> Well, my first suggestion would be to buy a software package from a
> reputable software company that lets you predict object growth and an
> estimate of when your tablespace will be full. Contact me for more details.
> :)
> But seriously, you can write a report that shows the number of extents and
> the amount of freespace in each tablespace, and review the report
> periodically (say once a week). Which is what I did back in my production
> DBA days. I imagine you could have a database procedure that checks the
> free space in a tablespace and sends you an e-mail, or even pages you if
> you have e-mail forwarded to a pager.
> Setting the datafiles to autoextend just pushes the problem back to the OS
> level - how do you know when your disks will be full?
> > -----Original Message-----
> > From: Ryan []
> >
> > so for normal business you should not use autoextend? You
> > should monitor it
> > yourself? What are some tips for monitoring the database to
> > see if you need
> > to extend your tablespace manually? Do you use DBMS_ALERT and
> > read the v$
> > views and then broadcast a message if you need to extend a tablespace?

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Received on Sat Mar 22 2003 - 17:47:36 CST

Original text of this message