Re: SLA Trigger/Procedure

Jared.Still_at_radisys.com wrote:
>
> Ethan,
>
> That records the startup times, but does not record the time
> that the database was unavailable.
>
> What's needed is a 3rd party monitor that is not dependent
> on the database being up to record metrics.
>
> Jared
>

Jared,

  I am far from having given much thought to this interesting idea but you can possibly work around this by using utl_file to check background_dump_dest. If it's not recorded in the alert.log, you probably have a .trc file hanging around. This optimistically assumes of course that you do not let you alert.log file grow out of control, because the idea of reading with UTL_FILE a 300M+ text file is not properly exciting. In fact the solution might be some external procedure to do in C directory operations, stat() calls and the like.

-- 
Regards,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).