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

Tuesday Feb 14, 2012

Oracle VP, Leng Tan, talks about Oracle Database Management using Oracle Enterprise Manager 12c

Listen in as Oracle Vice President, Leng Tan, talks about the new Oracle Database Management capabilities in Oracle Enterprise Manager 12c.

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

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

[Read More]

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:

Monday Jan 30, 2012

Questions and Answers from the Oracle Enterprise Management Online Forum Keynote: Gain Total Cloud Control

The recording of Oracle Enterprise Management Online Forum: Gain Total Control of Enterprise Clouds on January 25th is now available to view on demand. This half day, online event provided a unique opportunity to see, in one place, the full management capabilities of Oracle Enterprise Manager 12c and to learn about the new cloud management functionality . To view the recordings from the Enterprise Management Forum and download the presentations, please click at the link provided below :

Oracle Enterprise Management Online Forum - On Demand

Many of the Online Forum attendees found the live Q&A extremely valuable during the sessions and requested to share the archive of the Q&A.  We will be sharing the Q&A from the Oracle Enterprise Management Forum in a series of blogs during next few weeks. In this blog we will include the live Q&A archive for the keynote "Gain Total Cloud Control"  at the Oracle Enterprise Management Online Forum .

For more information, please go to Oracle Enterprise Manager  web page or  follow us at : 

Twitter | Facebook | YouTube | Linkedin | Newsletter

[Read More]

Tuesday Jan 10, 2012

Oracle Enterprise Manager Ops Center plug-in for Enterprise Manager Cloud Control 12c is now available

Systems monitoring plug-in to connect Oracle Enterprise Manager Cloud Control 12c Release 1 (12.1.0.1.0) and Oracle Enterprise Manager Ops Center 11g Release 1, Update 3 (11.1.3.0.0) is now available in Oracle Enterprise Manager Cloud Control 12c self update software catalog (see screenshot below).


This Oracle Enterprise Manager Ops Center 11g plug-in for Enterprise Manager Cloud Control 12c increases the efficiency of datacenter operations by sharing event and target attribute information between the business service owners and the infrastructure operations staff.  This enables business service owners to be fully aware of hardware, virtualization, and operating system event information while troubleshooting application issues.  They can see hardware component level details from the user interface they are comfortable working from within EM Cloud Control 12c. 

At the same time, the operations staff can see which Oracle applications are running on which infrastructure asset within Ops Center before taking maintenance actions and disrupting business.  

More information on this plug-in can be found in the following user guide:

The Oracle Enterprise Manager Ops Center 11g plug-in for Enterprise Manager Grid Control 10g and 11g is located within the Ops Center 11g product media.  No additional download is required.  More information can be found in the following user guide:

For more information, please go to Oracle Enterprise Manager  web page or  follow us at : 

Twitter | Facebook | YouTube | Linkedin | Newsletter

Tuesday Oct 25, 2011

Cloud, cloud everywhere and not a drop to drink - new whitepaper talks about the challenges and Oracle's solution

Everyone is now talking about cloud and most of the IT vendor has latched on to the Cloud promise. Traditional systems management vendors are no exceptions. However, in most cases, Cloud is treated as a technology fashion, the newest buzzword in the ever changing landscape of enterprise technology.

This whitepaper delves into what really makes an enterprise Cloud. It covers the complete cloud life cycle and how Oracle Enterprise Manager 12c offers a complete, integrated and business-driven cloud management .

For more information, please go to Oracle Enterprise Manager  web page or  follow us at : 

Twitter   Facebook YouTube Linkedin

Tuesday Oct 18, 2011

IDC Report : Oracle Enterprise Manager 12c Embraces the Cloud with Integrated Lifecycle Management

Oracle Enterprise Manager 12c  was announced earlier this month at Oracle Open World . Oracle Enterprise Manager 12c is the only complete cloud management solution for enterprise cloud that is built and engineered to help you reduce IT complexity and improve agility. 

