Leslie,
The supplied events are written in TCL.
For a description of the events and the associated TCL file names see Metalink notes
69563.1 and 69592.1.
The event you mention is:
"
TBSPFULL.TCL
Type : Database Event script.
Versions : OEM 1.6 onwards
Purpose : Signals the console if a tablespace is full.
Note : Requires database credentials
Errors :
NMS-1015 - tablespace allocation data could not be obtained from
the database.
NMS-1020 - tablespace data could not be obtained from the
database.
Directory: $OH/network/agent/events/oracle/rdbms/space
"
Please let the list know if you can confirm an issue in this script.
Regards,
Bruce Reardon
-----Original Message-----
Sent: Tuesday, 12 March 2002 7:58
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;
-
Author: Leslie Lu
INET: [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
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).
