Tuesday Jan 15, 2013

Answers to Your Common Database Performance Questions

An Interview with Oracle Database Manageability Expert, Deba Chatterjee

Throughout the year we hear from lots of customers and get many questions about managing Oracle Database. In this blog, I thought I would try and provide some answers to common diagnostics and tuning questions with the help of our product manager and residence expert for Oracle Database Manageability, Deba Chatterjee. Deba has a wealth of database performance tuning experience both inside and outside of Oracle managing large data warehouses. Deba is responsible for Oracle Diagnostics Pack for Database and Oracle Tuning Pack for Database. I recently sat down with Deba and had a chat about database manageability.

Scott McNeil: Deba, we get many people asking questions about database performance—many still don't know about all the deep diagnostics capabilities Oracle Enterprise Manager 12c has to offer for Oracle Database. Capabilities such as; Compare Period ADDM, Real-Time ADDM, Active Session History (ASH) Analytics Real-Time SQL Monitoring, using Metric Extensions, and SQL Tuning Advisor—how do customers get all these capabilities for their database?

Deba Chatterjee: We recently ran a webcast: Maximize Oracle Database Performance with Oracle Enterprise Manager 12c: Top 10 Tips and Tricks that explains how many of these features work. I highly recommend people watch the webcast to get a better understanding of the capabilities you mentioned. But the short answer is: for Compare Period ADDM, Real-Time ADDM, Metric Extensions you need to license Oracle Enterprise Manager 12c Diagnostics Pack for Database. For Real-Time SQL Monitoring, SQL Tuning Advisor, you will need the Oracle Tuning Pack for Database.

Scott McNeil: Another question customers repeatedly ask is around Cloud Control and Database Control. Deba, can you explain the difference between Oracle Enterprise Manager Cloud Control 12c (formerly Grid Control) and Database Control.

Deba Chatterjee: Although they belong to the same family of products there is a fundamental difference between the two. Database Control can be used to manage only a single database with which it has been configured, while Oracle Enterprise Manager Cloud Control 12c allows you to manage all your databases under the same centralized management console. Plus Cloud Control lets you manage not only all your databases but your entire application and technology stack too, whether it's in a private cloud or in a traditional environment.

How do you modify the Metric Value History retention in Enterprise Manager? For example; Enterprise Manager only shows the last 7 days, how do you display longer than 7 days?

Deba Chatterjee: There are various retention times based on the type of metric data:

  • Raw metric data: default retention time is 7 days
  • Hourly aggregated metric data: default retention is 31 days
  • Daily aggregated metric data: default retention is 12 months

Refer to the documentation here, if you want to change the default retention time.

For Compare Period ADDM, how do you relate that in the context of system load?

Deba Chatterjee: In the resource usage tab, you can check the system CPU, Memory, I/O and interconnect (for RAC databases) utilizations across the 2 comparison periods in the same database.

Does Compare Period ADDM take into account the average read and average write in order to identify why the variance is happening in performance?

Deba Chatterjee: Compare Period ADDM uses database time to compare the performance across two periods. It does not compare based on average read or write times.

Does Enterprise Manager have the ability to create customized performance graphs? For example; can you create a graph for CPU usage in the last 24 hours on a given Host?

Deba Chatterjee: This is possible through the information publisher or BI publisher reports. As for the CPU usage, the chart is available out-of-the box in the target page for hosts.

How do you connect to the database itself when it’s hung and won't allow any extra connections? Do you use command line? Can you use ADDM even though the database is hung?

Deba Chatterjee: When the database is hung, you can connect to it using the diagnostic connection mode in Real-Time ADDM. The agent that is used to monitor the database makes the connection. No, command line is used. You have to use Real-Time ADDM for the connection.

Is Oracle Enterprise Manager 12c compatible with older versions of the database?

Deba Chatterjee: You can use Oracle Enterprise Manager 12c to monitor Oracle Database versions: 9.2.0.8, 10.1.0.5, 10.2.0.4, 10.2.0.5, 11.1.0.7, 11.2.0.1, 11.2.0.2, and 11.2.0.3.

