Searching for SQL-Code or Tools for Tablespace Fillments

[appi]

Hi Folks,
I am searching for a great tool or maybe SQL-Code to retrieve data for tablespace-fillments of our databases. We need to have a flatfile, or sql-code which retrieve the data in a flatfile, which should be read from HP-Openview (without heading lines). HP-Openview should send sms if a defined percentage of fillment is reached.
I got some code, but I got no fitting data to encounters HP-OpenView to work.
We're using Oracle 8.05, 8.16, 8.17 and 9.20, but serious is 8.17.
Any suggestions welcome
regards
Uwe

 

[BJCooperIT]

If you are asking for a method to determine how full your tablespaces are (percentage full) then perhaps this web site will help you:

http://home.triad.rr.com/rhubarb/orasnap/main/tsusage.htm

Good luck! (select * from life where brain is not null)
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000

 

[appi]

Thanks BJ,
it works slightly okay, but the second part won't work.

SQL>
SQL> select 'TOTALS',
2 sum(a.BYTES),
3 sum(a.BYTES-b.BYTES),
4 sum(b.BYTES)
5 from sys.orasnap_ddf a, sys.orasnap_dfs b
6 where a.TABLESPACE_NAME = b.TABLESPACE_NAME;
from sys.orasnap_ddf a, sys.orasnap_dfs b
*
Error in Line 5:
ORA-00942: Table or View does not exist.
I don't even know how, but I think I can deal with the result.
thanks
Uwe

 

[BJCooperIT]

Make sure you are logged in with DBA privileges when running this script. (select * from life where brain is not null)
Consultant/Custom Forms & PL/SQL - Oracle 8.1.7 - Windows 2000