- Compression Advisor estimates compression ratio possible with Oracle Advanced Compression
- Business Opportunities with Oracle In-Database Analytics
- How do you manage data growth in your Oracle Environment?
- April Edition - Oracle Database Insider Newsletter
- Now Headlining in Vegas - COLLABORATE 14!
- Oracle NoSQL Database 3.0 Announced - Extends Security, Usability, and Performance.
- How to migrate from Microft SQL Server to an Oracle Database 12c centralized environment with ODP.NET
- Need best practices for deploying JD Edwards EnterpriseOne on Oracle Database Appliance?
- Oracle's Real-World Performance Tour - now comes to you!
- Tom Kyte writes about Oracle Database 12c Multitenant Option in Oracle Magazine
Monday Dec 02, 2013
Friday Nov 15, 2013
Amerisource Bergen realizes a 60% reduction of their storage footprint in SAP environment with Oracle Advanced Compression
By margaret hamburger on Nov 15, 2013
Tuesday Nov 12, 2013
By margaret hamburger on Nov 12, 2013
Another great example of how Oracle Database Appliance simplifies the deployment of high availability database solutions making it easy for Oracle Partners and ISVs to deliver value added solutions to customers on a simple, reliable and affordable database platform.
Oracle FLEXCUBE Universal Banking recently announced that it runs on Oracle Database Appliance X3-2 to deliver mid-size banks a compelling banking-in-a-box solution. With this certification, banks can benefit from a low-IT-footprint, high-performance, full-scale banking technology that is engineered to support end-to-end business requirements.
In a recent performance test of Oracle FLEXCUBE Universal Banking on Oracle Database Appliance X3-2, the system managed more than 2.6 million online transactions in 60 minutes. This equated to roughly 744 transactions per second with an average response time of 156 milliseconds for 98 percent of the transactions. Likewise, the solution completed end-of-month batch processing for 10 million customer accounts in 123 minutes during the performance test.
Learn more about Oracle Database Appliance Solution-in-a-Box.
Monday Nov 04, 2013
By Markus Weber on Nov 04, 2013
Whether you use, or are interested in using, Oracle GoldenGate for
- real-time data integration
- database upgrades or migrations, or
- heterogeneous database replication
the recently launched GoldenGate 12c release will certainly proof very interesting for you.
To learn more about it, make sure to attend the upcoming webcast:
In addition, there are several great blog entries over at the Oracle Data Integration blog:
Tuesday Oct 22, 2013
By David Swanger on Oct 22, 2013
On Monday, October 21st we hosted an online forum that shared a comprehensive path to help your organization design, deploy, and deliver a Database as a Service cloud.
We received numerous questions. Below are highlights of the most informative:
DBaaS requires a lengthy and careful design efforts. What is the minimum requirements of setting up a scaled-down environment and test it out?
You should have an OEM 12c environment for DBaaS administration and then a target database deployment platform that has the key characteristics of what your production environment will look like. This could be a single server or it could be a small pool of hosts if your production DBaaS will be larger and you want to test a more robust / real world configuration with Zones and Pools or DR capabilities for example.
How does this benefit companies having their own data center?
This allows companies to transform their internal IT to a service delivery model for the database. The benefits to the company are significant cost savings, improved business agility and reduced risk. The benefits to the consumers (internal) of services if much fast provisioning, and response to change in business requirements.
From a deployment perspective, is DBaaS's job solely DBA's job?
The best deployment model enables the DBA (or end-user) to control the entire process. All resources required to deploy the service are pre-provisioned, and there are no external dependencies (on network, storage, sysadmins teams). The service is created either via a self-service portal or by the DBA.
The purpose of self service seems to be that the end user does not rely on the DBA. I just need to give him a template. He decides how much AMM he needs. Why shall I set it one by one. That doesn't seem to be the purpose of self service.
Most customers we have worked with define a standardized service catalog, with a few (2 to 5) different classes of service. For each of these classes, there is a pre-defined deployment template, and the user has the ability to select from some pre-defined service sizes. The administrator only has to create this catalog once. Each user then simply selects from the options offered in the catalog.
Looking at DBaaS service definition, it seems to be no different from a service definition provided by a well defined DBA team. Why do you attribute it to DBaaS?
There are a couple of perspectives. First, some organizations might already be operating with a high level of standardization and a higher level of maturity from an ITIL or Service Management perspective. Their journey to DBaaS could be shorter and their Service Definition will evolve less but they still might need to add capabilities such as Self Service and Metering/Chargeback. Other organizations are still operating in highly siloed environments with little automation and their formal Service Definition (if they have one) will be a lot less mature today. Therefore their future state DBaaS will look a lot different from their current state, as will their Service Definition.
How database as a service impact or help with "Click to Compute" or deploying "Database in cloud infrastructure"
DBaaS enables Click to Compute. Oracle DBaaS can be implemented using three architecture models: Oracle Multitenant 12c, native consolidation using Oracle Database and consolidation using virtualization in infrastructure cloud. As Deploy session showed, you get higher consolidating density and efficiency using Multitenant and higher isolation using infrastructure cloud. Depending upon your business needs, DBaaS can be implemented using any of these models.
How exactly is the DBaaS different from the traditional db? Storage/OS/DB all together to 'transparently' provide service to applications? Will there be across-databases access by application/user.
Some key differences are: 1) The services run on a shared platform. 2) The services can be rapidly provisioned (< 15 minutes). 3) The services are dynamic and can be relocated, grown, shrunk as needed to meet business needs without disruption and rapidly. 4) The user is able to provision the services directly from a standardized service catalog..
With 24x7x365 databases its difficult to find off peak hrs to do basic admin tasks such as gathering stats, running backups, batch jobs. How does pluggable database handle this and different needs/patching downtime of apps databases might be serving?
You can gather stats in Oracle Multitenant the same way you had been in regular databases. Regarding patching/upgrading, Oracle Multitenant makes patch/upgrade very efficient in that you can pre-provision a new version/patched multitenant db in a different ORACLE_HOME and then unplug a PDB from its CDB and plug it into the newer/patched CDB in seconds.
Thanks for all the great questions! If you'd like to learn more and missed the online forum, you can watch it on demand here.
Tuesday Oct 01, 2013
Wellcome Trust Sanger Institute describes how Oracle Database 12c features ease managability of multi-terabyte database systems
By margaret hamburger on Oct 01, 2013
I had the pleasure of speaking with Karen Ambrose, Principle Database Administrator of
Wellcome Trust Sanger Institute last week at Oracle Open World. She described for me how the Institute's green initiative and data growth
predictions have them researching ways to automate their data
archiving processes. Listen to the interview and learn how Oracle Database 12c Storage Optimization
features with Heat Map and Automatic Data Optimization ease the manageability of multi-terabyte database systems,
enhance storage usability, and reduce the time and effort spent
Friday Sep 20, 2013
Thursday Sep 19, 2013
By margaret hamburger on Sep 19, 2013
In the health care industry, speed and efficiency are critical to reducing costs, conserving limited resources and improving patient outcomes. Strata Health Solutions plays a key role in the health care ecosystem with its SaaS resource matching and referral technology to optimize patient flow and experience. Oracle Database Appliance and Oracle Real Application Clusters allow Strata Health to create a high availability database cluster infrastructure that seamlessly manages their growing volume of health care providers that rely on its system.
Listen to Darren Jones, chief operating officer at Strata Health Solutions describe how Oracle
Database Appliance helped them improve the
performance and speed of their SaaS Patient Flow Technology to improve medical facility efficiency and patient
Tuesday Sep 17, 2013
Oracle Database Appliance provides high availability and performance required for public transportation system
By margaret hamburger on Sep 17, 2013
Transports publics fribourgeois (tpf) in Fribourg Switzerland ensures reliable public transportation services with Oracle Database Appliance. In 2012, the organization transported almost 28 million passengers by road and rail. They wanted to ensure high availability of their database applications for route
planning, vehicle management, and staff allocation, to enable efficient
and cost-effective public transportation.
Oracle Database Appliance provided the high availability and performance
required for their public transportation system which allowed them to scale
easily to meet their changing business requirements and limit their total
cost of ownership. To learn why they chose Oracle and more details about their deployment of Oracle Database Appliance with Oracle Real Application Clusters and Oracle Active Data Guard read the complete story.
By margaret hamburger on Sep 17, 2013
Everything you want to know about Oracle TimesTen In-Memory Database can be found at OOW13. Listen to Merrill Lynch, Rittman Mead Consulting and Intel Corporation share their real life stories and extreme performance with Oracle TimesTen In-Memory Database. Sign up for the Hands-on-Lab to learn how to accelerate performance with Oracle TimesTen In-Memory Database or Join a Birds of a Feather session and join Peak Indicators and Rittman Mead Consulting as they describe Oracle TimesTen best practices and finally stop by to see live demonstrations that include extreme analytics with Exalytics and Oracle TimesTen In-Memory Database.
Oracle TimesTen In-Memory Database is a memory-optimized relational database that provides real-time data management for performance critical systems deployed in the application tier to deliver blazing-fast response and real-time caching of application data from an Oracle Database to an Oracle TimesTen database.
By margaret hamburger on Sep 17, 2013
Oracle Database 12c Storage Management sessions at this year's Oracle Open World promise to deliver the mother-load of cost savings and performance benefits to your companies bottom line. See for yourself how Oracle Advanced Compression automates both compression and storage tiering with Heat Map and Automatic Storage Optimization features that simplify administration, reduce storage costs and improve performance. You'll meet real customers like Thomson Reuter Corporation, AmerisourceBergen and the Welcome Trust Sanger Institute as they describe their storage optimization best practices. Oracle product experts will be on-hand to answer your specific questions. Don't miss the opportunity to make OOW13 your companies best investment of the year with a focus on Oracle Database 12c Storage Management.
Friday Sep 13, 2013
By margaret hamburger on Sep 13, 2013
Read how IOUG members approach database storage management in the 2013 Database Growth Survey: Achieving Database Performance and you'll understand why Oracle Database 12c Storage Optimization features like Heat Map and Automatic Data Optimization in Oracle Advanced Compression help reduce costs and improve performance while providing a smarter approach to data management and information lifecycle management.
Thursday Aug 22, 2013
By margaret hamburger on Aug 22, 2013
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.
Wednesday Aug 14, 2013
By margaret hamburger on Aug 14, 2013
Oracle TimesTen In-Memory Database release 220.127.116.11 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 18.104.22.168 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 22.214.171.124 Quick Start Guide also added many new Best Practices for Oracle TimesTen database and OS settings, Replication, Caching from the Oracle Database, and Monitoring.
Oracle TimesTen 126.96.36.199 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
By margaret hamburger on Aug 07, 2013
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.