DBA Kevlar

Tips, tricks, (and maybe a few rants) so more DBAs become bulletproof!

Raspberry Pi 2 Shopping List

I recently upgraded from the first edition Raspberry Pi to the new and improved Raspberry Pi 2 in a bundle Cana kit.  The Raspberry Pi 2 has a 900MHZ quad-core Arm Cortex A7, (ARMv7 processor instruction set) with 1Gb of memory, GPU is a 250MHZ Broadcom VideoCore IV, 1080p 30 h.264/MPEG-4 AVC high profile decoder […]

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 […]

,

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 […]

, ,

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 […]

,

DBAKevlar at Collaborate 2015

Here’s a quick guide to my schedule of sessions at IOUG Collaborate 2015 for this year.  I’m looking forward to seeing everyone next week, (I’ll be arriving on Saturday, so I really should say in a couple days) and have no doubt we’re up for another phenomenal conference at Las Vegas, this year at the […]

,

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 […]

, ,

SQLTXPLAIN 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 were enough to run properly with the AWR Warehouse. The answer is yes and no… and maybe “it depends”… The Results The data from the AWR Warehouse to pull the corresponding data for the appropriate […]

, ,

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 […]

, ,

One Year With Oracle

Just over a year ago, it became public that I was leaving Enkitec for Oracle.  Most folks had similar questions surrounding my decision, including my logic in giving up my ACE Director, an assumption that I would just disappear into the Oracle “machine”, considering the sheer size of the company and with my prominent company work […]

Distributed Transactions and EM12c Page Performance

While presenting at HotSos in Dallas, Tx, an attendee, (thank you Wenju! :)) asked how page performance issues could be identified when the call was being made remotely and not from the Oracle Management  Repository, (OMR) using the Page Performance console within Cloud Control. This is a very good question and although not straight forward, […]

,

RMOUG 2015 Training Days Review

I’m at HotSos Symposium 2015 speaking this week, so thought I would blog about the results of the conference I’m the director of and that finished up just two weeks ago.  I’m not admitting to being overwhelmed by OEM questions here, as I’m rather enjoying it.  I love seeing folks so into Enterprise Manager and […]

, ,

RMOUG’s First WIT Scholarship Winner

I’ve been running the Women in Technology, (WIT) at RMOUG, which I first started planning out in 2011, which has grown to include other user groups and even countries as its grown.  The last couple years, I’ve worked to try to add a WIT scholarship to RMOUG’s, but it wasn’t always easy to convince others […]

Everything I Needed to Know About Enterprise Manager I Learned at Collaborate 2015

Collaborate 2015 at the Mandalay in Las Vegas is just around the corner and the sheer amount of Enterprise Manager focused content is phenomenal!  Oracle partners and power users around the world come together each year to provide the lucky attendees the best in use cases, tips and technical know -how regarding the best infrastructure […]

, ,

Let’s Talk Database Replay- Part I

Database Replay is a feature in EM12c that a lot of folks are unfamiliar with, but once they learn about it, well, now then they figure out how valuable it really is.  Where the ADDM Comparison Report comes in really handy when you want to see what changed, think about how much more value there […]

,

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 […]

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 […]

, ,

Enterprise Manager and Services, Part I

The term “Service” is used to represent numerous objects within Enterprise Manager 12c.  Although the most common reference to the term is related to the Oracle Management Service, (OMS), in this blog post, we are going to drill down and refer to all services identified in the drop down menu from Targets, Management Services and Repository. The two […]

, ,

Cluster Cache Coherency in EM12c

January is winding down and RMOUG Training Days 2015 is just around the corner, taking up much of my after work hours. With that, we are going to discuss a great performance console in the EM12c cloud control-  Cluster Cache Coherency. Cluster Cache Coherency Optimization for an Oracle Real Application Cluster, (RAC) can be a […]

, , ,

Previous Posts Next posts

  • Facebook
  • Google+
  • LinkedIn
  • Twitter