So far in this series we’ve talked about interpreting the shape of an execution plan and understanding the meaning of the predictions that the optimizer has made about cost and cardinality. It’s finally time to see how Oracle gives us execution plans that show us how well the optimizer’s estimates match the actual work done as the query ran. There… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development, PL/SQL

Oracle Database 12c has new enhancements and additions to 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 the Oracle community. See new features covered in Part 1 – Oracle Database… Continue Reading →

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

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