Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Here is what I am looking for:

  • Works on Standard Edition i.e. No Diagnostic Pack.
  • Provides both current and historical performance data.
  • Good visuals for easy spotting of trends and presentation to management.

If you have used the tool, I would be interested in pros and cons you have discovered. I can come up with a list, but the insight of actually having used the tool is worth far more.

share|improve this question
    
Have you looked at the reports/graphs that come with SQL Developer? –  Jack Douglas Nov 1 '11 at 13:37
    
@Jack Douglas, Yes, and some of those are useful, although many of the nicer ones require EE and the Diagnostic Pack. Still there doesn't seem to be a report that gives a broad overview of the system with the ability to drill down into specifics. –  Leigh Riffel Nov 1 '11 at 14:58
    
You can define your own too - though I'm afraid I don't have any experience actually doing so. –  Jack Douglas Nov 1 '11 at 15:45
    
I haven't done much either, but I'm sure something could be cobbled together, though it would never be as nice as a product designed for the functionality. –  Leigh Riffel Nov 1 '11 at 16:21
    
If anyone has experience with Embarcadero DB Performance Center, BMC ProactiveNet Performance Management, Precise, WISE or any other applicable performance tool, please add an entry. –  Leigh Riffel Nov 4 '11 at 16:51
show 1 more comment

7 Answers

Foglight Perf.Analysis for Oracle is a great performance workload tool which digs very deep into Oracle via Stealthcollect technologie direct from server memory areas, so no much overhead load in the database, also possible to review historical data, change tracking, advisories and much more...

Foglight screenshot from Webcast Foglight screenshot from pdf

StealthCollect – Delivers deep SQL-level collection and analysis at a fraction of the overhead of running a trace or executing direct SQL against production.

Performance Advisories – Reviews workload data and produces custom reports to maximize performance through built-in analytics and business intelligence.

IntelliProfile – Tracks database behavior and identifies abnormal activity with a sophisticated baselining algorithm.

Statement-Level Wait-Event Analysis – Reveals wait-event data down to the statement level, speeding resolution of resource-related performance problems.

QuickCompare – Provides a shortcut for identifying the root causes and symptoms of performance deviations in application environments.

Integrated Reporting – Provides targeted, built-in reports. With easy-to-use wizards, you can define, customize, generate, schedule, and deliver reports on system health, performance, trends, changes, and a variety of other topics and data points.

Long-Term Performance Repository – Delivers unlimited performance and environmental data storage and dimensional analysis in an Oracle database.

Automated Change Tracking – Identifies and sends notifications of changes to server, instance, database, schema environments, and application SQL degradations.

Please also take a look at Spotlight on Oracle (RAC) is real time diagnostics from an Oracle architecture level.

We use these tools with Oracle healthchecks and performance investigations.

Pros:

  • Response time analysis
  • Server Based
  • RAC Aware

Cons:

  • Cost
share|improve this answer
    
Hi Donald and welcome to dba.se - thanks for your contribution here and please may I ask that you disclose your affiliation with any company involved in producing or selling tools you endorse, if any affiliation does exist. If not please say here to that effect and I'll remove my comment! –  Jack Douglas Nov 4 '11 at 14:35
    
Thanks Donald for the post (+1). Since you have experience with the product could you list any cons? Is it difficult to setup, does it cost a lot, are there annoying aspects to it, etc? –  Leigh Riffel Nov 4 '11 at 16:07
add comment

Note: I've never used this, so please edit this answer if you have.

Lab128

Screen Capture of Application A

Screen Capture of Application B

Lab128 provides additional savings by implementing ASH functions and not requiring the purchase of ODP.

Pros:

  • Response Time Analysis
  • RAC support
  • Agentless
  • Only $299 for a named user connecting to two instances and only $499 for a named user connecting to an unlimited number of instances.

Cons:

  • Interface isn't very polished.
  • Lack of alerts.
  • One writer/maintainer.
  • No web interface.
  • Not server based.
share|improve this answer
    