IDC analysts Mary Turner and Tim Grieser covered the launch event and various Oracle Enterprise Manager sessions and demos at the Oracle Open World 2011 event. They published their observation in their Research Report : Oracle Enterprise Manager 12c Embraces the Cloud with Integrated Lifecycle Management 

In this research report, Mary and Tim said, "Oracle is to be given kudos for raising the bar and actively including mission critical database, middleware and application self service provisioning and dynamic scaling in the corporate cloud management discussion. Oracle is also to be commended for developing a comprehensive cloud lifecycle approach and for being remarkably clear on the steps needed to plan, implement, operate and manage clouds to derive business value from increasingly complex application deployments."

Oracle Enterprise Manager 12c brings together three essential capabilities to help enterprises gain Total Cloud Control:

  • Complete cloud life cycle management - New capabilities such as cloud setup and configuration, policy-driven resource management, self-service access, metering and chargeback.
  • Integrated cloud stack management - Includes the entire Oracle stack ranging from Oracle Fusion Applications, Oracle Fusion Middleware, Oracle Database and Hardware—as well as key non-Oracle technologies.
  • Business-driven application management - Enables application performance to be optimized based on the real-time experience of end-users.

 For more information, please go to Oracle Enterprise Manager  web page or  follow us at : 

Twitter   Facebook YouTube Linkedin


Monday Sep 19, 2011

Oracle president Mark Hurd and VP Sushil Kumar talk about Oracle's Cloud strategy

Mark Hurd, President, Oracle and Sushil Kumar, VP, Product strategy and Business Development, Oracle talk about Oracle's cloud strategy.

Join Oracle Senior Vice President Richard Sarwal for a special event (general session #13782) and post-event celebration for Oracle Enterprise Manager at Oracle Open World . You’ll be among the first to see Oracle’s complete cloud management solution in action. Arrive early for a chance to receive a complimentary pass to a reception that follows the event where you will enjoy food, drinks, and demos of the new product.

There will be many other sessions, demos and hands-on labs related to Oracle Enterprise Manager.  Hope to see you at Oracle Open World 2011.

Wednesday Aug 17, 2011

Overview demo of Oracle's Database Management Solutions. Find, Diagnose and Resolve your toughest database problems.

Oracle Enterprise Manager Database Management Packs provide industry-leading support for Oracle Database through its unique database management automation. In this demonstration you will see how customers can find, diagnose and resolve their toughest database problems.

For more information, please go to Oracle Enterprise manager for Database web page.


Wednesday Aug 03, 2011

Oracle customer talks about minimizing IT downtime - How expensive is IT downtime for you ?

We recently talked with a few of Oracle customers about their challenges in managing their IT applications & infrastructure and how moving to a private cloud infrastructure may address some of those challenges.We will be sharing some of those videos during next few weeks and encourage you to share your thoughts, feedback, application or infrastructure management challenges etc. by leaving comments to these blog entries with videos. 


How expensive is IT downtime for you ?

Thursday Jul 28, 2011

WEBCAST: Get Proactive with DBA Task Automation

Tuesday, August 16, 2011
10:00 a.m. PST / 1:00 p.m. EST
Register Now!

 

Today DBAs are being pressured to deliver database services faster and at lower operational costs, with many turning to the next-generation of database management tools and techniques to help them meet these demands head-on.

Join us for an interactive Webcast with Oracle experts who will share best practices for dealing with these database management challenges—plus tips for getting the work done quickly and efficiently. You'll learn how to:

  • Automate many routine manual DBA tasks
  • Get better performance and service quality with proactive database management
  • Overcome the explosive surge in database growth

Register now to attend this event. Attendees will receive a complimentary copy of the 2011 IOUG survey on database manageability, Managing the Rapid Rise in Database Growth.

 

About

Latest information on Oracle Enterprise Manager and Oracle Management Cloud.

Related Blogs




Search

Archives
« July 2016
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today