RE: Oracle Enterprise Manager and the 4K block size
Date: Mon, 9 Aug 2010 09:55:11 -0500
I think using OEM to browse AWR data at all required diagnostics pack.
In fact, I think looking at AWR data through any tool (custom built or otherwise) requires diagnostics pack.
No dba_hist_* views for you! :)
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Rich Jesse Sent: Monday, August 09, 2010 9:34 AM
Subject: RE: Oracle Enterprise Manager and the 4K block size
> So, summing up, is it (EM/GC) *really* fit for purpose yet?
As everything in DBA World, it depends. I do like GC (10.2.0.3) for the ability to easily browse through its AWR-like repository to show me what happened in the DB days, weeks, or months (if one manages to find how to configure GC to extend the repository from its default values) ago. And, more importantly, *who* was running that particular statement that caused whatever issue. I just used this to see that we've been having significant library cache latch issues on Saturdays going back to at least April.
The downside is of course that GC never notified me of those latch contentions in the first place. See one of my rants at http://www.freelists.org/post/oracle-l/Extent-allocation-time-process-check,4 As an aside, those notifications do seem to require the Diagnostics Pack...
Sure, I could code something similar to the repository browsing, but I have other fun functionality to rewrite/workaround. :)
-- http://www.freelists.org/webpage/oracle-l CONFIDENTIALITY NOTICE: This message is intended for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If the reader of this message is not the intended recipient or the employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by email reply. -- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 09 2010 - 09:55:11 CDT