Who's online

There are currently 0 users and 30 guests online.

Recent comments

Oakies Blog Aggregator

Oaktable World Agenda 2015

Oaktable World 2015

Oaktable World brings together some of the Oracle performance people in the world to present and discuss their findings.

Oaktable World is open to everyone free of charge and no registration necessary !

Oaktable World is Monday and Tuesday of Oracle Open World 2015 and is located on the same block as OOW.

Oaktable World is also hosting hands on labs Tuesday 12:30-4:30. The labs will have experts from Delphix, DBvisit and Dell to assist you on installing Delphix, DBvisit and Toad on your laptops. Delphix for example has a free version called Delphix Express that you can install during the labs.

Screen Shot 2015-10-02 at 11.05.49 AM

Screen Shot 2015-10-07 at 2.15.55 PM

Monday Oct 26 Tuesday Oct 27
8 Coffee 8amIntro with Mogens 8:30 Toon Koppelaars – hash joins and Bloom filters
9 Mark W. Farnham: Minimizing the concurrency footprint of transactions with Logical Units of Work stored in PL/SQL Bobby Durrett – Real World Delphix Exprience, hosted by Kyle Hailey
10 Kerry Osborne – SQL Translation Framework Kellyn Pot’Vin-Gorman and Stewart Bryson AWR Warehouse Trending and Analysis with OBIEE
11 Greg Rahn: Taming JSON with SQL: From Raw to Results Marco Gralike – Improving XML performance with the 12c In-Memory Column Store
12 ted talks ted talks
1 Dan Norris, Exadata Database Machine Security Cary Millsap – Performance
2 JB: AWR Ambiguity: What do do when the numbers don’t add up? Gwen Shapira – Introduction to Apache Kafka and Real-Time ETL
3 Kevin Closson. Modern Platform Topics for Modern DBAs Alex Gorbachev – Big Data
4 Tanel Poder: Connecting Oracle with Hadoop Chris Antognini – Adaptive Dynamic Sampling
Ted talks 5-10min Monday Tues
 Greg Rahn: What Cloud Can Offer For A DBMS Jonah H. Harris – The Best of Both Worlds: Providing MongoDB’s NoSQL advantages with Oracle Database
Jonathan Lewis – indexes, column groups and 12c Kellyn Pot’Vin-Gorman – TBD
 John King – Think Cloud is the “Same Old Thing retreaded?” – Why You’re Right but Mostly You’re Wrong Jonathan Lewis Virtual columns
Eric Grancher –  Graphing Outliers Tim Gorman – OpenZFS Adaptive Endianness and Cross-Platform Migrations
John King – What the Heck is Blockchain and Why Do I Care? Martin Kier -Volkswagen for Oracle Guys


Friday Philosophy – Antisocial Social Media and Sociopaths

Twice, on consecutive days a week or so back, I realised that someone I knew on Twitter but did not know in real life… was someone I knew in real life. But I’d never made the connection! With one person it was not that their real name was missing from their twitter profile, it was just my brain had linked all I knew about them to their handle. In the other case, as far as I can see there is nothing to link their slightly obscure handle to their physical persona, despite the fact they are tweeting quite often about Oracle and also present at conferences. So that was simply not playing fair to hide their real identity in that way and I feel slightly aggrieved.

I’ve also had the experience of meeting someone in the flesh who treats me like an old friend, is being nice to me {possibly some sales-person-type I should back away from, I initially wonder?} but also knows a fair bit about me {Oh no! Creepy-stalker-type! Must-run must-run must-run} – before it dawns on me that this is actually Randolph Toddlepoddle who I have known online for 5 years, comments on my blog and I respond. But I’ve never met. And who is now wondering why I am being so unfriendly, am backing slowly away from them with a fixed grin on my face and scanning for exits. This has actually happened to me several times now. Thankfully only once with each person (I think – names & faces are not my forte}.

XKCD comic 741

I have a relationship with you lot? {shudder!}

The result is that I am sure that for some people I have two utterly separate relationships with them – the online one and the in-the-flesh one. (According to xkcd comic 741 I have a relationship with you as you read my blog. When can I meet the parents?).

Another aspect of social media I feel is a little tricky for me, personally, is keeping track of what people have said to me and things I’ve said I’ll do. I have a poor memory, I can barely remember conversations last week. With email I can file them away and find them later (mostly I just file them away and wonder why my email directory is so massive). But with Twitter and Facebook comments? OK, so you can search but it is slow and it is not great. Only today (as I type) I remember being given some advice by my friend Brendan about writing articles. I went and checked my email ( under “friends/Brendan” or maybe “ora600/articles”, I can’t remember). Nope. Could I have put it elsewhere in my email store of information and event? Nope, no where in my email I could find. Ahh, it was a twitter conversation. Damn. Now I need to step back and find it…

