[EMAIL PROTECTED] 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: [EMAIL PROTECTED]

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

Reply via email to