Wednesday Jan 30, 2013

Coles Deploys Oracle Exadata and Oracle Enterprise Manager 12c

Read the latest news about Coles Supermarkets, one of Australia's largest grocery chains with more than 100,000 employees and 2,000 stores country-wide. Learn how Coles completely revamped their data warehouse with Oracle Exadata and Oracle Enterprise Manager 12c . The new system improved Coles's processes and critical reporting by as much as 3 to 4x out-of-the-box with a 4 to 6x faster query performance. The result, higher quality of service for the business and for customers during peak seasonal spikes.

LEARN MORE:

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Tuesday Jan 29, 2013

WEBCAST: Protect Your Sensitive and Confidential Data Using Oracle Data Masking Solution

Thursday February 7
10:00 a.m. PST / 1:00 p.m. EST

Join us for a live and interactive webcast on how to comply with regulatory requirements and data protection policies by protecting sensitive data in non-production Oracle Databases as well as non-Oracle databases using Oracle Data Masking Pack, a part of Oracle Enterprise Manager 12c quality management and Oracle Database Security defense-in-depth solution. Topics include:

  • Automatically discovering sensitive data
  • Standard and advanced masking techniques made easy
  • Eliminate the need for a staging database using At-source masking
  • Secure your Oracle Applications (Oracle E-Business Suite, Oracle Fusion Applications) data quickly using masking templates
  • Seamless masking integration with Oracle's data subsetting solution
Register today
Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Friday Jan 25, 2013

Enterprise Manager for Big Data Appliance (BDA) Plugin - 12.1.0.1.0

Earlier this month (Jan 2013) we announced the GA of Enterprise Manager for Big Data Appliance (BDA) Plugin - 12.1.0.1.0

This is the first version of Enterprise Manager for Big Data Appliance (BDA) Plugin release. The plugin is available to EM customers on Self Update (screenshot below), and certification information for this plugin is also available to customers on MyOracleSupport certify (here).


BDA
Using the Enterprise Manager 12c Big Data Appliance Plug-in 12.1.0.1, users can:

  1. Discover the software and hardware components of a Big Data Appliance Network and add them as managed targets.
  2. Manage the hardware and software components that comprise a Big Data Appliance Network as a single target or as individual targets.
  3. Study collected metrics to analyze the performance of the network and each Big Data Appliance component.
  4. Trigger alerts based on availability and system health.
  5. Respond to warnings and incidents.

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


Thursday Jan 24, 2013

HDFC Bank Deploys Database-as-a-Service with Oracle Enterprise Manager 12c

Listen in as one of India’s largest banks discusses the benefits of using Oracle Enterprise Manager 12c to manage their database-as-a-service deployment.

Stay Connected:
Twitter |
Facebook | YouTube | Linkedin | Newsletter
Download the Oracle Enterprise Manager Cloud Control12c Mobile app

Friday Jan 18, 2013

Enterprise Manager at Collaborate13

LAST UPDATED: April 4, 2013

Enterprise Manager customers and partners will once again be widely represented at Collaborate13, the annual conference of the Independent Oracle User Group (IOUG), Oracle Applications User Group (OAUG)  and Quest International Users Group.

As reported in my blog about Enterprise Manager in the Oracle User Community, IOUG’s Enterprise Manager Special Interest Group (SIG) has grown substantially since its inception in 2012 and has a comprehensive line-up of best practices and real-world experiences from Enterprise Manager customers and partners as well as sessions featuring speakers from Oracle Development. A listing of sessions featuring Enterprise Manager exclusively or significantly is below.

Note: Use the Education Scheduler to get the abstract for the session by doing a search using the Session ID. 

MONDAY APRIL 8

ID Title Speaker & Company Time & Location

344