Maybe there is an app to tie all this stuff together for me but I would have to find it and learn it and the vendor will get bored or go bust in 2 years and I’ll lose the lot then. I’d rather mow the lawn.

Then there is the much-commented-on aspect of online comments where some people seem to sign up to a service or follow someone, just so they can be snide or criticise. No, this is not the usual rant about these phalluses (phalli?), It’s more that I don’t read user comments on the BBC web site much anymore as it lowers my already pretty sociopathic outlook on the human race (don’t get me wrong, many individual humans are wonderful animals – but as a pack they are a nasty and destructive species). It’s not that there are nasty or thoughtless people who put these comments up, we learnt there are people like that in the school playground (or even in the classroom – Mr Jenkins, you know who you are). It’s just that seeing what people can put on social media reminds me more about how dysfunctional people can be than meeting people in the flesh does. Being able to have some control over people you meet in the flesh means real people don’t tend to enhance my sociopathic tendencies as much as social media.

I follow a couple of “humorous” twitter accounts. They put the same stuff up all the time, sometimes it’s obviously fake and they “borrow” from each other like crazy. But it’s just a few tweets and if I find the repetitive nature of it or their take on humour gives me less amusement than annoyance, I can always do that “unfollow” thing. I am not in any way being forced to be exposed to it. I don’t have to start commenting all the time about “you got this from redit!!!” or “You spelt that wrong you moron” or “That’s not funny, I can tell it’s a paper bag on a baby”. I made the mistake a couple of weeks back of responding to one saying “Dude, thanks for pointing out the totally obvious, it had CLEAR passed me by”. Yeah, I told you I had sociopathic leanings – I went and did what they had done to annoy me, there was no need for me to read the comments if I knew it would annoy me.

Of course, I could just stop joining in; close my twitter account, delete the blog, remove my inconsequential presence on facebook. But then, I’m now in all these relationships (sometimes two or three times with the same person). How can I break up with so many people? :-)

exitcommit … or your career down the drain

I recently posted a little video on the ‘exitcommit’ option in SQL Plus, adding a theatrical drama to present a worst case scenario of potentially destroying a Production system.  Take 3 mins to have a chuckle here.

My predecessor Natalka Roshak tweeted an interesting followup that I thought I would share, namely, if you’re a regular SQL Plus user, you should definitely take the time to check out the documentation on ‘exitcommit’ and its relationship to other related variables within SQL Plus.

Because you probably want to make sure you have got everything set just right !



NYOUG Session: Latches Demystified

Thank you all those who came to attend my session on demystifying latches at New York Oracle Users Group in Manhattan. I hope you found the session useful and enjoyable.

In this session, you learned:

What are latches – the purpose
Buffer cache latches
Shared pool latches
Identifying latch waits

Here is the slide deck and the scripts to reproduce the demos I showed as well as those I couldn't.

As usual, I will highly appreciate hearing from you how you liked it, or didn't. Please feel free to comment here or, contact me directly.

Twitter: @ArupNanda
Facebook: ArupKNanda
Google+ ArupNanda

Index Advanced Compression: Multi-Column Index Part II (Blow Out)

I previously discussed how Index Advanced Compression can automatically determine not only the correct number of columns to compress, but also the correct number of columns to compress within specific leaf blocks of the index. However, this doesn’t mean we can just order the columns within the index without due consideration from a “compression” perspective. As […]

OOW2015 Middleware Management

