In the previous instalment of this series I introduced three ways of accessing the run-time statistics for a query and described, for one of the methods, the basics of the information we can get and how we can use it. In this article I want to expand on the use of one method to show it can help use identify… Continue Reading →

All Things Oracle Full Articles, Database Administration, Database Development

Friday January 23, 2015, 10:00 AM – 11:00 AM CST Register Featured Presenter: Martin Bach Fill the Glass Host: Cary Millsap Description: In Fill the Glass episode 2, Cary welcomes Enkitec engineered system specialist Martin Bach. In this action-packed hour, Martin will guide us on a tour of the magnificent collection of Oracle Exadata internal technologies commonly called Smart Scan…. Continue Reading →

Database Administration, Webinar

Wednesday January 28, 2015, 3:00 PM – 4:00 PM GMT Register Description: After a short introduction into what the Oracle Exadata Database Machine is, in this one-hour webinar Oracle expert Randolf Geist will look at an analysis of different database query profiles that are based on a real-world customer case, how these different profiles influence the efficiency of Exadata’s “secret sauce”… Continue Reading →

Database Administration, 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

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