The most recent content from our members.
When reviewing explain plans for Oracle key information which is really useful is missing such as the A-ROWS and E-ROWS. Is it possible for DPA to gather this information when monitoring the queries?
Would it be possible to change the Plan output for Oracle queries to display the Actual and Estimated rows as part of the capture that DPA does for each sql running? Alternatively if we can enable this feature temporarily if required for specific SQL it gives us much more useful information in identifying where in the…
I would like the ability to adjust what is considered warning and critical for queries like I can for resources. Reason being, I have a service health dashboard for management where I link the Network Atlas map directly to the backend database in DPA. Because I cannot adjust this threshold, the DPA monitored database is…
Does anyone have good solutions to an issue I'm experiencing with using DPA in and environment where the use of Grail/Hibernate by the developers is causing the queries to appear in DPA as different queries. This make it difficult to see trends. The queries are treated as different in DPA, since the SQL text is different.…
I'm trying to do some basic queries of an Oracle environment using the SAM Oracle Experience Monitor query and I'm finding it to be a little short on capability. While it does query successfully, we're having issues with how the Oracle Experience monitor components are configured. They state: Statistic: Value of the first…
It looks like you're new here. Sign in or register to get started.