Thursday Aug 29, 2013

Learn From The IOUG at Oracle OpenWorld 2013

As in previous years, Oracle OpenWorld attendees will have the opportunity to not only learn from Oracle product experts and partners, but also directly from customers and actual users of Oracle technology.

For Oracle Database and related technologies, a great venue to do this is the User Group Forums on Sunday, Sept. 22, and very specifically anything organized by the IOUG (Independent Oracle Users Group). Check here for more info.

In addition to those sessions, the IOUG will also have a pavilion, and will organize plenty of other fun activities. More info on IOUG's site.

To talk about this and more, I recently had the pleasure to host IOUG President, and
Oracle ACE Director, Michelle Malcher and we recorded this podcast.

Wednesday Aug 28, 2013

ESG Product Brief: Introducing Oracle Database 12c: Managing Many Database as One

Enterprise Strategy Group (ESG) took a look under the covers of Oracle Database 12c and talked with customers James Lui of Aramark and Jens-Christian Pokolm at Postbank.

Oracle’s dramatic re-architecture of its latest enterprise relational database, Oracle Database 12c, offers database customers a long list of real improvements to support cloud implementations, enable the consolidation and management of many databases as one, and streamline the day-to-day work of database administrators .

Between engineered systems and now Oracle Database 12c, Oracle has once again stretched the leadership lifespan of the Oracle database.

 Read the full Product Brief:   Introducing Oracle Database 12c: Managing Many Database as One

Tuesday Aug 27, 2013

APEXposed: ODTUG returns to the Centre Mont Royal for 2 Days in Sept!

Mark your calendars for September 10-11 when ODTUG returns to the Centre Mont Royal for two days packed full of APEX sessions.

Join speakers like Oracle ACE Directors Martin D’Souza, Roel Hartman, Steven Feuerstein and Oracle leaders like Joel Kallman and David Peake to learn from the best of the best. Sessions will be targeted towards a wide range of skill sets from introductory to expert level APEX developers.

Use the code INSIDER to save $50 on registration.

Thursday Aug 22, 2013

Focus on Oracle Database Appliance at Oracle Open World

Focus on Oracle Database Appliance every day at Oracle Open World and see for yourself how simple, reliable and affordable it is to create a virtual platform for both your application and Oracle Database in a single box.

Tuesday Aug 20, 2013

Your Next Big Cloud Opportunity: Database as a Service

Database as a Service helps enterprise IT deliver better services faster and at a lower cost.

Check out this Forbes article to learn more!

Thursday Aug 15, 2013

Oracle Monthly Webcast Series: Plug into Oracle Database 12c

Register For the Webcasts in our Oracle Database 12c Monthly Series

Oracle Database 12c has arrived and with it comes the opportunity to plug into the cloud with a multitenant architecture that lowers cost, increases agility, and minimizes risk. With Oracle Database 12c you can consolidate and compress databases at a higher density than ever before. During this monthly webcast series learn how Oracle Database 12c can help your organization save time and money through:

  • Simplifying database consolidation
  • Redacting sensitive data
  • Improving application continuity
  • Automatically compressing and tiering data
Register today!  The series includes:
  • August 28: Plug into Cloud Consolidation with Oracle Database 12c
  • September 10: Plug into Storage Optimization with Oracle Database 12c
  • October 17: Plug into Maximum Availability with Oracle Database 12c
  • November 13: Plug into Defense-in-Depth with Oracle Database 12c

Wednesday Aug 14, 2013

Oracle TimesTen Software Update Release Availability

Oracle TimesTen In-Memory Database release is available for download. This release provides new capabilities that further improve performance and scalability for applications with extremely fast response time and very high throughput requirements, specifically for Online Transaction Processing (OLTP) workloads and Business Intelligence (BI) in-memory analytics workloads for Oracle Exalytics In-Memory Machine.

Feature highlights for Business Intelligence In-Memory Analytics workloads:

Performance and Scalability for In-Memory Analytics

The SQL Optimizer for in-memory analytics added a number of optimizations targeted for common star-join query patterns. These enhancements resulted in the optimizer choosing better query plans and speeding up overall query response time:

  • Enables up to 3-10x query response time improvements for BI workloads and selected Oracle BI Applications;
  • Enhanced in-memory query processing for star schemas
  • Full Hash Index support. Prior to this release, hash indexes were supported only for primary key columns. Hash indexes may now be created on any set of columns to help speed up complex queries with equi-joins;
  • Improved Index Advisor recommendations provide optimal indexes based on a specific query set.

Improvements to reduce data loading time

Data loading has been enhanced with the ability to support parallel, concurrent writes into a large compressed table. This feature significantly reduces the overall data loading time from the Data Warehouse to the Oracle TimesTen database in the Oracle Exalytics machine.

  • Enables up to 3x reduction in data loading time for compressed tables;
  • Improved data loading from the Oracle Database to TimesTen using the (ttLoadFromOracle) built-in function, with added support for parallel inserts to compressed tables;
  • New utility (ttImportFromOracle) to analyze the data from an Oracle Database; the utility generates DDLs for tables and indexes with optimal Oracle TimesTen native data types and recommendation for columnar compression.

