Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: OEM Implementation Plan

Re: OEM Implementation Plan

From: Joel Garry <joelgarry_at_anabolicinc.com>
Date: Tue, 19 Oct 2004 09:42:31 -0700
Message-ID: <FF740DD879899E418DE668EE8B6A201FAE17@lf-mail.anabolic.inc>


I think 9i OEM tuning and performance are well worth it, as long as you understand that some things are just plain wrong - you must have an educated, critical eye. They are mostly minor things, but occasionally they happen to have major effects when used on a particular problem with high visibility.

Some of the Oracle tuning is based on myths (google for Oracle Tuning Myths). Explain plans can lie. Tablespace mapping can give a flawed idea that fragmentation is happening, or that reusable space is used up. Session killing may not be the optimal way to kill sessions. Databases can be corrupted (for example, if OEM gets croaked while extending a datafile). Help may be overgeneralized, wrong, or difficult to find things in. And like any GUI tool, details and concepts may be lost in translation.

The combination of OEM and proficiency with command lines is a decent one. Once you have RMAN and a few databases then you might as well have OMS, even if some of the agency is a little strange. The monitoring makes pretty pictures for management.

http://www.garry.to

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 19 2004 - 11:38:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US