The most recent content from our members.
Hi team- I know DPA captures all queries and transactions. I do see the stored procedures ran manually or scheduled ones in DPA - Find SQL. However, not able to see the same SPs if ran as a batch. Any thoughts why? Or do we have limitations on transactions/query pulling from DPA?
Description This alert will tell you when an SQL statement has executed more often than it normally does. This example uses a 200% threshold, meaning the SQL has executed twice as many times as normal. The alert definition uses the last 14 days for each SQL statement as the baseline for execution counts per day. It then…
Description This procedure, when executed, will return all SQL statements for the given date range ordered by the metric of choice. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored Procedure IF (SELECT…
DESCRIPTION This custom report will list the Top N SQL statements in your instance by number of executions. 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 alert will tell you when an Oracle monitored instance has a SQL that executed more often than it normally averages. This example uses a 200% threshold, meaning the SQL executed twice as many times as normal, as the critical level and 150%-200% as the warning. The SQL code in the alert definition uses the…
Description This procedure, when executed, will return all SQL statements for the given date range ordered by the number of executions. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored procedure into the Ignite repository database. Stored Procedure IF (SELECT…
It looks like you're new here. Sign in or register to get started.