Feature highlights for Online Transaction Processing (OLTP) applications:

Optimistic Concurrent B+ Tree index for write scalability

A new B+Tree indexing capability featuring optimistic concurrency control provides increased scalability for write-intensive applications. This B+Tree index feature provides better throughput with higher numbers of concurrent writers, and is ideal for applications with very high volumes of insert and update transactions running in modern computing architectures with many processing cores.

  • Greater concurrency support and higher transaction throughput for write intensive applications
  • Enables up to 5x throughput improvement compared to existing B-tree indexes

Full Hash Index support for read scalability

The Hash index is a unique feature in Oracle TimesTen. A Hash index offers better performance for equality look up of Primary Key and is commonly used by OLTP application running on Oracle TimesTen databases. This release added the ability to create hash indexes on all columns in the table.

  • Hash indexes can now be created for any single column and multiple-column indexes
  • Enables up to 7x throughput improvement for read-intensive applications

Improved Scalability for NUMA systems

Modern computers are designed with high number of cores per server with large quantity of DRAM available. Such systems commonly exhibit Non Uniform Memory Access (NUMA) variations in memory latency, for example, when accessing memory outside of the local processor (socket). TimesTen as an in-memory database runs at memory (DRAM) speed and is more sensitive to the NUMA effect than a conventional disk-based relational database, where data access is optimized at the disk storage level. Improving TimesTen scalability on NUMA systems is an on-going effort in every release. A number of NUMA locality enhancements and code path optimizations were added in the release, resulting in improved read and write scaling, especially on systems with very high number of processor cores such as the Oracle T5-8 servers, which have 128 cores and 1024 processing threads per server.

  • 59.9 Million reads per second on Oracle T5-8 machine
  • 1.03 Million update transactions per second on Oracle T5-8 machine

New Manageability Capabilities

New in this release is a utility for real-time monitoring and capturing snapshots of monitored metrics. This utility, ttStats, provides HTML reports of TimesTen database performance (similar to the Automatic Workload Repository (AWR) facility for the Oracle Database.) Also included in this new monitoring facility is a set of PL/SQL procedures for custom development. ttStats is a standalone TimesTen utility, invoked at the command line, and requires no additional software. ttStats can be used for real-time monitoring, snapshots captures, and HTML reports.

In addition to database level performance, the ability to time individual SQL statements is available in this release allowing the administrator to quickly identify long running operations.

Oracle TimesTen Quick Start Guide

A user-friendly, self-guided HTML Guide is available to get started with Oracle TimesTen. The Quick Start Guide uses the “How to” approach to provide easy to follow instructions for all components of the product, from database configurations, setups, to programming APIs, to configuring replication and cache grid, the instructions are provided step by step with screen shots and explanations for new and existing TimesTen users. The Quick Start Guide also added many new Best Practices for Oracle TimesTen database and OS settings, Replication, Caching from the Oracle Database, and Monitoring.

Download Oracle TimesTen now!

Oracle TimesTen release supports the following licensed products in the TimesTen product family: Oracle TimesTen In-Memory Database; Oracle TimesTen In-Memory Database for Exalytics; Oracle In-Memory Database Cache; and In-Memory Database Cache for Oracle Applications.

Wednesday Aug 07, 2013

MediSwitch makes the switch to Oracle Database Appliance

MediSwitch chose Oracle Database Appliance over competing solutions to replace a legacy database system of hardware and software from many different providers.  Recently, I had the pleasure of interviewing Wayne Botha, IT Manager of MediSwitch as he discussed their experience with Oracle Database Appliance.  Not only did they complete a complex migration using Oracle GoldenGate to facilitate a near zero downtime migration in a very short period of time they upgraded their database to Oracle Database 11g. Listen as Wayne describes how simple Oracle Database Appliance was to install and deploy and how the capacity-on-demand licensing played a key factor in their decision to purchase. Best of all they were able to consolidate all of their development testing and pre-production databases and can now use a single resource to patch everything in one go over their legacy system. Their big surprise was the significant performance benefit running reports that use to take 4 hours and now only take 45 minutes. If you are considering Oracle Database Appliance, you won't want to miss this podcast.

QuinnSite Report: Oracle Revolutionizes its Flagship Database for Multitenant Clouds

QuinnSite Research published its Technology Innovator Product Snapshot for Oracle Database 12c summarizing that Oracle Revolutionizes its Flagship Database for Multitenant Clouds

The Snapshot further says that Oracle Database 12c:

  • includes considerable innovation from largest thrust of R&D for Oracle’s flagship database
  • will help DBAs simplify their databases consolidation initiatives, while increasing hardware-related cost savings
  • sends competitors, old and new, back to the drawing board to find alternative angles to try to unseat Oracle
  • places Oracle firmly in the enterprise "database-as-a-service" market
  • provides rapid and simple provisioning and cloning of databases and containers to considerably reduce the length of development and test projects; resulting in faster time to market for external applications
  • allows for the tiering of database instances plugged into a container, meaning the DBA may develop database templates for different private cloud application classes for fast provisioning



  • Oracle
« August 2013 »