Is SQL Performance Analyzer part of Oracle Database 11g or do you need to use Oracle Enterprise Manager 12c?

Deba Chatterjee: SQL Performance Analyzer is built into the database and provides command line APIs. However, Oracle Enterprise Manager 12c provides the complete orchestration needed to capture the SQL tuning set, run the performance trials, and then to create a performance comparison report.

How do you enable Enterprise Manager to monitor and send alerts to the DBAs for a "Runaway Query?”

Deba Chatterjee: You can use EM to monitor runaway queries and send alerts using Metric Extensions which rely on the data captured in SQL Monitoring. The method was explained in this webcast presentation.

How do you create a report for all the SQL running in an instance during a 30 minute timeframe? Can you export this to a spreadsheet?

Deba Chatterjee: ASH stores sampled (1 seconds in memory or 10 seconds on-disk) SQL. However ASH is meant to capture the high load SQL statements so it won’t have all SQL statements.

Do you recommend enabling automatic gathering of SQL baselines as a preventative measure of SQL regression?

Deba Chatterjee: No. This would be overkill. Identify the queries that frequently change plans and then create SQL plan baselines.

If a server has multiple database instances, what is the best way to effectively do resource allocation?

Deba Chatterjee: There is no silver bullet. Carefully study your database load and decide on use of services, instance caging and resource managers to manage load on servers.

When using SQL Performance Analyzer, do you create the baseline first before the code change is deployed or at peak DB time?

Deba Chatterjee: These are two different problems. While testing for Code change, the baseline should be created before the code is deployed. While testing for an upgrade scenario the baseline needs to be created at a peak DB time.

Is there a metric to monitor ASM disk group utilization at the cluster level?

Deba Chatterjee: Yes. ASM Disk Group Usage metric is what you can use. (See image below)

Can Oracle Enterprise Manager’s alerts be configured to monitor elements in the audit trail such as table creation or table drop?

Deba Chatterjee: Yes, these type of alerts can be configured using Metric Extensions.

LEARN MORE:

Have a database manageability question? Ask us on Twitter or Facebook.


Stay Connected:

Twitter |
Facebook | YouTube | Linkedin | Newsletter

Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Tuesday Oct 09, 2012

Private Cloud: Putting some method behind the madness

Finally, I decided to join the blogging community. And what could be a better time to start than the week after OpenWorld 2012. 50K+ attendees, demonstrations, speaker sessions and a whole lot of buzz on Oracle Cloud..It was raining clouds in this year's Openworld. I am not here to write about Oracle's cloud strategy in general, but on Enterprise Manager's cloud management capabilities. This year's Openworld was the first after we announced the 12c Cloud Control and we were happy to share the stage with quite a few early adopters. Stay tuned for videos from our customers and partners, I will post them as they get published.

I met a number of platform administrators in Oracle-DBAs, Middleware Admins, SOA Admins...The cloud has affected them all, at least to the point where it beckoned more than just curiosity..Most IT infrastructure are already heavily virtualized (on VMWare and on others including Oracle VM), and some would claim they are already on “cloud” (at least their Sysadmins told them so). But none of them were confident of the benefits because their pain points continued to grow.. Isn't cloud supposed to ease those? Instead, they were chasing hundreds of databases running on hundreds of VMs, often with as much certainty propounded by Heisenberg. What happened to the age-old IT discipline around administration, compliance, configuration management?

VMs are great for what they are. I personally think they have opened the doors to new approaches in which an application stack gets provisioned and updated. In fact, Enterprise Manager 12c is possibly the only tool out there that can provision full-fledged application as VM Assemblies. In this year's Openworld, customers talked on how they provisioned RAC and Siebel assemblies, which as the techies out there know, are not trivial (hearing provisioning time for Siebel down from weeks to hours was gratifying indeed). However, I do have an issue with a "one-size fits all" approach to cloud. In a week's span, I met several personas:

  • Project owners requiring an EC2 like VM instance for their projects

  • Admins needing the same for Sparc-Solaris.

  • DBAs requiring dedicated databases for new projects

  • APEX Developers needing just a ready-to-consume schema as a service

  • Java Developers looking for a runtime platform

  • QA engineers needing a fast clone of their production environment

