Monday Mar 23, 2015

Oracle Database Innovation Forum FAQ

Just in case you missed it- Watch the Forum On-Demand!

The Oracle Database Innovation Forum that was broadcast on March 18th and is now available on-demand. Once you registered, stay as long as you like or return at your convenience to watch another session or replay one that's really made an impact. The forum, featuring Oracle Database guru Tom Kyte, was followed by Oracle Database Innovation experts and customers sharing best practices and the reasons why they chose Oracle Database 12c. The Forum keynote and following sessions provide a little something for everyone - from DBaaS and Multitenant and private clouds - to Big Data, Database In-Memory and Data Warehousing best practices. Sessions on Database Management and Advanced Security, High Availability, Storage Optimization and even best practices for upgrading to Oracle Database 12c are offered.

Forum FAQ

During the forum, we received so many great questions that I'll share only a few with you here. The questions we get most often concern licensing database options and comparing Enterprise Edition and Standard Edition features and option availability. A great resource to help you  understand the Oracle Database options can be found in this 'family' white paper

Here are three questions we received about Oracle Multitenant:

Q: How does a Multitenant architecture differ from a traditional SQLSERVER instance based architecture?

A: In that Microsoft SQL Server supports multiple "databases" within a single server, while Oracle Multitenant supports multiple Pluggable Databases (PDBs) within a single Container Database (CDB), there is a superficial similarity between the two. There are some important differences, however, Microsoft SQL Server users are defined at server level, so there's imperfect namespace isolation, which makes it less suitable for Database as a Service (DBaaS). SQL Server Databases are difficult to move between servers. By contrast the pluggable portability of Pluggable Databases (PDBs) allows for a great range of flexibility.

Q: We are already using OVM for consolidation - what does Multitenant give us over that?

A: OVM is good for infrastructure consolidation. Multitentant is specifically designed for databsase consolidation - much higher consolidation density, simpler management as you can now manage many databases as one. You could still use MT for further consolidation benefits on top of OVM.

Q: Do you have any guidance regarding capacity/resource sizing of multitenant database?

A: This is highly dependent on the loads being consolidated. The savings are proportional to the numbers of databases consolidated. Rough rules of thumb for minimal savings are about 1.5GB per database and maybe 1/3 core for databases under load. On top of that, you might expect greater savings because of the ability to share "peaks and troughs" in load. In terms of storage, snapshot clones facilitate huge savings in storage and IOPS. Don't forget the operational savings because of the ability to manage many databases as one.

Three questions we received about Oracle Database In-Memory:

Q: How is In-Memory enabled?

A: Database In-Memory is enabled by setting the initialization parameter inmemory_size > 0.

Q: Does Oracle Database 12c using in-memory capabilities by default, or does the DBA need to configure?

A: Oracle Database 12c does not enable Database In-Memory by default. To enable Oracle Database In-Memory the inmemory_size initialization parameter must be set to a value greater than zero. You then need to alter one or more tables, partitions, sub-partitions or materialized veiws to be populated into the IM column store. The Oracle optimizer can then transparently make use of the IM column store.

Q: Does Database In-memory have a hardware dependency like some specific quality of RAM?

A: No, Database In-Memory can run on any hardware platform supported for Oracle Database 12c. You do have to have enough memory to support the In-Memory column store in addition to the other components in the SGA though.

Three questions about Automatic Data Optimization:

Q: Are indexes automatically maintained during the ILM compression (alter table move partition update indexes)?

A: Yes, indexes are automatically maintained when applying a compression policy.

Q: Why not always compress to the highest level that saves I/O?

A: You make the decision based on the type of data. Archive data, that is accessed less frequently, should be compressed at the highest rate. Read more about Oracle Automatic Data Optimization

Q: Is Automatic Data Optimization available on all servers or only on Oracle Exadata?

A: ADO is what can be achieved with a combination of database storage optimization technologies used on any hardware. Of course we optimize engineered systems for the Oracle Database so we think there are some great advantages over commodity hardware infrastructures that you build yourself.

Here's the complete FAQ.

Friday Mar 06, 2015

Tap into Tom Kyte's Expertise at the Oracle Database Innovation Online Forum

As if having Tom Kyte kick off the Oracle Database Innovation Forum online March 18th weren't enough, there are ten additional reasons for you to attend. Oracle Database experts and customers will talk about Database as a Service and Oracle Multitenant in public and private cloud deployments, Big Data, Oracle Database In-Memory and data warehousing best practices, Database Security, High Availability, Storage Optimization and best practices for upgrading and managing Oracle Database 12c.

