Stabilizing Migrations to the Cloud with SQL Baselines
I had a customer who needed to know how to retain performance after migrating to the cloud for SQL execution
Read More
Making Technology Bulletproof
ASH and AWR
Prepping an Oracle Database for a Cloud Migration
There’s so much I need to get written down these days, but there’s only so many hours in a day
Read MoreThe Layman’s Term Guide to AWR for Microsoft- Part I
As often as I use the Automatic Workload Repository(AWR) data in my day-to-day job at Microsoft, I think most can
Read MoreDatabase 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
Read MoreDatabase 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
Read MoreIOUG Collaborate 2016! #C16LV
It’s that time of year again and the massive undertaking of the Collaborate conference is upon us. This yearly conference,
Read MoreExtensive 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
Read MoreDisplaying 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
Read MoreManagement 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.
Read MoreSQL 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
Read MoreASH 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
Read MoreSQLd360 with the AWR Warehouse
Mauro decided to give me another challenge- run SQLd360 against the AWR Warehouse and let him know how it does
Read MoreSQLTXPLAIN and the AWR Warehouse- Part II
I finally have a moment to look into my “hacked” SQLT XPRECT/XTRACT runs and see if the changes I made
Read MoreSQLTXPLAIN 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,
Read MoreHow 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
Read MoreWorking 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!
Read MoreAWR Warehouse and SYSDBA
I’ve had a few folks ask me a similar question about the AWR Warehouse, occuring numerous times this week. “How
Read MoreUsing 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
Read More