Wednesday Feb 29, 2012

Manage Oracle on the Go! Get the New Oracle Enterprise Manager 12c Mobile App for iPhone

Oracle Enterprise Manager Cloud Control 12c Mobile App for incident management with service request integration is now available for the Apple iPhone. With this release Oracle now offers the ability to track, monitor, and manage incidents directly from your smart phone. IT managers and administrators using Oracle Enterprise Manager 12c can view incident and problem details directly in the app, as well as acknowledge, assign, prioritize, escalate and annotate incidents. The app provides seamless connectivity to My Oracle Support allowing users to drill-down into any service request associated with a problem. In addition, the flexible setup screen enables users to connect to multiple Oracle Enterprise Manager 12c environments from within a single pane.

Manage incidents directly from your iPhone
View and track system issues
Provide quick status updates

Download the Oracle Enterprise Manager Cloud Control 12c Mobile app

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Feb 28, 2012

Cerner Delivers Proactive Database-as-a-Service

Watch and learn how Cerner, one of the leading healthcare technology solution providers, efficiently manages hundreds of databases for its clients using Oracle Enterprise Manager and Database-as-a-Service.

More information
To learn more about Oracle Enterprise Manager 12c Database Management solution, please visit:

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Monday Feb 27, 2012

Why Database as a Service: Think Scalability and Agility

For those interested in delivering Database as a Service (DBaaS) for your IT, or just looking for more insight into this powerful capability—check out the latest Oracle Enterprise 12c InDepth Newsletter. This edition features a great article on why you should consider DBaaS in your IT strategy. Here's a hint, think scalability and agility!

Subscribe here to get the latest issue delivered to your mailbox.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Thursday Feb 23, 2012

Q&A: Leng Tan, VP of Development, Discusses the New Oracle Database Lifecycle Management Solution

In this month's Oracle Enterprise Manager 12c InDepth Newsletter, Leng Tan, VP of Development for Database Manageability, discusses some of the issues facing IT today. In the interview, Leng talks about the ways administrators can address and overcome these challenges using Oracle Enterprise Manager 12c Database Lifecycle Management solution. Be sure to read the article to learn more!

To get the latest issue of the Oracle Enterprise Manager 12c InDepth Newsletter, subscribe here.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Wednesday Feb 22, 2012

Oracle Enterprise Manager 12c Newsletter: February 2012 Edition Now Available

Get the latest issue of the Oracle Enterprise Manager 12c Indepth Newsletter. Read it Now!

The February edition covers:

  • Oracle Database Lifecycle Management
  • Enterprise Management Online Forum
  • Database as a Service
  • and much more...


Subscribe here to receive the Oracle Enterprise Manager 12cNewsletter.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

Tuesday Feb 21, 2012

Oracle Exadata Management — Diary of an Exadata DBA

I recently had the chance to sit down with Deba Chatterjee, Senior Product Manager, Database Manageability to talk about Oracle Enterprise Manager 12c and how it's making Oracle Exadata management easier for DBAs. He had a great analogy that I wanted to share. "To describe how Enterprise Manager is making Exadata management simple and less complex, is by using an approach we call, 'Exadata Aware Database Performance Analysis'. The best way to illustrate how this works, is to use real-world scenarios," Deba added. Here is one of those scenarios—an excerpt from the diary of an Exadata DBA.

November 15th, Late Evening

Database performance has suddenly dropped becoming very poor. The same reports that were running fine a couple of hours ago are now taking forever to complete. The boss just left me a message that the CRM analytics director was pretty upset and wants to know why we have a performance problem.

I checked the queries and the execution plans both look the same with lots of smart scans and cell offloading. Suddenly, the response time has gone south and I cannot figure out why?

My first step was to look at the database performance page in Oracle Enterprise Manager 12c, which now comes with built-in Oracle Exadata support. Hey, what do I have here in the I/O tab? The Exadata system health button is red, that's not good. What's happening? I clicked the button and it took me to the Exadata health triage page, this is where I can see if I have potential issues such as;

  • Load imbalance
  • ASM related problems
  • Cell software or hardware failures
  • Cell configuration issues
  • Network related failures

The red Oracle Exadata system health button indicates potential issues impacting database performance.

Next, I noticed that the network status was red, it must be a network issue, right? I quickly checked the administration screen in the Infiniband Target Home page, and saw we had a degraded port in the Port Details status section. I disabled the bad port and allowed the network traffic to automatically fail over to its peer. I'll have to look into this later, for now I just wanted to get the system up and running.

View of the degraded port in Infiniband Switch Schematic.

I quickly re-checked the Exadata system health status again, it showed all green—looks like everything was working, problem solved. I called my boss back to give him the good news that the database performance was back up. I sure am glad all these things are integrated; otherwise I would have been here all night trying to figure this out.

Oracle Database Management resources:

Stay Connected:

Twitter | Facebook | YouTube | Linkedin | Newsletter

Thursday Feb 16, 2012

Managing Oracle Database 11g—Questions and Answers from the Oracle Enterprise Management Online Forum

We received tons of questions from our recent Oracle Enterprise Manager 12c Online Forum, we wanted to continue to provide answers to the most popular ones. In this installment, we'll cover questions from the DBA and developer track.