Tom Kyte will provide a closer look at the innovations and top reasons customers are moving to Oracle Database 12c.  Attend the Oracle Database Innovation Online Forum - March 18.

Image result for tom kyteRegister today!

Tuesday Feb 10, 2015

Are you ready for cloud computing?

How do you database?

In-Memory? Multitenant? Security? Big Data? HA?

At our March 18, 2015 Oracle Database Innovation Forum, you’ll discover the benefits of mission critical performance, availability, data security, and lower cost savings with the world's most innovative database, Oracle Database 12c.

Register today to join Tom Kyte, Maria Colgan and other Oracle Database 12c product gurus!

Wednesday Feb 04, 2015

Five best practices for PaaS [Platform as a Service]

In the Fall of 2014, ComputerWorld published a report detailing the results from a survey conducted with 300 IT executives and practitioners worldwide. The questions ranged from type of applications being run on the cloud now and in the future, support for mission-critical apps, the challenges faced from an interoperability perspective, and more. The results highlighted some critical insights from these experts which for certain topics were surprisingly significantly aligned. Calling this phenomena [this alignment] the wisdom of the crowd, we bet that as the industry moves forward with the cloud initiative, IT leaders worldwide are increasingly adopting these practices, driving these to become best practices. Hence our attempt at culling these and putting these within an infographic, so its easily available at a birds eye view level to IT practitioners undertaking their cloud journey right now.

Check out this infographic

For further details, refer to the the ComputerWorld Survey report

Wednesday Jan 14, 2015

Coming Feb 11, 2015 Oracle Technology Network (OTN) Virtual Technology Summit: Free Hands-On Learning with Oracle and Community Experts

Learn to master Oracle Database 12c to meet today’s IT challenges from Oracle ACEs and Oracle Product Experts.

Database Developers can explore two tracks in this session:

  • Database upgrade strategies and techniques
  • New tools, APEX 5.0, new capabilities of current tools, PL/SQL tricks and tips and JSON for enterprise application development
Register now and serve your spot today! 

Friday Dec 19, 2014

Oracle Maximum Availability Architecture Blog

Check out the Maximum Availability Architecture blog for the latest on Oracle Database high availability and data protection offerings, best practices and technology strategy. Oracle Maximum Availability Architecture (MAA) enables organizations to address all types of unplanned and planned outages - from component failures to region-wide disasters to planned maintenance, upgrades and migrations. These blog postings are created and maintained by members of Oracle’s Maximum Availability Architecture team within Oracle’s Server Technology Development group and the Oracle Database HA product marketing team. The MAA team interacts with Oracle’s customers around the world on various critical high availability (HA) initiatives. Our goal is to enrich the Oracle ecosystem with an interesting, informative and interactive conversation around Oracle MAA.

Recent updates to the MAA blog include the following topics:

Maximum Availability Architecture

Data Protection

High Availability

Please refer to the MAA website on OTN -, for the latest collection of best practices for Oracle MAA.

Tuesday Dec 09, 2014

How Do You Database?

No matter what your solution need, we've got you covered with continuous innovation!

So HOW do you database?

  • Multitenant to consolidate?
  • Implement Database as a Server to provision standardized database environment?
  • Keep your business online 24x7 with high availability?
  • Safeguard to ensure privacy and compliance via top-notch security?
  • Access to all your information with big data?

Check out the #1 product in the market - Oracle Database 12c - today!


Thursday Dec 04, 2014

You + #C15LV = Love.

Tell IOUG why you love COLLABORATE 15 & Get Your Chance to Win One of Three Free Registrations!

Enter by 12/12

Good Luck! 

Monday Nov 10, 2014

Turbocharge Your PL/SQL Code

Get ready to boost the performance of your multi-row SQL statements executed from within a PL/SQL!

ODTUG is hosting a Nov 13th webcast with Oracle architect and PL/SQL guru, Steven Feuerstein. 

Plan to join Steven to discover how FORALL and BULK COLLECT features can turbocharge your code for optimal performance gains.

Register today!

Wednesday Oct 22, 2014

Up you database skill level!

Learn Oracle with the new Oracle Database 12c Release 1 training series.

Tuesday Oct 21, 2014

October Database Insider Newsletter

October Edition of the Database Insider Newsletter is now available.

Highlights include:


Oracle Executives Ellison and Mendelsohn Talk About Database Innovations at Oracle OpenWorld 2014