This posting covers the Middleware Management sessions at OOW2015. Note that these are middleware management via Enterprise Manager, as opposed to sessions specifically covering middleware features and functions. Also, I have not duplicated here sessions I have already documented under Oracle Management Cloud or Private Cloud / DBLM, so please visit those posts for sessions that fall under both categories. The following sessions fall under this category:

  • The Management of Identity and Access: Breaches, Compliance, Downtime, and Loss [CON9755] October 26, 11:00 am – 11:45 am | Moscone South—301 – Don’t accept operational risk—such as system failure or security breaches leading to fraud—as an unavoidable cost of doing business. Oracle Enterprise Manager plays a central role in the identification, measurement, monitoring, reporting, and mitigation of identity and access management operational risk. Proactive systems management is the only approach to reducing identity and access management operational risk where the cost of a single security, compliance, performance, or downtime event can start in the millions of dollars. Join this session to learn how Oracle Enterprise Manager makes operational risk events actionable from an IT operations and business perspective.
  • Centralized Access and Auditing for Oracle WebLogic Server Domain Administration [CON9742] October 26, 11:00 am – 11:45 am | Moscone South—303 – Securing an Oracle WebLogic Server domain in a production environment requires a lockdown of the console and the host server to safeguard against any unauthorized and unintentional configuration changes. Even mundane changes such as changing log level settings may cause availability problems if the host runs out of disk space or might possibly expose applications to security risks. Limiting access to domains and keeping detailed records on who changed what and when can be challenging across a large number of domains. This session explains and demonstrates how an IT operations team can utilize new Oracle Enterprise Manager functionality to provide controlled access across domains as well as an audit trail of any changes made to those domains. This presentation is co-presented by Lars Sandstrom at IKEA.
  • Advanced Management: Oracle SOA Suite and Oracle Service Bus with Oracle Enterprise Manager [CON9751] October 26, 1:30 pm – 2:15 pm | Moscone South—302 – In this panel session, Oracle SOA Suite and Oracle Service Bus administrators share their experiences managing their Oracle Fusion Middleware infrastructure with Oracle Enterprise Manager Cloud Control. The discussion goes beyond initial rollouts of management for production environments and delves into how these implementers have used advanced capabilities in Oracle Enterprise Manager Cloud Control to gain deep visibility into the functioning of their platforms. This session also covers new features and the roadmap for Oracle SOA Suite management as we look at the progression and growth of the administrators’ deployments. This presentation is co-presented by Greg Haertling from 7-Eleven and Vijay Plouri from GE.
  • Agile IT: Visibility and Management Across Oracle WebLogic Server and Oracle Java Cloud Service [CON9745] October 26, 1:30 pm – 2:15 pm | Moscone South—304 – In this session, learn the high-level details of how IDEXX has utilized middleware as a service on top of Oracle Exalogic in order to create a true self-service portal for developers and IT environments. In addition, this presentation delves into the hybrid approach to enterprise management using Oracle Enterprise Manager and Oracle Java Cloud Service on Oracle Public Cloud to build a true hybrid cloud solution capable of extending the enterprise to the next level. This presentation is co-presented by Brett Curtis from IDEXX Laboratories.
  • Oracle WebLogic Server: Automated and Simplified Management in a World of Clouds [CON8634] October 27, 11:00 am – 11:45 am | Moscone South—304 – Oracle continues to build native cloud management capabilities directly in Oracle WebLogic Server, making it easy to adopt as your application platform, regardless of your cloud adoption strategy—private, public, or hybrid. In this session, learn about new cloud-friendly REST management APIs in Oracle WebLogic Server that make automating the management of your domains easy, no matter where they are running. Simplified management doesn’t end there. Learn how Oracle Enterprise Manager Cloud Control enables you to manage your Oracle WebLogic Server infrastructure across all deployment host options—traditional, private, and public cloud (including Oracle Java Cloud Service)—all from a single pane of glass.
  • Monitor, Diagnose, and Optimize Java Workloads on Premises and in the Cloud [CON9740] October 27, 5:15 pm – 6:00 pm | Moscone South—309 – This session explores the new Java Virtual Machine (JVM) Diagnostics functionality including the new Java Workload Explorer. Learn how to use it to analyze on-premises Oracle WebLogic servers and Oracle Java Cloud Service JVMs running on Oracle Public Cloud or other Java-based applications. See demos on how to diagnose performance bottlenecks and memory issues, JVM resource utilization, and how to detect deadlocks. This session also shows how to ensure that service levels are maintained as the application evolves by comparing JVM behavior deployed on premises and in the cloud. Finally, hear how JVM Diagnostics is made for production environments—providing users with access to these capabilities without the need to share host credentials and inflicting only negligible overhead. This presentation is co-presented by Tahseen Mohammad from Therap Services.
  • Proactive Optimization of Java Workloads in Production Environments [CON6627] October 29, 2:30 pm – 3:30 pm | Hilton—Continental Ballroom 5 – Every application has its limits. Often these limits manifest themselves only when it is running in production under real load. Learn in this session how you can get visibility into the JVM internals without requiring host access and without incurring additional overhead on your JVM. Observe the application threads as they transition over time, understand resource utilization, and detect bottlenecks in the code. And get to know how to debug deadlocks and hung threads on a running server by observing stack frames and local variables and how to deal with application memory utilization inefficiencies.
  • HOL (Hands-on Lab) Session Managing Oracle Fusion Middleware with the New Oracle Enterprise Manager [HOL10453] Times haven’t been announced yet as I’m writing this, so you’ll need to keep an eye out for this one. In this hands-on lab, Oracle Enterprise Manager Cloud Control experts provide direct hands-on experience with some of Oracle’s latest technologies for Java, Oracle WebLogic Server, Oracle Coherence, and Oracle SOA Suite real-time and historical monitoring, diagnostics, and management, including:
    • Java Workload Explorer and live memory analysis
    • Oracle Coherence diagnostics and Heat Map
    • Oracle WebLogic and SOA log search and monitoring
    • Oracle WebLogic and Oracle Coherence deployment administration and auditing
    • Oracle SOA Suite diagnostics
  • Demos – there are also two demo booths where you can go and see the product in action – Oracle BI, BPM, and Oracle WebCenter Management with Oracle Enterprise Manager (Venue: Moscone South, Lower Left, Middleware), and Oracle WebLogic, Java Cloud Service, and SOA Management with Oracle Enterprise Manager (Venue: Moscone South, Lower Left, Middleware).

