RE: Oracle Enterprise Manager and the 4K block size
- From: "Stephens, Chris" <Chris.Stephens@xxxxxxx>
- To: "rjoralist@xxxxxxxxxxxxxxxxxxxxx" <rjoralist@xxxxxxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- 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! :)
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Rich Jesse
Sent: Monday, August 09, 2010 9:34 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Oracle Enterprise Manager and the 4K block size
Norm!
> 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
//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. :)
Enjoy!
Rich
--
//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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