Access full-length Oracle OpenWorld 2014 keynotes featuring Executive Chairman and Chief Technology Officer Larry Ellison and Executive Vice President of Server Technologies Andy Mendelsohn, who discuss the latest capabilities and future directions of Oracle Database solutions.
Read More

Oracle Reinvents Database Protection with Zero Data Loss Recovery Appliance

During his opening keynote at Oracle OpenWorld 2014, Oracle Executive Chairman and Chief Technology Officer Larry Ellison announced the general availability of Oracle’s Zero Data Loss Recovery Appliance, the world's first and only engineered system designed specifically for database protection. This massively scalable appliance delivers unparalleled data protection, efficiency, and scalability.
Read More


Monday Sep 29, 2014

Oracle Reinvents Database Protection with Zero Data Loss Recovery Appliance

Reinventing Database Protection

During his opening keynote at Oracle OpenWorld 2014, Oracle Executive Chairman and Chief Technology Officer Larry Ellison announced the general availability of Oracle’s Zero Data Loss Recovery Appliance, the world's first and only engineered system designed specifically for Oracle Database protection. This massively scalable appliance delivers unparalleled data protection, efficiency, and scalability.

Unparalleled Data Protection

Visit the Main Landing Page

Read the Enhanced Press Release

Watch Sr. Vice President Juan Loaiza's Webcast

Read the story, featuring an interview with Ashish Ray, VP of Product Management

Oracle's Zero Data Loss Recovery Appliance (Recovery Appliance) is the first appliance ever to deliver zero data loss protection for critical Oracle Databases. When using today’s solutions to restore a database, businesses typically lose all data generated since the last backup—often hours to days of critical data.
The Recovery Appliance dramatically reduces the impact of backups on production servers and networks, virtually eliminating the need for lengthy backup windows. The cloud-scale architecture enables a single Recovery Appliance to manage the data protection requirements of thousands of databases, avoiding the cost and complexity of disparate backup systems. 

Zero Data Loss Recovery Appliance infographic

View the Infographic

Key Messages:

  • Eliminates data loss: Unique database integration enables continuous transport of redo data to the appliance, providing real-time protection for the most recent transactions so that databases can be restored without data loss.
  • Eliminates production impact: Backup algorithms integrated into Oracle Database send only changed data to the appliance, minimizing production database impact, I/O traffic, and network load. All expensive backup processing is offloaded to the Appliance.
  • Offloads tape archival: The Recovery Appliance can directly archive database backups to low-cost tape storage, offloading production database servers. Archival operations can run both day and night to improve tape drive utilization.
  • Enables restore to any point in time: The database change data stored on the Appliance can be used to create virtual full database copies at any desired point in time.
  • Delivers cloud-scale protection: A single Recovery Appliance can serve the data protection requirements of thousands of databases in a data center or region. Capacity expands seamlessly to petabytes of storage, with no downtime.
  • Protects data from disasters: The Recovery Appliance can replicate data in real time to a remote Recovery Appliance or to Oracle Database Backup Cloud Service to protect business data from site outages. Database blocks are continuously validated to eliminate data corruption at any stage of transmission or processing.

Want to learn more?

What else is happening at Oracle OpenWorld 2014 that includes the Zero Data Loss Recovery Appliance? Check out the following sessions:

  • Monday, Sept. 29:  2:45 - 3:30 (CON7684) - Moscone South - 307

Oracle Zero Data Loss Recovery Appliance: A New Era in Data Protection

  • Tuesday, Sept. 30:  3:45 - 4:30 (CON7686) - Moscone South - 305

Oracle Zero Data Loss Recovery Appliance: Deployment Best Practices 

And don't forget to see the Zero Data Loss Recovery Appliance in action. Visit the Engineered Systems Showcase at Moscone Center North and take a tour with one of our product experts.

Friday Sep 19, 2014

Register Today for Oracle Database Oracle OpenWorld Sessions

Oracle OpenWorld Main Registration?

Hotel Reservation?

Transportation Reservation?

Registered for Sessions?  Wait?  We register for the sessions?  Yep.  Some sessions are offered and registered for attendance via the Schedule Builder.  Here are some sessions to register for now so you are assured a seat!

Andy Mendelsohn's General Session: Oracle Database Directions for Big Data and the Cloud [GEN7243]

Monday, Sep 29, 10:15 AM - 11:15 AM - Marriott Marquis - Salon

