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).
