Oracle-L: OEM event/job occurence and script ???

From: Leslie Lu <leslie_y_lu_at_yahoo.com>
Date: Mon, 11 Mar 2002 12:58:22 -0800
Message-ID: <F001.00424EE6.20020311125822@fatcity.com>

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: leslie_y_lu_at_yahoo.com

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: ListGuru_at_fatcity.com (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). Received on Mon Mar 11 2002 - 14:58:22 CST