If you drill down further, you will end up peeling more layers of the details. For example, the requirements for Load testing and Functional testing are very different. For Load testing the test environment should ideally be the same as the production. You shouldn't run production on Exadata and load test on a VM; they will just not be good representations of one another. For Functional testing it does not possibly matter.

DBAs seem to be at the worst affected of the lot. It seems they have been asked to choose between agile provisioning and  faster runtime performance. And in some cases, it is really a Hobson's choice, because their infrastructure provider made no distinction between the OLTP application and the Virtual desktop! Sad indeed.

When one looks at the portfolio of services that we already offer (vanilla IaaS, VM Assembly based PaaS, DBaaS) or have announced (Java PaaS, Instant Cloning, Schema-aaS), one can possibly think that we are trying to be the "renaissance man" ! Well I would have possibly digested that had it not been for the various personas that I described above.

Getting the use cases right is very important for an application such as cloud management. We iterate and iterate over these over and over again and re-validate them in CABs (Customer Advisory Boards). We consider over the major aspects of tenancy: service placement, resource isolation (can a tenant execute an expensive SQL and run away with all the resources), quota and security. We, in Engineering, keep reminding ourselves that we are dealing with enterprise clouds. We owe it to our customer base !

In the coming posts, I will drill down more into each of the services. In the meanwhile, here are some collateral and  demos for starters with EM 12c.

http://www.oracle.com/technetwork/oem/cloud-mgmt/index.html

Sudip Datta

The views expressed here are my own and do not necessarily reflect the views of Oracle.

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

Thursday Jul 19, 2012

Oracle Enterprise Manager 12c July Newsletter is Out!

Each month the Enterprise Manager team puts together a full line-up of great articles, content and technical product information around a particular theme. This month is no different. In July, we’re focusing on lifecycle management and all the things you need to know about this important topic. Read the July newsletter to get the latest articles and content on lifecycle management. Read it now!

The July edition covers:
• Achieving Extreme Performance Across Oracle Exadata's Lifecycle

• Top 5 Database Compliance Risks—and How to Avoid Them
• Know the Best Tools to Provision and Patch Oracle Database 11g
• and much more...

So stay tuned as we bring you more feature articles, and more webcasts throughout the month.

Enjoy!

Subscribe here to receive the Oracle Enterprise Manager 12c Newsletter.


Stay Connected:

Twitter |
Facebook | You Tube | Linkedin | Newsletter

 

Monday May 21, 2012

Benefits of using Ops Center to deploy and manage Solaris 11

One of the more significant new features in Oracle Enterprise Manager Ops Center 12c is the ability to install Ops Center on Oracle Solaris 11, and to deploy and manage systems running Solaris 11.  The Solaris 11 capabilities are in addition to the analogous features for Solaris 10 and Linux, which can all be handled from the same Ops Center infrastructure.

When the Ops Center Enterprise Controller (EC) is installed on a system running Solaris 11, the EC can create a Solaris 11 Software Update Library containing Oracle Solaris Image Packaging System (IPS) content that is synchronized with the main Oracle repository at pkg.oracle.com. The Ops Center managed Solaris 11 repository becomes the package (pkg) publisher for downstream Solaris 11 deployments and updates on all Solaris 11 systems being managed by Ops Center.

