RE: Precise

First a disclaimer (since this is going to sound like a love feast).  I do not have any ties to Precise Software Solutions nor do I receive any material gain from your purchasing decision.

We've been using it since day one of its release.  It has many of the features common to most application monitoring tools.  What those other tools can't do is prevent themselves from impacting the database.  Precise/SQL takes snapshots of the memory that makes up the SGA and interprets the internal data structures.  It doesn't need to connect and select from x$ or v$ tables and views.  This allows you to crank up the sampling interval to sub-seconds without any impact on your live instance; let me repeat that, without any impact.  If you've ever tried to execute those public-domain scripts to get Worst Offender SQL, Most Waits, V$SESSION_WAIT, etc. you know what I mean.  Then there is all of the nice filtering/capture/graphing/printing to boot.  We got our ROI on the first day we installed the tool.  We were able to detect an intermittent problem that kept eluding us.  The condition occurred so quickly that we couldn't catch it via V$ mere mortal methods, or was so severe that the database hung.  We cranked  up the sampling interval to something like 50 times per second to catch the problem.  We have a very complicated environment, from the DBA perspective (150+ databases, home-grown as well as PeopleSoft, Siebel, Retek packages, OLTP, DW, warehouse fulfillment, web-deployed Forms/Reports, ASP, JSP, OAS 4.8, an much more) and without this tool we wouldn't be able to turn around performance issues as quickly as we do.  Oh, and BTW, support is top-notch. These folks really got their act together.

On the down side you ask?  Pricing; eclectic user interface (if you're used to the Windows UI); another tool to manage; SQL tuning support for hints is cumbersome (we cut-n-paste into SQLLab and move on); you'll have to learn to tune from the resource consumption and wait time perspectives.  None of these are real show-stoppers, even pricing when you factor your increased productivity.

I didn't forget Pulse.  We have release 2.1.  Wait for the next release.  'Nuff said.

HTH Tony Aponte

-----Original Message-----

From: O'Neill, Sean [mailto:Sean.ONeill_at_organon.ie]

Sent: Tuesday, August 07, 2001 6:15 AM

To: Multiple recipients of list ORACLE-L

Subject: Precise

Is no-one on this list using Precise SQL or Precise Pulse?.  Has anyone

"heard" of them or evaluated them?.

Sean :)

Rookie Data Base Administrator

Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K

[0%] OCP Oracle8i DBA

[0%] OCP Oracle9i DBA

• ------------

Organon (Ireland) Ltd.

E-mail: sean.oneill_at_organon.ie   [subscribed: Digest Mode]

Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA

"Nobody loves me but my mother... and she could be jivin' too."  - BB King

-- 

Please see the official ORACLE-L FAQ: http://www.orafaq.com

-- 

Author: O'Neill, Sean

  INET: Sean.ONeill_at_organon.ie


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: ListGuru_at_fatcity.com (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).