Performance Tuning your DB Cloud in OEM 12c Cloud Control - 360 Degrees Tariq Farooq - Brain Surface
09:45 am - 10:45 am
Mile High Ballroom 4A
951 Oracle's Cloud Computing Strategy Anand Akela - Oracle
11:00 am - 12:00 pm
Four Seasons Ballroom 1
669 ASH: Architecture and Advanced Usage - Part 1 of 2 John Beresniewicz - Oracle
11:00 am - 12:00 pm
Mile High Ballroom 3A
100240 Peoplesoft Application and System Monitoring Basics Raj Garrepally - Georgia Health Sciences University
11:00 am - 12:00 pm
Room 107
436 Cloud Computing Solutions leveraging Oracle Technology Jordan Braunstein - Visual Integrator Consulting
12:15 pm - 12:45 pm
Mile High Ballroom 4A
250 How to Become a Cloud Builder Steve Lemme - Oracle
1:15 pm - 2:15 pm
Mile High Ballroom 4A
183 EM12c- Less Known Features and Techniques Kellyn Pot'Vin - Enkitec
1:15 pm - 2:15 pm
Mile High Ballroom 4C
577 "Where did my CPU go?" -- Monitoring & Capacity Planning Adventures on a Consolidated Environment Karl Arao - Enkitec
1:15 pm - 2:15 pm
Mile High Ballroom 3A
851 Manage Large RAC Clusters Tom Reddy - Database Administraion, Inc.
1:15 pm - 2:15 pm
Mile High Ballroom 2A
319 Automating Database Security Compliance using OEM 12c Bobby Curtis - BIAS
2:30 pm - 3:30 pm
Mile High Ballroom 1D
772 Deploying a Private DB Cloud Michael Timpanaro - Oracle
2:30 pm - 3:30 pm
Mile High Ballroom 4A
255 OEM Command Line Interface Illustrated Ray Smith - PGE
3:45 pm - 4:45 pm
Mile High Ballroom 4C
11362 Off the Farm and Into the Enterprise - Oracle Enterprise Manager Floyd Teter - EiS Technologies
3:45 pm - 4:45 pm
Room 507
128 ASH: Architecture and Advanced Usage - Part 2 of 2 John Beresniewicz - Oracle
3:45 pm - 4:45 pm
Mile High Ballroom 2A
720 Listener Poisoning? Logminer fragmentation? Million Cursors opened? Manageability Headaches or Opportunities in Disguise Raghav Pujari - PSDB Solutions Inc
3:45 pm - 4:45 pm
Mile High Ballroom 2B
609 Oracle Enterprise Manager 12c in an HA configuration across Data Centers Todd Bellaver - Secure-24
5:00 pm - 6:00 pm
Mile High Ballroom 4C
Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
6:00 pm - 8:00 pm
Oracle Demogrounds




TUESDAY APRIL 9

ID Title Speaker & Company Time & Location
343 Oracle VM, OEM 12c and Cloud Computing 360 Degrees

Kai Yu - Dell

Tariq Farooq - Brain Surface

Michael Ault - Ramsan


8:00 am - 9:00 am
Mile High Ballroom 4A
814 Leveraging Enterprise Manager to uncover virtualization performance bottlenecks Bryce Kaiser - Blue Medora
8:00 am - 9:00 am
Mile High Ballroom 4E
Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
10:15 am - 3:15 pm
Oracle Demogrounds
264 Enterprise Manager 11g - Making Life Easier For You William Robbins - College of William & Mary
12:00 pm - 12:30 pm
Mile High Ballroom 2B
630 Oracle Enterprise Manager 12c: Architecture Deep-dive, Tips, Techniques Mark McGill - Oracle
2:00 pm - 3:00 pm
Mile High Ballroom 4C
563 Oracle Enterprise Manager 12c: Nerve Center of the Oracle Cloud Nara Gogineni - Oracle
2:00 pm - 3:00 pm
Mile High Ballroom 2C
544 Be a hero with your DBAs: DB Tuning for Sys Admins and IT Architects Randall Sogrillo - Oracle
2:00 pm - 3:00 pm
Mile High Ballroom 2B
237 Plan/Configure/Deploy your own Private Oracle Fusion Applications Cloud Tariq Farooq - Brain Surface
2:00 pm - 3:00 pm
Mile High Ballroom 3C
580 RAC 11gR2 performance using AWR data and OEM 12c - Lessons learned from a critical production system Tim Quinlan - Scotiabank
2:00 pm - 3:00 pm
Mile High Ballroom 4A
589 Oracle Enterprise Manager 12c: Deployment Best Practices Werner de Gruyter - Oracle
4:30 pm - 5:30 pm
Mile High Ballroom 2A
326 Configuring Oracle Enterprise Manager Cloud Control 12c for High Availability Leighton Nelson - Nelson
4:30 pm - 5:30 pm
Mile High Ballroom 4C
941 Cloud Control Recipes Mike Gangler - ITHAKA
4:30 pm - 5:30 pm
Mile High Ballroom 4A
Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
5:30 pm - 7:00 pm
Oracle Demogrounds




WEDNESDAY APRIL 10

ID Title Speaker & Company Time & Location
400 How is your network supporting your Oracle Applications and Databases and ultimately your business? John McHugh - Entuity
8:15 am - 9:15 am
Mile High Ballroom 4E
679 Exadata 101 -- What You Need to Know Rich Niemiec - ROLTA
8:15 am - 9:15 am
Mile High Ballroom 1C
800 Best Practices for implementing Oracle Database as a Service Raj Kammend - Oracle
8:15 am - 9:15 am
Mile High Ballroom 4A
815 Oracle Enterprise Manager SIG - Birds of a Feather

