StatsPack, V$SYSSTAT, V$SYSTEM_EVENT, V$SESSION_EVENT, V$SESSION_WAIT, trace files, and a good DBA... only the last item is not free. Take the money you save on tools and give it to the DBA. Sorry if this sounds flippant but is there anything which the tools provide via a GUI interface that isn't already available via the data dictionary, Oracle utilities and packages, and O/S utilities? In fact, most of the tools get their data from the same aforementioned sources. I've also gotten monitoring information from Oracle's supplied MIB's via SNMP just like OEM does but I used the pathologically eclectic rubbish lister tool. :-)
Tools are not a substitute... if I give you a hammer it doesn't make you a master carpenter. I guess it's a matter of preference. I like making my own tools, or "borrowing" scripts from others and adding them to my toolbox. Of course the commercial tools are more complete than my grab bag of stuff which is under perpetual development and I sometimes spend a lot of time trying to find a script amid the chaos of the unkempt toolbox. ;-) I know there one of those whatchamagizmos in there now where is it? Living in Big Sky Country without buffer zones... Steve Orr -----Original Message----- Sent: Thursday, February 21, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Can anyone give me an idea of what are the best Oracle instance monitoring tools on the market? Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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).
