Database Comparisons with AWR Warehouse- Part II, Comparison Period Report

There are two ways to compare one database to another in the AWR Warehouse.  I covered the ADDM Comparison Report here and now we’ll go through the second one, which is much more involved and has us empowering the AWR Warehouse taking two AWR Warehouse reports and comparing two databases to each other. The AWR […]

Read More Database Comparisons with AWR Warehouse- Part II, Comparison Period Report

Database Comparisons Using AWR Warehouse Part 1- ADDM Comparison

A lot of my ideas for blog posts come from questions emailed to me or asked via Twitter.  Today’s blog is no different, as I was asked by someone in the community what the best method of comparing databases using features within AWR when migrating from one host and OS to another. There is a […]

Read More Database Comparisons Using AWR Warehouse Part 1- ADDM Comparison

IOUG Collaborate 2016! #C16LV

It’s that time of year again and the massive undertaking of the Collaborate conference is upon us.  This yearly conference, a collaboration between Quest, Oracle Applications User Group, (OAUG) and Independent Oracle User Group, (IOUG) is one of the largest conferences in the world for those that specialize in all areas of the Oracle database. […]

Read More IOUG Collaborate 2016! #C16LV

Extensive Elapsed Time for ASH Report

The other day I had a customer who was to send me an ASH report after there was a challenge in providing me EM Diagnostics from their repository database.  After the report hadn’t been submitted after a number of days, the customer admitted that they would execute an ASH report request and would subsequently kill […]

Read More Extensive Elapsed Time for ASH Report
March 10, 2016

One Comment

Displaying CPU Graphs For Different Time Ranges in Enterprise Manager

This question was posted in Twitter from @matvarsh30, who asked, “How can I display CPU usage over different periods of time for databases in Enterprise Manager?” Everyone loves their trusty Top Activity, but the product’s functionality is limited when it comes to custom views and this is what our user had run into. There are […]

Read More Displaying CPU Graphs For Different Time Ranges in Enterprise Manager

Management Packs, Restricted Use Licenses and the Enterprise Manager

There was a question posted on Oracle-l forum today that should have a blog post for easy lookup for folks.  Regarding your Enterprise Manager repository database, (aka OMR.)   This database has a restricted use license, which means you can use it for the Enterprise Manager repository, but you can’t add partitioning to it or […]

Read More Management Packs, Restricted Use Licenses and the Enterprise Manager

SQL ID Specific Performance Information

When you need to have information about one SQL_ID and don’t need everything and the kitchen sink, there are a few different ways to collect this via Oracle.  I’m surprised how rarely this is covered in performance tuning/optimization, (whatever the current “acceptable” term is for fixing a database when there are performance issues arise… J)  […]

Read More SQL ID Specific Performance Information
May 18, 2015

Tags: , ,

ASH Data and How Sizing an AWR Warehouse Can be Mitigated

When sizing the AWR Warehouse, one of my requirements is to have certain reports for a sampling of databases that will source the AWR Warehouse. This report provides me the right information to create the correct sizing requirements vs. any assumptions done with other choices. The report is the General AWR Information report and can be […]

Read More ASH Data and How Sizing an AWR Warehouse Can be Mitigated

SQLd360 with the AWR Warehouse

Mauro decided to give me another challenge-  run SQLd360 against the AWR Warehouse and let him know how it does straight “out of the box”.  It’s a simpler installation process than SQLTXPLAIN, you simply unzip and run, (no installation of any packages…) I chose a SQL_ID from one of the source databases loaded and ran […]

Read More SQLd360 with the AWR Warehouse

SQLTXPLAIN and the AWR Warehouse, Part I

Yeah, so I did it-  I installed SQLTXPLAIN, (SQLT) on the AWR Warehouse!  From previous experience with this fantastic tool, I was pretty sure I’d have some great new adventures with the AWR Warehouse data and I wanted to try and test out the AWR pieces of this tool with the Warehouse. This is a work […]

Read More SQLTXPLAIN and the AWR Warehouse, Part I

How to Use an ASH Report and Why

Active Session History, (ASH) reports are one of my favorite when investigating a performance issue.  The biggest challenge I think that faces many administrators is to know when to turn to an ASH report and how to use the report to diagnose an issue. Today’s example is brought to us thanks to a Workload replay […]

Read More How to Use an ASH Report and Why
February 9, 2015

One Comment

Working With AWR Reports From EM12c

I’ve had a recent request to write an update on working with AWR reports, so as promised, here it is! The Automatic Workload Repository The Automatic Workload Repository, (AWR) was one of the best enhancements to Oracle back in release 10g.  There was quite a goal put in front of the development group when they […]

Read More Working With AWR Reports From EM12c
January 30, 2015

Tags: , , 2 Comments

AWR Warehouse and SYSDBA

I’ve had a few folks ask me a similar question about the AWR Warehouse, occuring numerous times this week. “How can I limit what the user of the AWR Warehouse can view in the AWR Warehouse?” “How can I add source databases to the AWR Warehouse without DBA privileges?” This topic bridges into the area […]

Read More AWR Warehouse and SYSDBA
January 16, 2015

Tags: 3 Comments

Using ASH Analytics to View Blocked Sessions

When concurrency is the crippling factor in a database performance issue, often I’m told that viewing blocked sessions in Enterprise Manager is difficult.  The query behind, along with flash image generation in any Enterprise Manager can take considerable time to render and no matter how valuable the view is, the wait is something DBAs just […]

Read More Using ASH Analytics to View Blocked Sessions

AWR Warehouse, Status

So the AWR Warehouse patches are out, but documentation has not officially caught up to it yet, so as we appreciate your patience.  I thought I would post about what I went over in my webinar last week when I had the wonderful opportunity to speak to the ODTUG members on this feature that everyone […]

Read More AWR Warehouse, Status

AWR Warehouse Webinar from ODTUG

The webinar is over, but you haven’t missed out on everything I presented on the console feature, under the hood and behind the scenes! You can access the slides from today’s presentation, as I’ve uploaded them to slideshare and the scripts are easy to locate on the scripts page here on DBAKevlar. Thanks to everyone […]

Read More AWR Warehouse Webinar from ODTUG

AWR Warehouse in EM12c, Rel 4, Part II

So, there is a lot to cover on this topic and I hope Part I got you ready for more!  Part II, I’m going to cover the following areas of the AWR Warehouse: Installation Access ETL Load Process Installation Let’s start with Prerequisites: The AWR Warehouse Repository must be version 11.2.0.4 or higher. The Targets […]

Read More AWR Warehouse in EM12c, Rel 4, Part II