Twitter #em12c

TweetEvite


9:30 am - 10:30 am
Mile High Ballroom 4B & Chatroom
Kiosk #6 Enterprise Manager 12c Total Cloud Control Demo Oracle
10:30 am - 3:00 pm
Oracle Demogrounds
325 Managing Heterogeneous Virtualization Environments with EM12c Bryce Kaiser - Blue Medora
12:15 PM - 12:45 PM
Mile High Ballroom 4A

Enterprise Manager - Book Signing Adeesh Fulay - Oracle
12:15 PM - 12:45 PM
Bookstore
864 Upgrading from Oracle Enterprise Manager 10g to Cloud Control 12c with Zero Downtime Leighton Nelson - Mercy
3:00 pm - 4:00 pm
Mile High Ballroom 4C
12983 Advanced Management of Oracle E-Business Suite with Oracle Enterprise Manager Angelo Rosado - Oracle
3:00 pm - 4:00 pm
Room 601
369 Simplifying Application Deployment in Cloud using Virtual assemblies and EM 12c Kai Yu - Dell
4:15 pm - 5:15 pm
Mile High Ballroom 4B
182 Engineered Systems Curriculum: 500+ Million Records per Day Replicated to Exadata using GoldenGate Kirby McCord - US Cellular
4:15 pm - 5:15 pm
Mile High Ballroom 1C




THURSDAY APRIL 11

ID Title Speaker & Company
Time & Location
336 Near Zero Downtime Oracle RAC Migration with Oracle Automatic Storage Management and OEM 12c

Vinod Emmanuel 9:45 am - 10:45 am
Dell Mile High Ballroom 2A
837 Shed Some Light on the Bumps in the Night with Enterprise Manager 12c David Start - Johnson Controls
9:45 am - 10:45 am
Mile High Ballroom 2B

Thursday Jan 17, 2013

Enterprise Manager in the Oracle User Community

Top brass representing Oracle user groups from around the world converged at the user community’s annual Leaders’ Summit held at Oracle HQ this past week.  An increased desire to introduce or increase involvement with Enterprise Manager to the members of their respective organizations was clearly expressed to product representatives who attended, like me!

The reason?  The most active, involved and (dare I say) demanding customers participate in 450 groups representing 275,000 Oracle customers.  Adoption of Enterprise Manager 12c is accelerating and is being used to manage more and more Oracle and non-Oracle parts of their IT stack by these customers.   Members are becoming increasingly expert in deploying and using Enterprise Manager and are eager to share their experiences with their peers.  All this adds up to members wanting a focus on it so they can learn more about it, share best practices and maybe even influence product direction.  That's why the interest is there.

Want proof?  In the last year or so, two user groups now have a special interest groups (SIGs) devoted to management: IOUG and UKOUG.  Others, such as DOAG and AUSOUG, prominently feature Enterprise Manager at their respective conferences.  ODTUG, Quest and even the Georgia User Group have just begun investigating how to feature Enterprise Manager in their groups, and  no doubt there will be more.

A very noteworthy example is IOUG's Enterprise Manager SIG.  At Oracle OpenWorld SIG Sunday last October, six extremely well-attended manageability sessions under the auspices of the SIG were held.  IOUG will also be launching a bi-monthly E-news briefing and web-cast series starting in the March 2013 time-frame.  And to top it off, IOUG along with OAUG is also featuring 30-plus sessions devoted exclusively or significantly to Enterprise Manager at the upcoming Collaborate13 Conference in Denver April 7-11th.  That's unprecedented.  Check out my Enterprise Manager at Collaborate13 blog for the session listing.


Okay, now I'm going out on a limb:  the Oracle Enterprise Manager product team stands ready to help your user group establish an focus around manageability in any practical way possible.  We can provide speakers for your upcoming conferences or webcasts.  We can apply social media resources.  And we are more than happy to apply other marketing resources where they make sense.  We are very interested in supporting a management special interest group as well. 

Just contact me at joe.diemer@oracle.com.  Operators are standing by.

Stay Connected with Oracle Enterprise Manager:
Twitter |
Facebook | YouTube | Linkedin | Newsletter

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

About

Latest information and perspectives on Oracle Enterprise Manager.

Related Blogs




Search

Archives
« January 2013 »
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
16
19
20
21
22
23
26
27
28
31
  
       
Today