Thanks, Dennis. I am with you on your point about GUI tools... --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Boris - I think John has an excellent point (as > always). I just remembered > that one vendor (can't recall which) has some sort > of "stealth" method to > directly sample the SQL buffer. They make a big deal > about how it doesn't > impact your system, so I would infer as John says > that with a large shared > pool this might be significant. > My point is to just collect the information that > is of value to you. If a > level 0 gets you everything you need, go with that. > When I suggest writing > your own routines, I'm not proposing that you could > collect all the > information STATSPACK collects more efficiently, but > if you only use one or > two pieces of information and you need a level 5 > snapshot to get it, then > you might consider a quick script to collect just > what you need. Also if you > need frequent snapshots to capture certain critical > data, you can avoid some > snapshots. > CPU cycles are meant to be used, so if snapshots > aren't affecting your > overall system, then what is the problem? Well, > unfortunately you would like > to collect statistics when the system is the > busiest. > I find STATSPACK to be the most useful when the > system appears "hung". > With the GUI tools you are still clicking screens > when the problem clears > itself up. You can take a couple of STATSPACK > snapshots and do damage > control on the people side in between. But man are > those snapshots SLOOOOW > when the system is about belly up. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED]
______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boris Dali 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).