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 [mailto:[EMAIL PROTECTED]]
>
> 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?
