Re: Oracle Enterprise Manager and the 4K block size
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx
- Date: Mon, 9 Aug 2010 08:07:25 -0500
EM has its uses. It is very slow, but that is only to be expected
considering the amount of network communication required. And, while I
suppose it may meet the technical definition of GUI (ie, uses a mouse), it
does not meet the more normal definition, that is a windowed interface. It
makes certain complex tasks easier, such as patch installation and agent
deployment, as well as backup and recovery. However, it is much slower on
the more basic tasks such as adding space or datafiles. The default
monitoring configuration monitors much more than is really needed.
The add-ons, such as the sql tuning are fairly useful. They can take a very
complex query and quickly identify any missing indices and such, the
execution profile is less useful as it often only works for a single case.
Jared Still commented that the Apps pieces were useful for those who are
primary database people, I suspect that the converse is true for those that
are primarily Apps DBA's. It also makes it possible for the tyros to handle
many of the basic DBA duties without much training, albeit much more slowly
than an experienced DBA.
All in all, I would say that OEM is just another semi-useful tool in the
DBA's tool kit.
On Mon, Aug 9, 2010 at 7:42 AM, Dunbar, Norman (Capgemini) <
norman.dunbar.capgemini@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
> Hi Niall,
>
> >> As it happens I'm in the middle - well near the end actually
> >> - of a Grid Control installation for a company that has
> >> invested quite heavily in the Oracle product stack....
>
> <SNIP Gory Details>
>
> So, summing up, is it (EM/GC) *really* fit for purpose yet?
>
> I'm a bit behind the times as I'm still looking after 734 and 9.2.x
> systems with a small smattering of 10.2.x on top, but plans are afoot to
> migrate everything (hooray) to 11g "some time real soon".
>
> I've also tended to avoid EM for many years - basically since they
> switched from a half decent (C?) implementation to Java. I'm wondering
> if I should try using it again yet?
>
>
> Cheers,
> Norman.
>
> Norman Dunbar
> Contract Senior Oracle DBA
> Capgemini Database Team (EA)
> Internal : 7 28 2051
> External : 0113 231 2051
>
>
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else. We have
> checked this email and its attachments for viruses. But you should still
> check any attachment before opening it. We may have to make this message and
> any reply to it public if asked to under the Freedom of Information Act,
> Data Protection Act or for litigation. Email messages and attachments sent
> to or from any Environment Agency address may also be accessed by someone
> other than the sender or recipient, for business purposes. If we have sent
> you information and you wish to use it please read our terms and conditions
> which you can get by calling us on 08708 506 506. Find out more about the
> Environment Agency at www.environment-agency.gov.uk
>
> Information in this message may be confidential and may be legally
> privileged. If you have received this message by mistake, please notify the
> sender immediately, delete it and do not copy it to anyone else.
>
> We have checked this email and its attachments for viruses. But you should
> still check any attachment before opening it.
> We may have to make this message and any reply to it public if asked to
> under the Freedom of Information Act, Data Protection Act or for litigation.
> Email messages and attachments sent to or from any Environment Agency
> address may also be accessed by someone other than the sender or recipient,
> for business purposes.
>
> If we have sent you information and you wish to use it please read our
> terms and conditions which you can get by calling us on 08708 506 506. Find
> out more about the Environment Agency at www.environment-agency.gov.uk
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