The last 12 months have witnessed a range of Oracle product releases to help customers embrace the cloud and gain easier access to reservoirs of big data. Join Oracle Executive Vice President Andy Mendelsohn in this session to learn how the latest Oracle Database 12c innovations, including Oracle Database In-Memory and Oracle Big Data SQL, can help businesses improve their bottom line with fast, real-time access to all their datasources.

YesSQL! A Celebration of SQL and PL/SQL [CON9027]

Monday, Sep 29, 6:30 PM - 8:00 PM - Moscone South - 103

Cohosted by Tom Kyte and Steven Feuerstein, YesSQL! is an Oracle OpenWorld event celebrating SQL, PL/SQL, and the people who both make the technology and use it. Attendees as well as special guests including Andy Mendelsohn and Maria Colgan share their stories of how Oracle technology has had a big impact on their life and work. Bottom line: if developing applications against Oracle Database is a big part of your life, don’t miss this fun and uplifting evening!

Oracle Big Data: Strategy and Roadmap [CON8276]

Monday, Sep 29, 2:45 PM - 3:30 PM - Moscone South - 104 

Confused about what is or is not big data from an Oracle perspective? This overview session covers Oracle’s big data strategy; roadmap; and benefits for software, hardware, and cloud offerings. It covers the Oracle big data management system, which includes Hadoop, NoSQL, and relational options; data integration, including Oracle Big Data Connectors, Oracle GoldenGate, and Oracle Data Integrator; and business analytics, including Oracle Business Intelligence

Oracle Big Data Appliance: Deep Dive and Roadmap for Customers and Partners [CON8279]

Monday, Sep 29, 5:15 PM - 6:00 PM - Moscone South - 104 

Oracle Big Data Appliance is the premier Hadoop appliance in the market. This session describes the roadmap for customers in the areas of high-performance SQL on Hadoop and securing big data, plus overall performance improvements for Hadoop. A special focus in the session is the roadmap and benefits Oracle Big Data Appliance brings to Oracle partners. To illustrate the benefits of running on a standardized and optimized Hadoop platform, SAS presents the findings of its tests of SAS In-Memory Analytics on Oracle Big Data Appliance.

Oracle Big Data SQL: Deep Dive (SQL over Relational, NoSQL, and Hadoop) [CON8329]

Tuesday, Sep 30, 3:45 PM - 4:30 PM - Moscone South - 103 

Big data promises big benefits to your organization, but real barriers exist in achieving these benefits. Today’s big data projects face serious challenges in terms of skills, application integration, and security. Oracle Big Data SQL radically reduces these barriers to entry, by providing unified query and management of data in Oracle Database, Hadoop, and beyond. In this session, you’ll learn how Oracle Big Data SQL uses SQL and Smart Scan technologies to make big data feel small. Additionally, you’ll learn how to use your existing skills and tools to get the biggest bang out of big data with Oracle Big Data SQL.

We'll see you soon in San Francisco!

Friday Aug 29, 2014

Oracle Database at Oracle OpenWorld 2014

Oracle OpenWorld is right around the corner and we are so excited to meet with our customers and partners in San Francisco!  We are putting the final touches on the .ppts, getting demos polished and really looking forward to hearing your stories!  

We know it's a HUGE conference so we provide the following guide to ensure you are finding the database sessions and experts that will make your conference a success!

Don't-Miss Keynotes and General Sessions

  • Larry Ellison, CEO, Oracle
    Ellison's keynote address is expected to include Oracle's overall vision and direction as well as exciting new product news.
  • Andy Mendelsohn, Executive Vice President Database Server Technologies, Oracle (GEN7243)
    In his general session titled "What's New from Oracle Database Development?," Mendelsohn provides an overview of major database advancements in the previous 12 months, including Oracle Database In-Memory and Oracle Big Data SQL. He focuses on how these solutions help businesses improve their bottom lines with fast, real-time access to all data sources.
  • Juan Loaiza, Senior Vice President, Oracle (CON7247)
    In his session titled "Oracle Database In-Memory: The Next Big Thing," Loaiza explores Oracle Database In-Memory. He discusses in detail what motivated Oracle to develop this new technology, and provides an explanation of how its unique dual-format architecture works. Loaiza also focuses on how the new in-memory functionality interacts with key database performance features such as Oracle Real Application Clusters, Oracle Partitioning, parallel execution, and much more.
  • Thomas Kyte and Steven Feuerstein, Architects, Oracle (CON9027)
    In this session titled "YesSQL! A Celebration of SQL and PL/SQL," Kyte and Feuerstein celebrate SQL, PL/SQL, and the people who develop and use these technologies. Kyte and Feuerstein are joined by special guests including Andy Mendelsohn, Maria Colgan, and others, who share stories of the impact Oracle technology has had on their lives and work. The bottom line: if developing Oracle Database applications is a big part of your life, this session should prove both fun and interesting.