Don’t forget there are separate blog posts on Oracle Management Cloud, private cloud / DBLM and database management, so make sure to have a look at those!

The post OOW2015 Middleware Management appeared first on


Oracle 12c updates the TRUNCATE TABLE statement allowing the use of CASCADE to eliminate values in tables that are referentially connected.

This option is something that some shops were looking for from Oracle; it is possible that your shop will not find the need for this option.


Here is the syntax:


(other TRUNCATE TABLE options such as those for MATERIALIZED VIEWs and/or STORAGE may still be specified)



  • Child table referential security must specify “ON DELETE CASCADE” or the statement will fail
  • If layers of tables are referentially connected and all specify “ON DELETE CASCADE” the system will CASCADE as directed


Here is some example code:


*** Setting up sample tables ***

#0000ff;">SQL> --
#0000ff;">SQL> -- Example Truncate Cascade
#0000ff;">SQL> --
#0000ff;">SQL> drop table dept2;
#0000ff;">Table DEPT2 dropped.
#0000ff;">SQL> drop table emp2;
#0000ff;">Table EMP2 dropped.
#0000ff;">SQL> create table dept2 as select * from dept;
#0000ff;">Table DEPT2 created.
#0000ff;">SQL> create table emp2 as select * from emp;
#0000ff;">Table EMP2 created.
#0000ff;">SQL> alter table dept2 add constraint deptnoPK primary key (deptno);
#0000ff;">Table DEPT2 altered.
#0000ff;">SQL> alter table emp2 add constraint empnoPK primary key (empno);
#0000ff;">Table EMP2 altered.
#0000ff;">SQL> alter table emp2 add constraint deptnoFK foreign key (deptno)
#0000ff;">   references dept2
#0000ff;">   on delete cascade;
#0000ff;">Table EMP2 altered.
#0000ff;">SQL> select * from dept2;
#0000ff;">   DEPTNO  DNAME           LOC        
#0000ff;">---------- -------------- -------------
#0000ff;">       10  ACCOUNTING      NEW YORK    
#0000ff;">       20  RESEARCH        DALLAS      
#0000ff;">       30  SALES           CHICAGO    
#0000ff;">       40  OPERATIONS      BOSTON      
#0000ff;">SQL> select * from emp2;
#0000ff;">     EMPNO ENAME     JOB             MGR HIREDATE         SAL       COMM
#0000ff;">---------- ---------- --------- ---------- --------- ---------- ----------
#0000ff;">   DEPTNO
#0000ff;">     7369 SMITH     CLERK           7902 17-DEC-80       800          
#0000ff;">       20
#0000ff;">     7499 ALLEN     SALESMAN       7698 20-FEB-81       1600       300
#0000ff;">       30
#0000ff;">     7521 WARD       SALESMAN       7698 22-FEB-81       1250       500
#0000ff;">       30
#0000ff;">     7566 JONES     MANAGER         7839 02-APR-81       2975          
#0000ff;">       20
#0000ff;">     7654 MARTIN     SALESMAN       7698 28-SEP-81       1250       1400
#0000ff;">       30
#0000ff;">     7698 BLAKE     MANAGER        7839 01-MAY-81       2850          
#0000ff;">       30
#0000ff;">     7782 CLARK     MANAGER         7839 09-JUN-81       2450          
#0000ff;">       10
#0000ff;">     7788 SCOTT     ANALYST         7566 19-APR-87       3000          
#0000ff;">       20
#0000ff;">     7839 KING       PRESIDENT           17-NOV-81       5000          
#0000ff;">       10
#0000ff;">     7844 TURNER     SALESMAN       7698 08-SEP-81       1500         0
#0000ff;">       30
#0000ff;">     7876 ADAMS     CLERK           7788 23-MAY-87       1100          
#0000ff;">       20
#0000ff;">     7900 JAMES     CLERK           7698 03-DEC-81       950          
#0000ff;">       30
#0000ff;">     7902 FORD       ANALYST         7566 03-DEC-81       3000          
#0000ff;">       20
#0000ff;">     7934 MILLER     CLERK           7782 23-JAN-82       1300          
#0000ff;">       10
#0000ff;">14 rows selected


