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

AWR Warehouse Jobs in EM13c

As I’m playing with the AWR Warehouse in EM13c, I noticed a few changes that may send up a red flag and wanted to assist in removing those.  As many know, the AWR Warehouse is very dependent upon EM Jobs…even more so now that we’ve moved to EM13c.  The EM Job System has gone through […]

Read More AWR Warehouse Jobs in EM13c
February 29, 2016

Tags: ,

Re-Adding a Database to the AWR Warehouse Without Losing Historical Snapshots

There may be a reason that one needs to re-add a database to the AWR Warehouse.  This is a new opportunity for me to learn and offer assistance, but I’m working off the grid to figure out a solution.  Luckily, it’s just a matter of creating a new process from pre-existing code and processes. The […]

Read More Re-Adding a Database to the AWR Warehouse Without Losing Historical Snapshots

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

Kickstarting After a Failed Addition to the AWR Warehouse

A common issue I’ve noted are dump files generated from the AWR Warehouse, but upon failure to transfer, the dumpfiles simply exist, never upload and the data is stuck in a “limbo” state between the source database, (target) and the AWR Warehouse.  This can be a very difficult issue to troubleshoot, as no errors are […]

Read More Kickstarting After a Failed Addition to the AWR Warehouse

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

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