EM12c and the Optimizer Statistics Console

Today we’re going to review another great feature in the EM12c that you may not have realized was available.  Once logged into a database target, click on the Performance menu and navigate to the Optimizer Statistics Console:

opt1

Optimizer Statistics Console Page

The new console page is clean, easy to navigate and has great access points to manage and monitor optimizer statistics for the given database target.

opt2

We’ll actually start at the bottom of the (more...)

How To Set EAR Upload Size for Oracle Enterprise Manager

By default, there is a limit for EAR upload size (~40 MB) in Enterprise Manager. If your ADF application is fairly big, you may face this limitation and will not be able to deploy through Enterprise Manager. Deployment for large EAR would work through WebLogic console, WLST script or directly from JDEV, however sometimes you may need to deploy through Enterprise Manager. I will describe in this post, how you could increase the limit - (more...)

EM12c Management Agent, OutOfMemoryError and Ulimits

While enjoying the lovely Liverpool, UK weather at Tech14 with UKOUG, (just kidding about that weather part and apologies to the poor guy who asked me the origin of “Kevlar” which in my pained, sleep-deprived state I answered with a strange, long-winded response…. :)) a customer contacted me in regards to a challenge he was experiencing starting an agent on a host that was home to 100’s of targets.

        oracle_database.DB301.com - LOAD_TARGET_DYNAMIC  (more...)

Instrumenting, Analysing, & Tuning the Performance of Oracle ADF Applications

Last week I presented at the  UKOUG’14 conference on instrumenting, analyzing, & tuning the Performance of Oracle ADF Applications. Instrumentation refers to an ability to monitor or measure the level of a product’s performance, to diagnose errors and to write trace information. Instrumenting gives visibility and insight of what is happening inside the ADF application and in the ADF framework (what methods and queries are executed, when and how often). These runtime diagnostics can be very effective in (more...)

Days -1 and 0 of UKOUG Tech 14

The UKOUG user group conference is one conference I have wanted to get to for a long time, but never managed to before. This year, with the change in job roles to being a database architect in the DBaaS team within the Enterprise Manager product management group, I finally got the go ahead to submit some papers. I was notified some time back that one of them had been accepted (Snap Clone) and one shortlisted (more...)

The User Group Tour

Those of you that have been around Oracle for some time may already be aware of the various OTN tours. These tours bring well known speakers to some of the smaller (relatively speaking) regions that often don’t get to see some of the big name speakers, simply because of audience size. Over the past couple of years, I’ve been involved in the OTN APAC tour, and recently returned from the New Zealand leg of the (more...)

Retrieving Bind Values from SQL Monitor in EM12c Release 4

I know others may want to know how to do this and I had challenges until Gagan Chawla, a teammate from Oracle, was kind enough to point out how to still get to this hidden, little gold nugget, so I’m posting it here for others!

Up till database plug-in 12.1.0.5, while in SQL Monitor SQL ID details page, you could click on a button called View Report and quickly view a (more...)

Evènement : Atelier Enterprise Manager 12c / DBaaS


Rejoignez-nous le 2 ou 3 Décembre 2014 pour expérimenter pendant une journée les aspects liés à la planification, le déploiement, le suivi et la gestion d’une solution de Cloud Privé d’Entreprise.
Pendant cette journée, vous aurez l’occasion de découvrir les points suivants :
  • Considération architecturale et concepts d’une solution de cloud privé
  • Consolidation base de données & Planification des ressources
  • Approche Base de données en mode service
    (Database as a service)
  • Clone de bases de données
  • (more...)

Complément : Webséminaire DBaaS


Removing Redundant Startup/Restart for the OMS Service in Windows

I’ve been told many times that the OMS for EM12c can take quite some time to start on Windows.  Some told me it took anywhere from three to up to fifteen minutes and wanted to know why.  I’ve done some research on the challenge and it is a complex one.

Let’s start this post by stating that even though I’m focusing on the OMS service that is part of the Windows installation of EM12c from (more...)

Will the REAL Snap Clone functionality please stand up?

Every so often our competitors like to spread false information about our solutions so as to gain unfair advantage. I wanted to address this for the Enterprise Manager Snap Clone functionality, so this blog post describes the Snap Clone solution as it currently stands (November 2014).

Let’s start by introducing Snap Clone functionality. I blogged on that a few months back, but a few months can be an eternity in software development terms, so here’s (more...)

EM12c, Rel. 4, OMS and OMR Health, Part II

There are a large number of “moving parts” when performance tuning or trouble shooting an Enterprise Manager environment.  The new EM performance features, (available in release 12.1.0.4) are there to assist you in understanding the source of the issue and can really make the difference for those that are unfamiliar with the challenges of Weblogic, java, network or other complexities that make up EM12c and aren’t commonly thought of as part (more...)

Oracle Enterprise Manager 12c Command Line Interface is Available!

The new Oracle Enterprise Manager 12c Command Line Interface book is available via a number of locations, including Amazon and directly from Apress.  If you are an EM12c fanatic or just learning and want to learn more, consider the new book that will show you why the command line returns the DBA to the golden age, empowering Enterprise Manager to script and enable tasks at a global level!

9781484202395HiRes



Tags:  

Del.icio.us
Facebook
TweetThis
(more...)

Annonce : Web Séminaire DBaaS


Accélérer considérablement vos délais de mise à disposition des services DB avec une infrastructure de Cloud Privé pour vos bases de données
(Database as a service).

Mardi 18 novembre 2014 ; de 11h à 12h

Les solutions Oracle (more...)

Setting Up Chargeback in EM 12.1.0.4

Some time back, I posted a blog entry about Metering and Chargeback in Enterprise Manager, where I covered the basic capabilities of the Chargeback Application. It’s taken me some time to get back to the promised followup blog post on setting up Chargeback, what with Oracle Open World getting in the way of things, but that’s what I’m finally doing now.

Chargeback can be setup in EM12c by any user with the EM_CBA_ADMIN role, or (more...)

Complément : Chargeback

A lire, l'article de Cap Gemini sur Enterprise Manager 12c, le Metering et le Chargeback :
http://www.capgemini.com/blog/capgemini-oracle-blog/2014/09/oracle-cloud-billing-with-metering-and-chargeback

OOW14 Session: SQL Tuning Without Trying

Many thanks to all those who attended my session "SQL Tuning without Trying" at Oracle Open World 2014 #oow14. I hope you found the session useful.

If you want to download the slide deck, here it is. As always, I would really, really like to hear from you.

Découverte : Workshop Enterprise Manager

Oracle France propose début octobre un workshop permettant de découvrir; à travers 6 ateliers de manipulation,  la solution Oracle Enterprise Manager 12c Cloud Control.

Annonce : MySQL & Enterprise Manager

Oracle a annoncé l'extension des capacités d'Oracle Enterprise Manager à superviser des bases de données MySQL.

Plus d'informations :

Private Cloud and Lifecycle Management with EM12c at OOW14

Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year! :)

To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If (more...)