Hi all, I schedule an OEM event to be triggered every 1 minute, if condition meets. It did happen once, and I didn't make any change in the db, the event never got triggered again! How come?
Also do you know where are the scripts for OEM event/job? I have an event monitoring tablespace space, the alert shows a tablespace that is 1.7% full, but my script shows it's 70% full. That's way off! OEM 9.0.1 on Win2000. Thank you! Here is my script: select f.tablespace_name tablespace, sum(d.bytes/1000) bytes, sum((d.bytes/1000 - f.free/1000)) "Used", sum(f.free/1000) "Free", round((sum(d.bytes) - sum(f.free))/sum(d.bytes),2)* 100 "Used %", 100-(round((sum(d.bytes) - sum(f.free))/sum(d.bytes),2)* 100) "Free %" from dba_data_files d, (select file_id, tablespace_name, sum(bytes) free from dba_free_space group by tablespace_name, file_id order by tablespace_name) f where d.file_id = f.file_id group by f.tablespace_name; __________________________________________________ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Leslie Lu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).