Q. What kind of testing do you recommend for upgrading from Oracle Database 11gR1 to 11gR2?
A. Oracle Real Application Testing using Database Replay and SQL Performance Analyzer's capabilities are recommended for any Oracle Database upgrade. Check out these resources for more details: Oracle Real Application Testing datasheet and OTN for details on upgrading your database.

Q. Can I manage Oracle Exadata and traditional Oracle Databases from the same console?
A. Yes, you can manage Oracle Exadata and single instance and/or RAC databases from the same Oracle Enterprise Manager Cloud Control console, as well as WebLogic and many other targets. Check out this demo to see how.

Q. I thought Active Session History (ASH) was intended for real-time?
A. ASH can be use for both real-time and historical analysis. It is a black box that records session activities and helps to analyze across several performance dimensions. Click here to see a quick demo.

Q. What is the difference between Oracle Enterprise Manager 12c and Oracle Database Control?
A. Database Control is a subset which runs off a single database. Oracle Enterprise Manager 12c is a central repository which allows administrators to manage and monitor from a single console.

Q. How does Real-Time Automatic Database Diagnostics Monitor (ADDM) work – the database is hung right?
A. Real-Time ADDM, included in the Oracle Diagnostic Pack for Oracle Database, uses 2 different modes of connection to the database. A normal connection and a diagnostic mode that is a lock less, latch less connection which allows only few actions. Using the diagnostic mode connection Real-Time ADDM performs a hang analysis and determines any blockers in the systems. Check out this demo to see how Real-Time ADDM works.

Q. Can we achieve all the new functionality in Oracle Enterprise Manager 12c using terminal?
A. No. Features like ASH Analytics, Real-Time ADDM and Compare Period ADDM are only available using Oracle Enterprise Manager 12c's console.

Q. Is Real-Time ADDM available only in Oracle Enterprise Manager 12c?
A. Yes, Real-Time ADDM is a new feature in Oracle Enterprise Manager 12c.

Q. Can you explain the difference between Oracle Database 11g Monitor in Memory Access Mode vs. Real-Time ADDM direct access to SGA?
A. Real-Time ADDM does not use Memory attach mode. We use a proprietary connection method which connects using a lock less, latch less connection bypassing the SQL Access layer.

Q. Is there any limit on the number of days on which ASH can be used for analysis?
A. The in memory ASH data is typically available for 1 hour or till the point the memory buffer is flushed to disk. You can find out ASH retention by using: select min(sample_time), max(sample_time) from sys.WRH$_ACTIVE_SESSION_HISTORY;

From more Oracle Database Management product information check out these resources:

Stay Connected:

Twitter | Facebook | YouTube | Linkedin | Newsletter

Thursday Feb 09, 2012

NEW STUDY: Oracle Database 11g Delivers Significant Savings over Microsoft SQL Server

ORC International: Oracle Database 11g is 49% Easier to Manage and 46% Less Complex

Oracle Database 11g Release 2 continues to outperform Microsoft SQL Server 2008 Release 2 by a substantial margin, according to a new ORC International study. In the report, "Database Manageability and Productivity Cost Comparison Study Oracle Database 11g Release 2 vs. Microsoft SQL Server 2008 Release 2," Oracle once again demonstrates its leadership in overall database self-manageability with significant productivity and complexity savings.

The study found that Oracle Database 11g Release 2 took half the amount of time and effort to complete four routine database administrator (DBA) tasks compared to Microsoft. The study measured typical tasks such as initial database setup, routine daily administrative tasks, and backup and recovery, as well as performance and tuning tasks.

In one particular scenario, the study illustrated how a DBA could perform database diagnostics and tuning tasks 143 times faster using Oracle Database 11g over Microsoft SQL Server 2008. The report concluded that Oracle allowed IT organizations and DBAs to

  • Perform administrative tasks 49% faster than Microsoft SQL Server 2008
  • Save time with 46% fewer steps for the same set of standard routine functions versus Microsoft
  • Increase productivity and save businesses up to US$58,800 per year per DBA by using Oracle Database 11g over Microsoft SQL Server 2008

This report, along with similar competitive studies ORC International conducted including one against IBM DB2 9.7, reaffirms Oracle Database 11g as an industry leader with its unique self-managing automation and performance capabilities. Oracle Database 11g, along with Oracle Enterprise Manager 12c Database Management Packs, continue to help DBAs become more productive at getting their jobs done faster and with less effort.

More information
To learn more about Oracle Database 11g and Oracle Enterprise Manager 12c, please visit:

Tuesday Feb 07, 2012

Solaris and SPARC virtualization management features of Oracle Enterprise Manager Ops Center including "Live Migration"

This blog provides a short history of how Oracle technology in the Solaris and SPARC world has progressed to where we are with the SPARC-T4 Server family and Oracle VM Server for SPARC (formerly Logical Domains).  The entry continues with observations of why these technologies are relevant to business and IT stakeholders, today.  And finally, how Oracle Enterprise Manager Ops Center is piquing customer interest in moving forward with Logical Domains, followed by a short demonstration of LDom Migration in action.
[Read More]

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs


« February 2012 »