Re: Monitoring Oracle database tools.

From: Stefan Moeding <s.moeding_at_ndh.net>
Date: 07 Apr 2000 19:06:22 +0200
Message-ID: <87n1n5yh69.fsf_at_esprit.sfx.ddns.org>


Hi!
On Thu, 06 Apr 2000 21:41:07 GMT, Greg Stark <greg-spare-1_at_mit.edu> said:

> I'm looking for the same thin On the subject, has anyone had any
> experience with "precise" monitoring tools from precisesoft.com?

I'm working with the Precise/SQL tool for two weeks now and it looks better than any other performance monitoring tool I ever saw.

Instead of walking through v$-views it uses a different approach to get performance data. A process on your server maps the SGA into its address space like an oracle process (read-only). So it is merely a matter of scanning through oracle memory structures to gather data. The tool is capable of sampling up to 9 times per second and collect statistics abount all sessions and statements. We run it on a heavily used Compaq GS/140 with 4000 oracle connections and compared to other tools it uses only a fraction of system resources and no oracle resources.

With the collected data you can drill down on almost any parameter. It just a few mouse clicks from the general overview to the worst performing statement, disk or session. For every statement you get the aggregated cpu time, cpu wait time, memory wait time, i/o wait time, row lock wait time, table lock wait time, latch wait time, buffer wait time and some more. The charts give a clear picture what the system is really doing and where the time is spend.

If you want to add or modify an index, the tool can simulate the change because it keeps all execution plans in a Performance Warehouse. The simulation will give you all statements where the execution plan would change.

There are modules for Oracle Financial Applications, SAP R/3 and Peoplesoft available but I haven't seen those. A module for EMC storage is also available which allows a drill down from the datafile to the EMC Hyper- and Metavolumes.

Talk to Precise. They install the tool on your machine and will do a demonstration with your real live system.

-- 
Stefan
Received on Fri Apr 07 2000 - 19:06:22 CEST

Original text of this message