I have questions about this one. When one of the tables runs out of room, which component monitor actually picks it up? Also the query looks like it is only monitoring the "SYSTEM" table:
SELECT SUM(fs.bytes) / (1024 * 1024) "Free (MB)",
df.tablespace_name "Tablespace"
FROM dba_free_space fs,
(SELECT tablespace_name,SUM(bytes) bytes
FROM dba_data_files
GROUP BY tablespace_name) df
WHERE fs.tablespace_name
= df.tablespace_name
AND fs.tablespace_name = 'SYSTEM'
GROUP BY df.tablespace_name,df.bytes
I troied to just add a monitor and replace SYSTEM with one of the other tables but get an error: "Oracle returned an error. ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"