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?
A super common question I see on Thwack is "I see I had high CPU load at 2am last night, but I don't know what processes caused the issue. How can I find out what caused it?" I wrote this custom query to be used in conjunction this SAM template, CPU/MEM Process Snapshot Once you assign that template to the nodes you would…
Description This procedure, when executed, will return all SQL statements for the given date range and database user 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…
Hi all, I was able to put a filter to show only the network device on top XX interfaces by percent Utilization widget. However i want to add additional columns like a Custom property (City, etc) Can someone share inputs?
Description This procedure, when executed, will return all SQL statements for the given date range and database ordered by the wait time. The data also includes the database user, machine, program, SQL text, last execution date ad number of executions. See comments inside the procedure for more details on the parameters…
DESCRIPTION This custom report will list the Top N SQL statements in your instance for a specified O/S user name. 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 and program ordered by wait time. The name of the program should match content of the Programs tab within the Ignite GUI. See comments inside the procedure for more details on the parameters and methods for calling. Install…
Hello everyone, I am brand new to Orion and have been looking for a way to add a fixed/static banner across 100% of the top of all Orion pages and modules of what my organization has stood up prior to my presence here. I have a little bit of a web development background from around 15 years ago, so the first thing I…
I wanted to write this up quickly for others like myself that want a top 10 LUNs by Latency or IOPS with historical data, similar to below: To start with, go in to Customize Page at the top right hand corner of the page you'd like the graph. Personally, I chose the Performance Dashboard in SRM. Click on the green plus sign…
Description This procedure, when executed, will return all SQL statements for the given date range along with key statistics like executions, disk reads, logical reads and others ordered by the metric of choice. See comments inside the procedure for more details on the parameters and methods for calling. Install the stored…
It looks like you're new here. Sign in or register to get started.