Ops Center provides the ability to define Solaris 11 OS and Software Profiles comprised of Oracle Solaris 11 packages, user-supplied custom packages, scripts, and other files.  Such Software Profiles profiles can then be used to install and update software on systems already running Solaris 11 in a structured and consistent way.  Ops Center not only caches the main Oracle Solaris IPS repository, but more importantly it gives admins the ability to define their own preferred collection of packages so that systems can easily be kept in sync with each other, running a well-defined, life-cycle-managed Standard Operating Environment (SOE), instead of just whatever the latest content is at pkg.oracle.com.

Ops Center 12c also adds Solaris 11 features for bare-metal OS Provisioning, based on the Solaris 11 Auto Install (AI) facility.  Ops Center configures the Solaris 11 AI in a way that shields admins from needing to write custom AI manifests or custom "first boot" packages.  Solaris 11 deployments using Ops Center follow similar profile-based patterns as for Solaris 10 or Linux, all of which can all be deployed from the same Ops Center infrastructure running on Solaris 11.  The gory details of all these different times of bare-metal OS Provisioning are handled automatically for the user so that he or she does not need to put time and resources into manually creating and maintaining infrastructure for deploying different OS's natively -- Solaris 11 with AI, Solaris 10 JumpStart with JET, or Linux with Kickstart or AutoYast.  All of those OS's are handled by Ops Center under the covers, based on whatever network boot capability the OS requires (PXE/DHCP, WANBOOT, or AI), and all from the same Ops Center infrastructure running on Solaris 11.

Specific to Solaris 11 OS Provisioning (via AI), Ops Center provides its own "first-boot" package+scripts to customize the Solaris 11 deployment, and in particular this approach automatically installs the Ops Center agent.  With the Ops Center Agent in place right from the start, it is easy to handle post-install steps using the Ops Center features for handling Solaris 11 OS and Software Profiles containing additional packages, scripts, and content from the Solaris 11 Software Library, described above.

Tying bare-metal Solaris 11 deployment and post-install customization together is a key way that Ops Center simplifies the overall life-cycle management for Solaris 11 (in addition to Solaris 10 and Linux).   For example, a top-level plan based on "Configure and Install Logical Domains" can create numerous Logical Domains into an Oracle VM Server for SPARC "Server Pool" and provision Solaris 11 into each LDom Guest based on a powerful multi-step "Install Server" plan.  Such a plan can cover the end-to-end steps for installing and updating the OS, running scripts and adjusting monitoring parameters, etc.

Here is an example of the kinds of activities that can be performed in conjunction an OS Deployment, or separately, depending on the need:

Oracle Enterprise Manager Ops Center 12c Deployment Plan

NOTE: In the above example, the last step "Create Guests" can be used to create one or more Solaris Containers within the LDom Guest, rounding out the end-to-end deployment all the way from LDom Guest to Solaris 11 Global Zone to multiple Solaris Containers, if so desired.

One of the nicest aspect of deploying and managing Solaris 11 using Ops Center Plans and Profiles is that the same content can be applied as updates to existing Solaris 11 systems, aligned to the same content as chained off a bare-metal OS Provisioning.  It is up to the user which steps they want to include in a deployment plan -- whether they are updating Software Profiles on systems deployed 6 months ago to match the latest standard, or they are deploying new systems based on that same standard, Ops Center provides the means to insure that the outcome is consistent.

Here is an example of the kinds of activities that can be performed on an existing Solaris 11 OS -- either ad hoc, or immediately after a Solaris 11 OS Provisioning step, so that whether the life-cycle started with a new system, or the intent is to update a system deployed six months ago, the outcome can be the same:

S11 Update Multi-Step Plan

In short, Ops Center running on Solaris 11 can manage Solaris 10 and Linux systems, all from a common infrastructure, and all based on a simplified, consistent, profile- and plan-based way to do the OS and Software deployments and updates.  The net effect is an easy to use way to managing the life-cycle of heterogeneous systems, in a very consistent way through automation and re-use.

Please let us know what you think?  Until next time...
\Leon
--

Leon Shaner | Senior IT/Product Architect
Systems Management | Ops Center Engineering @ Oracle

