RE: OEM event/job occurrence and script ???

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

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

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