*** Show that Referential Integrity is working ***

#0000ff;">SQL> insert into emp2
#0000ff;">Error starting at line : 16 in command -
#0000ff;">insert into emp2
#0000ff;">Error report -
#0000ff;">SQL Error: ORA-02291: integrity constraint (JOHN.DEPTNOFK) violated - parent key not found
#0000ff;">00000 - "integrity constraint (%s.%s) violated - parent key not found"
#0000ff;">*Cause:   A foreign key value has no matching primary key value.
#0000ff;">*Action:   Delete the foreign key or add a matching primary key.
#0000ff;">SQL> --
#0000ff;">SQL> commit;
#0000ff;">Commit complete.


*** Show use of TRUNCATE CASCADE ***

#0000ff;">SQL> -- The following statement will fail; table has child rows
#0000ff;">SQL> truncate table dept2;
#0000ff;">Error starting at line : 23 in command -
#0000ff;">truncate table dept2
#0000ff;">Error report -
#0000ff;">SQL Error: ORA-02266: unique/primary keys in table referenced by enabled foreign keys
#0000ff;">00000 - "unique/primary keys in table referenced by enabled foreign keys"
#0000ff;">*Cause:   An attempt was made to truncate a table with unique or
#0000ff;">           primary keys referenced by foreign keys enabled in another table.
#0000ff;">           Other operations not allowed are dropping/truncating a partition of a
#0000ff;">           partitioned table or an ALTER TABLE EXCHANGE PARTITION.
#0000ff;">*Action:   Before performing the above operations the table, disable the
#0000ff;">           foreign key constraints in other tables. You can see what
#0000ff;">           constraints are referencing a table by issuing the following
#0000ff;">           command:
#0000ff;">           SELECT * FROM USER_CONSTRAINTS WHERE TABLE_NAME = "tabnam";
#0000ff;">SQL> -- Command will succeed; child rows will be truncated too
#0000ff;">SQL> truncate table dept2 cascade;
#0000ff;">Table DEPT2 truncated.
#0000ff;">SQL> -- proof
#0000ff;">SQL> select * from dept2;
#0000ff;">no rows selected
#0000ff;">SQL> select * from emp2;
#0000ff;">no rows selected

As always, TRUNCATE should be use with full awareness that you cannot ROLLBACK a TRUNCATE, nor can you flash back to the state of the table before the truncate.

You may not TRUNCATE the parent table of a referenced-partition table; the reference-partitioned child must be dropped first.


Again this may not be for you; however, for some this is a really great new feature!

OOW2015 Database Manageability