The views expressed on this [blog; Web site] are my own and do not necessarily reflect the views of Oracle.



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

Twitter | Facebook | YouTube | Linkedin | Newsletter

Monday Apr 09, 2012

New Database assemblies are available now to simplify cloud deployment via Oracle Enterprise Manager 12c Self-Update

Deploying application in the cloud is a huge challenge.  Typically customers either deploy various components of the application individually and then manually wire them together.  Some vendors even allow you to deploy a bunch of VMs together but you still have the hard and painful job of connecting the dots. The problem gets even worse if you start to think other deployment constraints – such as which components should be co-located and which not, what should be the network topology of the application (i.e. database and middleware should be in different network segments), which components can scale out and if so how should the scale out happen.

Oracle Virtual Assembly Builder (OVAB) and Oracle Enterprise Manager 12c address this challenge. Using OVAB, application developers and architects  can model the application topology graphically, define all dependencies and deployment constraints, and package the entire application in form of what we call an application assembly. These assembly can then be uploaded to the centralized software library in Enterprise Manager for self-service deployments.


At the launch of Oracle Enterprise Manager 12c last year, we talked about Oracle's plan to offer assemblies for all our products which will allow you to deploy any of our products – including packaged applications – by click of a button. Enterprise Manager has a live link back to Oracle which will notify you of the availability of new assemblies and download them if you are interested.


Last week, we made new Database assemblies available via Oracle Enterprise Manager 12c Self-Update. The release of assemblies will help customers deploy the cloud solution more easily on Oracle VM platform. Customers can create a zone of Oracle VM 3.x servers and deploy these assemblies from the Enterprise Manager 12c Self-Service interface. Following screenshot shows how they look like in the self-update interface of the Oracle Enterprise Manager 12c.

Stay connected with  Oracle Enterprise Manager   :

Twitter | Facebook | YouTube | Linkedin | Newsletter

Thursday Apr 05, 2012

Oracle Enterprise Manager Ops Center 12c is now available for download at Oracle technology Network

Oracle Enterprise Manager Ops Center 12c is available now for download at Oracle Technology Network (OTN ) .

Oracle Logo Enterprise Manager Ops Center Documentation

Oracle Enterprise Manager Ops Center web page at Oracle Technology Network

Join Oracle Launch Webcast : Total Cloud Control for Systems on April 12th at 9 AM PST to learn more about  Oracle Enterprise Manager Ops Center 12c from Oracle Senior Vice President John Fowler, Oracle Vice President of Systems Management Steve Wilson and a panel of Oracle executive.



Stay connected with  Oracle Enterprise Manager   : 

Twitter | Facebook | YouTube | Linkedin | Newsletter



Wednesday Apr 04, 2012

Oracle Launches Enterprise Manager Ops Center 12c at OpenWorld Japan

Oracle Senior Vice President John Fowler and Oracle Vice President of Systems Management Steve Wilson unveiled Oracle Enterprise Manager Ops Center 12c at Oracle OpenWorld, Tokyo Japan on April 4th morning. 

Oracle Enterprise Manager combines management of servers, operating systems, virtualization solution for x86 and SPRC servers, firmware, storage, and network fabrics with Oracle Enterprise Manager Ops Center. Available at no additional cost as part of the Ops Center Anywhere Program, Oracle Enterprise Manager Ops Center 12c allows enterprises to accelerate mission-critical cloud deployment, unleash the power of Solaris 11 — the first cloud OS, and simplify Oracle engineered systems management.

Here are some of the resources for you to learn more about the new Oracle Enterprise Manager Ops Center 12c : 

Press Release : Introducing Oracle Enterprise Manager Ops Center 12c

White paper: Oracle Enterprise Manager Ops Center 12c - Making Infrastructure-as-a-Service in the Enterprise a Reality

Oracle Enterprise Manager Ops Center web page at Oracle Technology Network

