If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

I have one single table in the database that I have been inserting data into. I think it's growing gradually. Is there any easiest and simple way to find out if it is reaching the maximum space allocated to it(e.g. either using dba views or V$ tables or any other easy way)?

another thing you can do is analyze the table (analyze table xxx compute statistics) and then look in dba_ or all_tables. (select * from all_tables where owner = 'xxx' and table_name = 'yyy').

you will see stats in there about # of rows, blocks, empty blocks, etc.

If you build a table to store these results every time you do an anlyze (insert into... select * from dba_tables where owner = 'xxx' and table_name = 'yyy') then pretty soon you can see how the table changes over time.

Check [url]http://www.lacroe.com/code_lib/index.html[/url] There is a downloadable
script there called "check_daily", it has scritps that will help you monitor
your database on a day to day basis. It also contains scripts to list tables
that are nearing max extents etc..