ASH Reports

Getting Global Ash Reports Welcome to the first post for 2019. Continuing in the series on how to automate the creation of useful database reports, such as AWR reports in 30 seconds flat – Part 1, today I thought I

Tagged with: , , , ,
Posted in Oracle

AWR Reports in 30 seconds flat – Part 2

Getting Global (RAC) AWR Reports Last week, I discussed how to get AWR reports using the DBMS_WORKLOAD_REPOSITORY API. As promised, this week I want to share some code you can use to quickly spool out RAC AWR reports. A RAC

Tagged with: , , ,
Posted in Oracle

AWR reports in 30 seconds flat – Part 1

AWR reports. Fantastic huh? But, how do you get them? As usual, I think there is the easy way, and the hard way. The hard way involves logging in to Enterprise Manager, finding the AWR reports link, selecting the report

Tagged with: , , ,
Posted in Oracle

Getting IO latencies from AWR Pt2 – Histograms

Last week, in Getting IO Latencies from AWR – Part 1, I discussed how to get average IO latencies from the AWR, by querying DBA_HIST_SYSTEM_EVENT. And I mentioned how interpreting averages can be a little tricky. If you want a

Tagged with: , , , , , , , , ,
Posted in Oracle

Getting IO Latencies from AWR Pt1 – Averages

I was looking at a production issue recently where the latency of the IO subsystem was very much part of the problem. I was reminded of this query, and I thought I’d share it with you. What exactly does the

Tagged with: , , , , , , , , , , ,
Posted in Oracle

Running SQL using DBMS_SQL – Pt2

This is the second part of a series on Running SQL using DBMS_SQL. In the first installment – Running SQL using DBMS_SQL Pt1 I showed how to use a simple PL/SQL block, along with DBMS_SQL, to run a piece of

Tagged with: , ,
Posted in Oracle

Running SQL using DBMS_SQL – Pt1

 I want to share with a really simple block of PL/SQL code, that can be used to 1) run a SQL statement and fetch all the rows from it, and then 2) get the SQL monitor report for it. Why

Tagged with: , ,
Posted in Oracle

Analysing temp space issues with V$TEMPSEG_USAGE – Part 1

You’re at your desk, browsing the news headlines, when you receive a phone call from one of the users (OK it’s normally an email, but ignore that for now). “Our batch job has just failed!”, they shout, without introduction. “Someone’s

Tagged with: , , , ,
Posted in Oracle

SQL monitoring without SQL Monitor – Part 3 (SQL physical IO)

Hello again, This is the third and final part of a series on SQL Monitoring without SQL Monitor. In the first part ( SQL Monitoring without SQL Monitor – Part 1 (SQL temp usage) ), and second (SQL monitoring without

Tagged with: , , , , ,
Posted in Oracle

SQL monitoring without SQL Monitor – Part 2 (SQL duration)

Hello again, This is the second part of a series on SQL Monitoring without SQL Monitor. In the first part (which can be found here : SQL Monitoring without SQL Monitor – Part 1 (SQL temp usage) ), I discussed

Tagged with: , ,
Posted in Oracle