I am usually "anti" tools due to the price mostly. However while I have quite a suite of components to quickly "surround" my Oracle DB's with monitoring, alerting, performance charting etc...I have no such toolkit for other databases. However, I am being confronted with situations where I will also be responsible for DB2, SYBASE and Informix databases. Large corporate customers want to see an integrated monitoring and reporting environment. In this case an off the shelf software solution can be my only choice.
- Ethan -----Original Message----- Sent: Thursday, February 21, 2002 1:44 PM To: Multiple recipients of list ORACLE-L I know of a couple of tools that show more info than the fixed views ;-) "Orr, Steve" wrote: > 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: Post, Ethan 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).