This looks like pretty good value for money. I think I'll recommend it to my company for a trial. –  Andrew not the Saint Feb 17 '13 at 2:24
add comment

Ignite by Confio Softwar.e From their website:

Ignite for Oracle is the one Oracle database performance monitoring solution that identifies, analyzes and resolves all of the performance problems affecting applications and users depending on an Oracle database.

Ignite doesn’t just show health metrics, it correlates the most important performance data to build a complete picture of Oracle database performance for the DBA, Developer and DBA manager. Response time, queries, sessions and server resources, are all analyzed by Ignite Performance Intelligence to show both historical and real-time conditions affecting database applications.

enter image description here

Pros:

  • Response Time Analysis
  • Agentless
  • Server Based
  • Web interface
  • Free Version for basic info
  • Can be RAC and/or VMWare aware

Cons:

  • Drilldowns not as in depth as OEM
  • Users must be maintained independently
  • Cost
share|improve this answer
    
I vote for it, though I've used it only for MS SQL and only its free version. It's a great tool for getting a nice picture of what's happening now on the server. –  Marian Nov 2 '11 at 18:37
add comment

Note: I've never used this, so please edit this answer if you have.

WISE (Workload Interface Statistical Engine) uses Statspack to show graphical performance trend information.

WISE Screenshot 1

WISE Screenshot 2

Pros:

  • Response Time Analysis
  • Enterprise Edition - $349/database or $3,900/unlimited.
  • Server based.
  • Alerts.

Cons:

  • Interface isn't very polished.
  • Web interface is extra cost and doesn't have all the features.
  • Not RAC Aware
share|improve this answer
add comment

MindArray IPM by MindArray Systems

two muppets

Pros:

  • Response time analysis

  • Server Based

  • RAC support

  • Free Version for basic info

  • Allows a specific time range selection

  • Easy To Use

Cons:

  • Not a Open Source
share|improve this answer
    
Do you have any affiliation with this vendor/product? –  Colin 't Hart Apr 9 at 10:09
add comment

ASHViewer is a free alternative. Description from the readme:

ASH Viewer provides graphical Top Activity, similar Top Activity analysis and Drilldown of Oracle Enterprise Manager performance page. ASH Viewer store ASH data locally using embedded database Oracle Berkeley DB Java Edition.

ASHViewer Screenshot

It may seem that an application called ASH Viewer wouldn't work with Standard Edition because it does not have the Diagnostic pack and therefore does not have v$Active_Session_History, but it does. When a new connection is created it asks whether the target is Standard Edition or Enterprise Edition. If Standard Edition is selected it does not use v$Active_Session_History. This can be demonstrated by querying the view with control_management_pack_access set to NONE, which among other things causes the view to return no records.

Pros:

  • Free
  • Allows a specific time range selection (OEM can't do this)

Cons:

  • Not server based (Statistics collection is repeated for each user)
  • No web interface
  • Requires the equivalent of System level privileges
  • Interface isn't very polished (Font stretching, OS integration, etc.)
  • Not RAC aware (must run separately for each instance)
share|improve this answer
add comment

dbTrends for Oracle STATSPACK provides cost-effective database monitoring and tuning solution for companies which do not have very expensive Oracle tuning and diagnostic packs licenses required to access AWR. dbTrends is based on free STATSPACK engine that does not require additional licensing. dbTrends provides much more insights into AWR and STATSPACK performance data comparing with standard Oracle Enterprise Manager or third party vendors and allows to quickly identify performance trends and issues by comparing "good" and "bad" intervals of database operation. dbTrends is an ideal software tool for Oracle consultaning companies which manage remote customers' databases. dbTrends provides unique functionality to compare and analyze standard text performance reports generated by Oracle AWR and STATSPACK tools.

dbTrends for Oracle STATSPACK dbTrends for Oracle STATSPACK

share|improve this answer
1  
This reads more like an advert than a review. –  Jack Douglas Oct 23 '13 at 10:48
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.