Oracle Database Focus Area Thought Leaders

Top sessions from our thought-leaders to plan for include the following:

  • Tom Kyte: Developers Rule the World (Again)
Way back in 1992, Oracle Database 7 was the programmer's database with stored procedures, triggers, precompilers, and so on. Then the introduction of the internet shifted the focus to operations, high availability, and related features. Kyte will explore how developers are taking control again and how Oracle Database is responding with new capabilities in the area of JavaScript object notation, new open source drivers, and much more.
  • Steven Feuerstein: The Whys and Wherefores of New PL/SQL Features in Oracle Database 12c
In this session Feuerstein examines a wide array of new features for PL/SQL developers. For example, the function result cache has been enhanced to support functions defined with invoker rights. Administrators can use the ACCESSIBLE BY clause to define whitelists of the program units that can execute subprograms in a package. And administrators can grant roles to PL/SQL program units rather than to schemas, delivering much greater access, control, and flexibility.
  • Maria Colgan: The Top Five Things to Know About Oracle Database In-Memory
This session explains in detail the top five things you need to know to get the most from Oracle Database In-Memory right out of the box. With easy-to-follow real-world examples, Colgan—Oracle's in-memory expert—explains exactly what steps to take to get up and running, and demonstrates the kinds of performance improvements to expect. Colgan always draws a big crowd, so this session is presented twice.
  • Patrick Wheeler: Multitenant: The Beating Heart of Database as a Service
As Wheeler puts it, Oracle Database as a service is built on three strong foundations: Oracle Multitenant as the enabling database architecture, Oracle Enterprise Manager for orchestration, and Oracle's engineered systems, such as Oracle Exadata and Oracle SuperCluster, as consolidation platforms. In this session, Wheeler explores how Oracle provides a total solution that truly delivers on the promise of database as a service.
  • Andrew Holdsworth: What the Real-World Performance Team Learns from Your Automatic Workload Repository Report
Workload Repository feature of Oracle Enterprise Manager 12c have been used for many years to understand the health and characteristics of a database instance. They also reveal many other things you may not have thought of. Like Sherlock Holmes, Holdsworth reveals what other secrets can be deduced.

Oracle Database Focus Areas

These "Focus On" docs summarize the sessions by database technology areas so if you have an interest in security, HA, storage, app dev, etc etc we've tried to collect all the sessions that will be applicable for you. 

Most of all, we encourage you to find us!  This is your conference and we want to hear from you! Be sure to tell us about your stories with Oracle Database. 

Safe Travels and we'll see you in San Francisco soon!

Unable to attend Oracle OpenWorld 2014? We'll miss you but be sure to follow Oracle Database excitement on Twitter and Facebook. And tune in to watch keynote and session highlights on demand.

Stay Connected Oracle Blog Oracle on
                                      Twitter Oracle on
                                      Facebook Oracle on
                                      Youtube Oracle on

Thursday Aug 07, 2014

Oracle Customers Secure Critical Encryption Keys with Oracle Key Vault

Centrally Manage Oracle Database Encryption Master Keys, Oracle Wallets, Java KeyStores and Other Credential Files 

Encryption is widely recognized as the gold standard for protecting data privacy, but encryption is only as strong as its key management. Critical credential files such as Oracle Wallets, Java KeyStores, SSH key files and SSL certificate files are often widely distributed across servers and server clusters with error-prone synchronization and backup mechanisms. As organizations increasingly encrypt data at rest and on the network, securely managing all the encryption keys and credential files in the data center has become a major challenge.

At the same time, organizations also need to comply with stringent regulatory requirements for managing keys and certificates. Many global regulations and industry standards call for audits demonstrating that keys are routinely rotated, properly destroyed, and accessed solely by authorized entities.

To address the need for robust key management, Oracle today introduced Oracle Key Vault, a software appliance designed to securely manage encryption keys and credential files in the enterprise data center. 

Read the press release and register for the August 21 webcast to learn how Oracle Key Vault
  • Centralizes Keys in a modern, secure, and robust key management platform
  • Secures, shares, and manages keys and secrets for the enterprise
  • Manages key lifecycle stages including creation, rotation, and expiration
Learn more: Oracle Key Vault enables customers to quickly deploy encryption and other security solutions. 



  • Oracle
« April 2015