Friday December 5th, 2014, 10:00 AM – 11:00 AM CST Register Description: It’s usually not difficult to find SQL that is performing poorly. The hard part is what to do with a bad SQL statement once you have it. In this session, Karen Morton will show you how to use a simple method that is reliable and repeatable for solving any problem… Continue Reading →

Performance Tuning, Webinar

The Oracle GoldenGate software package delivers low-impact, real-time data integration and transactional data replication across heterogeneous systems for continuous availability, zero-downtime migration, and business intelligence. Oracle GoldenGate 12c empowers organizations to capture, route, transform, and deliver transactional data between heterogeneous databases in real time with minimal overhead.  In 12c, it is now available with new features for all major operating… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Database Development, Oracle Cloud, Oracle Database

Sometimes the best way to see the familiar is to go far from it – Wisdom of the desert In previous articles (collections I and collections II) I described the different types of collections, their possibilities and their limits. One of the limits was the possibility to use an Associative Array in a SQL statement. If you are building your… Continue Reading →

12c, All Things Oracle Full Articles, Database Development, Oracle Database, PL/SQL

At its most basic level, Oracle databases are built around data based within tables held within the database, and the moulding of that data into information and meaning. Under this model, data is created within the database or imported into it. There is, however, a third way. Using external tables, Oracle can query the contents of flat files held outside… Continue Reading →

All Things Oracle Full Articles, Oracle Database

Designing an index is not done through “trial and error”. This kind of strategy seems to doom many engineered indexes to imprecision, explosion, and locking issues. Designing a precise index very often tends to be a “kill two birds with one stone” strategy.  In this article I am going to show you how to design a single index with which… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

Oracle Database 12c has new enhancements and additions in Recovery Manager (RMAN).  The Recovery Manager continues to enhance and extend the reliability, efficiency, and availability of Oracle Database Backup and Recovery. In this article series, I will be explaining the new features and how it will help Oracle community. In this article I will cover: SQL Interface Improvements SYSBACKUP Privilege… Continue Reading →

12c, All Things Oracle Full Articles, Database Administration, Oracle Database

Security is in the news again.  It seems there’s no greater click-bait than a story about indecent photos of beautiful young Hollywood actresses stolen from their iPhones. Find a way to rope a cute kitten into the story and the Internet might very well explode. The current theories abounding seem to suggest that the vulnerabilities lay not with Apple, but… Continue Reading →

All Things Oracle Full Articles, Database Administration

Watch now About the Oracle Database In-Memory in Action Webinar Join three of the brightest minds in the industry, Cary Millsap, Kerry Osborne and Tanel Poder, for a one-hour free webinar as they discuss the revolutionary technology of Oracle Database In-Memory, an in-memory column store that does not slow down the OLTP components and is compatible with all existing applications. This option enables real-time queries that… Continue Reading →

Webinar

In part 9 we saw an example of a simple nested loop join where the basic method for interpreting the numbers in an execution plan started to break down because the arithmetic used by the optimizer to calculate the resource costs for the plan wasn’t consistent with the visual representation of the mechanics of the run-time path. In this instalment we’re… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

In part 8 we looked at a very simple execution plan involving a hash join; but that example was too simple to give us the full flavour of the arithmetic involved in Oracle’s predictions because every operation executed just once. We need to see some plans where each execution of a parent operation could requires multiple executions of its child… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development