The most recent content from our members.
I have been assigned a task to monitor the database of our company. We have around 25 SQL servers and I am currently looking for a tool to monitor the best. The major KPI's that we want to monitor are 1- CPU Wise Most Expensive Queries 2- Queries Having Most Physical Reads 3- Long Running Stored Procedures and Scripts 4-…
Hi, I have alerts set up on some Oracle databases that are checking for Long Running Transactions, but I'm only seeing time values as being parameters to set. I would like to be able to say, "and owner not equal to <some schema>", etc. The problem is I have Streams set up one of these databases, and of course, I'm…
DESCRIPTION This alert is for Oracle instances only and will tell you when SQL statements have executed more than a defined amount of time. This example uses a 300 second threshold, meaning any SQL statements that have been executing for longer than 300 seconds (5 minutes) will be alerted. The alert query executes against…
DESCRIPTION This custom report will list the Top N SQL statements in your instance by number of disk reads. To use this report, run it from SQL*Plus while connected to the Ignite repository database. SQL*PLUS SCRIPT select id, name from cond order by name; prompt Which Database ID accept DBID prompt Enter Start Date…
Description This procedure, when executed, will return all SQL statements for the given date range ordered by average execution time. Some have called this the "Log Running Query" report. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the…
It looks like you're new here. Sign in or register to get started.