Join Oracle Launch Webcast : Total Cloud Control for Systems on April 12th at 9 AM PST to learn more about  Oracle Enterprise Manager Ops Center 12c from Oracle Senior Vice President John Fowler, Oracle Vice President of Systems Management Steve Wilson and a panel of Oracle executive.



Stay connected with  Oracle Enterprise Manager   : 

Twitter | Facebook | YouTube | Linkedin | Newsletter


Thursday Mar 08, 2012

Looking for an executive overview of Oracle Enterprise Manager 12c ?

IT professionals are excited by the technical advantages of cloud computing, and Line of Business managers look to the cloud as a driver of business growth, efficiency, and productivity. By transforming IT into a business-centric provider of services that users can access from anywhere, Oracle Enterprise Manager 12c helps you build a more agile, efficient, and  innovative enterprise.

You can get an executive overview of the Oracle Enterprise Manager 12c in this recently published executive brief


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

Twitter | Facebook | YouTube | Linkedin | Newsletter

Thursday Mar 01, 2012

Sushil Kumar, VP,Product Strategy and Business development,Oracle shares highlights of new Oracle Enterprise Manager 12c update

Yesterday ( Feb. 29, 2012), Oracle announced the Oracle Enterprise Manager 12c Bundle patch 1 and 12.1.0.2 Plug-in updates. The new "Bundle Patch" contains numerous bug fixes, performance improvements and new features to improve Oracle Enterprise Manager Cloud Control 12c customer experience . 

Sushil Kumar, VP, Product Strategy and Business development, Oracle Enterprise Manager, shared the highlights of the new "Bundle Patch" with me earlier today. In this blog, I captured my discussion with Sushil.

The new “Bundle Patch” is a pretty significant update to Oracle Enterprise Manager 12c bits released at Oracle Open World in October, 2012. It contains over 3000 bug fixes and includes some brand new functionality such as Weblogic and Fusion Apps Patching, Exadata out of place patching, etc. We recommend customers, who are considering to go live with EM 12c in production in the next few months, to pick up this mandatory update. 


Even though we are calling this update a "Bundle Patch", an updated Enterprise Manager Base Platform Full Installer is made available for download on Oracle Technology Network (OTN).  Any customer who downloads the 12c bit as of February 29, 2012, will automatically get these updates as a part of the base install. In another words, if you download the EM 12c product by clicking on “for Linux x86 (64 bit) (With Bundle Patch)” link from the OTN Download center (see the screen shot below) and do a fresh install, you will have all the updates required and no additional patches need to be applied to get these updates. 


The revised installation media is only available for Linux right now. The updated installer will be released on other operating systems in the coming weeks/months.

If you have not already discovered a large number of targets, defined admin groups and monitoring templates or defined compliance policies and rules, etc. with previously released Oracle Enterprise Manager 12c bit, then a fresh install with the updated installer is the way to go. The option of “patching” a site running on previously released EM bits exists , but, it may be worth the pain only if you have already put in a lot of time and effort setting up your EM 12c environment based on the previously released bits.

We are working closely with the early adopter customers of Oracle Enterprise Manager 12c to make sure that they can update in a smoothest possible manner. If you were not part of the EM 12c early adopter program, please work with your Oracle support .


The other exciting announcement with the release of EM 12c iPhone app that Scott blogged about yesterday. This is in response to the strong customer demand to make EM accessible from mobile devices. The new app primarily exposes the incident management functionality but we will add more features to it moving forward.


Finally, we want to highlight that the only supported version of Oracle BI Publisher with EM 12c is 11.1.1.5 and it is linked from the EM 12c download page.  Please do not use the latest version 11.1.1.6 of BI publisher with EM 12c since that may render your environment unusable. We do have plans to support 11.1.1.6 in the near future, but, as of now, please download the BI publisher version that is linked off the EM 12c download page on OTN.

Please share your feedback by providing your comments on this blog, using #em12c tag on twitter and other social media channel following the links below.


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

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...

Enjoy!

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

About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
3
5
6
7
9
10
11
12
13
14
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today