This posting covers the Database Manageability sessions at OOW2015. Note that these are database manageability via Enterprise Manager, as opposed to sessions specifically covering database features and functions. The following sessions fall under this category:

  • Risk-Free Administration for Expert Database Administrators [CON9725] October 26, 4:00 pm – 4:45 pm | Moscone South—104 – The SPA Quick Check, SQL Performance Analyzer, Database Replay, and Concurrent Replay features in Oracle Real Application Testing provide a cost-effective and easy-to-use solution for assessing the impact of changes on production databases, either on premises or in the cloud. To stay ahead of the curve, you need the best available technology to ensure the most dependable and predictable performance. This session discusses the day-to-day uses of the above tools, and when and how to best use them to ensure a smooth and simple migration to the cloud. This presentation includes two customer use cases, one from Salesforce and one from Cerner.
  • Oracle Exadata Monitoring and Management Best Practices [CON9727] October 26, 12:15 pm – 1:00 pm | Intercontinental—Intercontinental B (5th Floor) – Oracle Enterprise Manager uses a holistic approach to manage Oracle Exadata Database Machine, providing comprehensive performance and lifecycle management from testing and deployment to proactive monitoring and ongoing maintenance across the entire engineered system. In this session, hear about new capabilities in the upcoming Oracle Enterprise Manager plugin for Oracle Exadata that includes Oracle Exadata virtualization provisioning and monitoring, the ability to monitor the latest Oracle Exadata hardware, Exacheck (ORAchk), Exadata Sparse Cloning, and the Automatic Service Request capability for Oracle Exadata hardware targets in Oracle Enterprise Manager. This presentation also includes two customer use cases, one from HDFC Bank and the other from Wellsfargo.
  • Next-Generation Database Management: Advanced Topics for Expert DBAs [CON9107] October 26, 1:30 pm – 2:15 pm | Moscone South—104 – The recently announced Oracle Management Cloud and the latest release of Oracle Enterprise Manager have many new database management features for expert DBAs. In this session, we discuss key new features that help maximize database performance, enable smart capacity planning, and provide the basis for smart and effective database administration.
  • Oracle Enterprise Manager Database Consolidation Workbench—Secret to Successful Consolidation [CON9718] October 26, 2:45 pm – 3:30 pm | Moscone South—300 – The need to reduce IT costs and increase business agility are driving businesses to consolidate and move to either a private database cloud or Oracle Database Cloud Service. Given the many challenges and choices available in this process, the road to consolidation requires a systematic approach to planning and choosing the right consolidation strategy, validating it, and performing database migration. Join this session to learn how Oracle Enterprise Manager Database Consolidation Workbench provides exciting capabilities that enable you to best consolidate and perform database migration to the consolidated platform including Oracle Public Cloud, and validate the chosen migration strategy with Oracle Real Application Testing. This presentation also includes a use case from HDFC Bank.
  • Tips and Techniques for Maximizing Database Performance: Theory and Practice [CON9723] October 26, 5:15 pm – 6:00 pm | Moscone South—104 – Oracle Database and Oracle Enterprise Manager introduce new, exciting capabilities that help improve DBA productivity and maximize performance while reducing management costs. This session covers the theory behind performance diagnosis and tuning and the new and upcoming capabilities in Oracle Database and Oracle Enterprise Manager, such as Hybrid Cloud Management, Automatic Workload Repository multitenant enhancements, Automatic Workload Repository and SQL Tuning Advisor support for Oracle Active Data Guard, Performance Hub Reports, Database Operations Monitoring, and more. This session provides tips on when and how to best use the above mentioned features that will help DBAs with day-to-day tasks. This presentation also includes a customer use case, Cerner.
  • HOL (Hands-on Lab) Session Maximizing Oracle Database 12c Performance with Oracle Enterprise Manager [HOL10442] Times haven’t been announced yet as I’m writing this, so you’ll need to keep an eye out for this one. Tired of maintaining old DBA scripts that tune Oracle databases? Are database performance problems getting you down? If yes, attend this hands-on lab that guides you to modern methodologies that detect and diagnose problems, and tune database performance in Oracle Database 12c. In this lab, learn how to optimize your database performance with the most up-to-date recommendations, and how to make risk-free changes that improve system performance while maintaining stability and reliability.
  • Demos – there are also two demo booths where you can go and see the product in action – End-to-End Database Performance Management @Workstation ID SLD-023 (Venue: Moscone South, Upper Left, Database) and End-to-End Engineered Systems Manageability with Oracle Enterprise Manager (Venue: Moscone North, Lower Lobby, Engineered Systems Showcase)

Don’t forget there are separate blog posts on Oracle Management Cloud, private cloud / DBLM and middleware management, so make sure to have a look at those!

The post OOW2015 Database Manageability appeared first on

OOW2015 Private Cloud and DBLM

