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