Yesterday I posted an entry on what was coming with OOW2015, specifically discussing the Oracle Management Cloud sessions. This post is similar but looking at one of the more “traditional” EM areas that my team is responsible for – Private Cloud and DBLM. The sessions that are of most interest here are:

  • Hybrid Cloud Management Using Oracle Exalogic [CON9744] October 26, 11:00 am – 11:45 am | Intercontinental—Intercontinental B (5th Floor) – The latest version of Oracle Exalogic introduces an agile stack based on Oracle’s Nimbula technology that can be leveraged for infrastructure as a service (IaaS) and platform as a service (PaaS) across on-premises and hybrid clouds. Oracle Enterprise Manager combined with the Nimbula technology offers an integrated set of capabilities including service-catalog–driven provisioning, RESTful APIs, metering and show-back, and cloud governance. Oracle Enterprise Manager also enables Oracle WebLogic and SOA as a service on Oracle Exalogic, rendering it the platform of choice for enterprise-scale PaaS. This presentation includes a customer use case (which is always more interesting than listening to us rattle on!) from Simone Traversari at Bridge Consulting.
  • Large-Scale Patch Automation for the Cloud-Generation DBAs [CON9749] October 26, 5:15 pm – 6:00 pm | Moscone South—300 – This is the cloud generation. Patching databases and underlying platforms in silos is a thing of the past. As enterprise IT implements large-scale database as a service (DBaaS), the databases need to be patched at scale without incurring long downtimes for consumers. Oracle Enterprise Manager offers unique fleet management and scripting capabilities that can patch databases at scale and provide consumers with the flexibility to minimize downtime. The fleet management capabilities, complemented by patch advisory and reporting features, make Oracle Enterprise Manager the de facto choice for the cloud-generation DBAs.
  • Latest Innovations in Database as a Service Enabled by Oracle Enterprise Manager [CON9734] October 27, 4:00 pm – 4:45 pm | Moscone South—300 – Over the last few years, Oracle Enterprise Manager has become the control center for database as a service. It leverages various underlying technologies including multitenant and storage snapshotting to offer consolidation planning, rapid provisioning, monitoring, and cloud governance. The innovations in this area continue at a rapid pace with Oracle Enterprise Manager Database Consolidation Workbench, hybrid cloud migration, and continuous data refresh for DevOps. In this session, attendees learn about these innovations and hear successful case studies from other customers.
  • Servers, Storage, Virtualization, and More: Managed Through a Single Pane of Glass [CON9733] October 27, 4:00 pm – 4:45 pm | Intercontinental—Intercontinental C (5th Floor) – Server virtualization is pervasive in today’s IT world. Whether on Oracle’s x86 systems or on Oracle’s SPARC, administrators continue to deploy virtual machines to address issues of consolidation, agility, and resource isolation. However, the technology comes with its own set of administrative challenges around monitoring, sprawl, and configuration management. In this session, speakers cover the new infrastructure management capabilities of Oracle Enterprise Manager that can help sys admins face those challenges more effectively than ever before for both SPARC and x86-based environments.
  • Upgrading Oracle Enterprise Manager: Why and How [CON9729] October 27, 12:15 pm – 1:00 pm | Moscone South—300 – The upcoming release of Oracle Enterprise Manager brings, for the first time, a converged management for Oracle hardware and software. It also includes exciting new enhancements to uninterrupted monitoring, hybrid cloud management, and engineered systems management that make the upgrade worth it. This session outlines the new capabilities and provides best practices to seamlessly upgrade your existing environment to the upcoming release of Oracle Enterprise Manager.
  • Oracle Enterprise Manager: The Future of Hardware Management [CON9732] October 27, 12:15 pm – 1:00 pm | Intercontinental—Intercontinental C (5th Floor) – Oracle Enterprise Manager Cloud Control has been the flagship product for managing Oracle software. The latest release of Oracle Enterprise Manager Cloud Control combines infrastructure management (for virtualization, servers, storage, and network) with existing software management making it the only provider of comprehensive app-to-disk systems management. This session covers how Oracle Enterprise Manager can manage servers (X, T, and M series), Oracle virtual machines, engineered systems, storage, and network all in the context of an application. This session also provides valuable information for existing Oracle Enterprise Manager Ops Center customers on how they can benefit from these features.
  • Managing Configuration Compliance in and Across the Clouds [CON9750] October 28, 11:00 am – 11:45 am | Moscone South—300 – Did you think that “hybrid cloud” meant that the phone call from the security officer is going to disappear? You’re mistaken. “Hybrid cloud” implies increased scrutiny from security and compliance officers—more than ever before. Whether the instances are hosted on Oracle Cloud or on premises, Oracle Enterprise Manager offers a single pane of glass for service-level agreements (SLAs) and compliance management, providing an aggregated view for administrators, CIOs, and compliance officers. It ships with thousands of rules that can be mapped to PCI, STIG, or other compliance frameworks. This session recaps those powerful capabilities and drills down into their applicability to hybrid clouds. This presentation includes a customer use case, from Sarah Brydon of PayPal.
  • Data on Demand: Advanced Cloning Automation for DBAs [CON9748] October 28, 1:45 pm – 2:30 pm | Moscone South—300 – Data is in demand. As the number of applications grow, DBAs, QA engineers, and developers need copies of their production data on an ongoing basis—quickly and securely. Oracle Enterprise Manager provides two differentiated capabilities to address this surge in demand without affecting on-premises storage. First, it can lift and shift an on-premises database to Oracle Cloud—eliminating CapEx altogether. Second, it provides a unique Snap Clone technique that lets users create hundreds of copies of the database with minimal additional storage. This session covers data cloning and data refresh in general, while highlighting these two capabilities.
  • Best Practices for Engineered Systems Management Using Oracle Enterprise Manager [CON9728] October 28, 4:15 pm – 5:00 pm | Intercontinental—Intercontinental B (5th Floor) – The new release of Oracle Enterprise Manager unleashes a wide range of capabilities for managing Oracle engineered systems that span Oracle Exadata, Oracle Exalogic, Oracle Exalytics, Oracle SuperCluster, and purpose-built appliances like Oracle Database Appliance, Oracle Big Data Appliance, Oracle’s Zero Data Loss Recovery Appliance, and Oracle’s Virtual Compute Appliance. Besides providing deeper management of the hardware components, the new release of Oracle Enterprise Manager also introduces a complete patching workflow for the entire stack of Oracle Exadata and Oracle Exalytics solutions that can reduce the patching time while eliminating human errors. In this session, get details on the wide set of capabilities with specific emphasis on Oracle Exadata and Oracle Exalytics patching.
  • PaaS-ify Across on Premises and Oracle Cloud with Ease [CON9747] October 29, 10:45 am – 11:30 am | Moscone South—300 – Deploy, move, and manage your applications with ease anytime, anywhere, both on premises or in Oracle Cloud—with a single pane of glass. Oracle Enterprise Manager provides that single pane of glass that lets DevOps and IT administrators deploy applications into the cloud or migrate them across clouds, and most important, monitor and manage them on a continual basis. In this session, learn how existing capabilities for middleware as a service extend seamlessly to Oracle Cloud to provide agility without compromising on visibility and management. This presentation includes case studies from both a customer and a partner.
  • Scaling the Limits of the Cloud with the New Oracle Enterprise Manager [CON9731] October 29, 1:15 pm – 2:00 pm | Moscone South—300 – The cloud is BIG. The cloud is VAST. With cloud computing, the scale of IT has changed from a few hundred assets to hundreds of thousands of assets. This necessitates a newly engineered monitoring, automation, and reporting framework that is nimble, scalable, and real time. The new release of Oracle Enterprise Manager introduces real-time monitoring, a scalable job system that can integrate with the industry’s leading automation frameworks like Chef, and a comprehensive reporting infrastructure. This session covers these new enhancements along with anecdotal experiences from Oracle’s own cloud operations.
  • HOL (Hands-on Lab) Session – Consolidate and Standardize Database Resources with Lifecycle and Private Cloud Management [HOL10468] Times haven’t been announced yet as I’m writing this, so you’ll need to keep an eye out for this one. In this hands-on lab, experience firsthand how Oracle Database Lifecycle Management Pack manages the complexities of the database lifecycle across your data centers, including automated discovery of assets, agile provisioning, and cloning of databases; patching and upgrade automation; and schema comparison plus drift and compliance management. In addition, experience the enhanced automation capabilities of Oracle Enterprise Manager’s comprehensive database as a service to provision databases from a uniform service catalog.
  • HOL (Hands-on Lab) Session – Hybrid Cloud Management: Complete Management of On-Premises and Public Services [HOL10465] Times haven’t been announced yet as I’m writing this, so you’ll need to keep an eye out for this one. In this hands-on lab, learn how Oracle Enterprise Manager 12c automates complex management tasks across the complete cloud lifecycle. Cloud services are managed by the same Oracle Enterprise Manager tools that customers use on premises to monitor, provision, and maintain Oracle databases, Oracle engineered systems, Oracle Applications, Oracle middleware, and a variety of third-party systems. This additionally eliminates the costly consequences of purchasing and learning how to use numerous new tools to manage enterprise hybrid clouds. In this demo, experience how Oracle Enterprise Manager can provide Lift and Shift capabilities across hybrid clouds while providing consistent governance and compliance.
  • HOL (Hands-on Lab) Session – Oracle Systems and Virtualization Management with Oracle Enterprise Manager [HOL10466] Times haven’t been announced yet as I’m writing this, so you’ll need to keep an eye out for this one. In this hands-on lab, explore the natively integrated hardware management in Oracle Enterprise Manager—the latest Oracle Enterprise Manager with a single-pane-of-glass view from application to disk that provides support for monitoring and management of Oracle’s SPARC and x86 physical and virtualized environments. It also unleashes a wide range of capabilities for managing Oracle engineered systems like Oracle SuperCluster and Oracle Exadata. Participants choose from a variety of exercises that:
    • Walk through home pages of a host and server targets
    • Walk through a home page of an Oracle SuperCluster target
    • Walk through a home page of a virtualized systems target
    • Monitor inventory, performance, and configuration management of system components
  • Demos – there are also three demo booths where you can go and see the product in action (all in Moscone South) – Database Lifecycle Management, Database as a Service, Snap Cloning with Oracle Enterprise Manager @Workstation ID SLD-025, Oracle SPARC/x86 Systems and Virtualization Management with Oracle Enterprise Manager (location TBD but it will be in Moscone South, Center, Engineered Systems, Servers and Storage), and Hybrid Cloud Management: Single Pane of Glass for Complete Management—On-Premises and Public Cloud @Workstation ID SLD-026

Don’t forget there are separate blog posts on Oracle Management Cloud, database management and middleware management, so make sure to have a look at those!

The post OOW2015 Private Cloud and DBLM appeared first on