Randolf Geist

Dynamic Sampling (III) – Real-Life Data – Part I

In the previous parts of the series I outlined the basics on Dynamic Sampling. Let’s see how Dynamic Sampling deals...

20 June 2012 9 min read

Dominic Delmolino

Pascal matrix SQL puzzle solution

I’ve been impressed with the solutions to my little problem of generating a symmetric Pascal matrix using SQL. Charles Hooper in particular has provided...

19 June 2012 1 min read

Randolf Geist

Nested Loop Join Costing

The basic formula for calculating the costs of a Nested Loop Join is pretty straightforward and has been described and...

14 June 2012 2 min read

Martin Giffy DSouza

SELECT INTO Techinques

One thing that bothers a lot of PL/SQL developers is when they have to select some data from a table...

13 June 2012 1 min read

David Njoku

Introduction to Oracle Flashback Technology (Part 3: Flashback Database)

In this series of articles, we are discussing the collection of tools that make up the Oracle Flashback Technology suite....

12 June 2012 6 min read

Cary Millsap

An Organizational Constraint that Diminishes Software Quality

One of the biggest problems in software performance today occurs when the people who write software are different from the...

11 June 2012 1 min read

David Njoku

Introduction to Oracle Flashback Technology (Part 2: Database Administrators)

In the first in this series of articles on the tools in the Oracle Flashback Technology armoury, I discussed what...

31 May 2012 6 min read

Jonathan Lewis

Ch-ch-ch-ch-changes

For those not familiar with Richard Foote’s extensive blog about indexes (and if you’re not you should be) – the title of...

29 May 2012 2 min read

David Njoku

Introduction to Oracle Flashback Technology (Part 1: Application Developers)

Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past...

16 May 2012 7 min read

Wissem El Khlifi

Auto Restart Enterprise Manager Cloud Control Agent 12c

Introduction: Oracle Restart is a component added to the 11gR2 in order to improve the high availability of different database...

10 May 2012 1 min read

Jonathan Lewis

Oracle Heap Tables or SQL Server Clustered Indexes? Jonathan Lewis and Grant Fritchey Live Debate

The following video and set of resources are from the webinar broadcast by Red Gate on 7 June 2012. Oracle...

30 April 2012 1 min read

Karen Morton

How to Gather SQL Resource Consumption Metrics in Oracle

The following video and set of resources are from the webinar broadcast by Red Gate on 8 May 2012. The...

26 April 2012 2 min read

Cary Millsap

Real Developers DO use Tools

This video is a recording from the webinar broadcast by Red Gate on 24th January 2012. You may’ve heard the...

19 April 2012 1 min read

Aman Sharma

An Introduction to 11.2 RAC Server Pools

Oracle RAC is designed to cater for Oracle specific applications and also non-oracle applications. These applications, both Oracle and non-Oracle,...

18 April 2012 19 min read

Syed Jaffar Hussain

Migrating Oracle Single Instance to RAC

This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have...

17 April 2012 1 min read

Randolf Geist

Oracle Cost-Based Optimizer Basics

This video and set of resources is a follow up to the webinar broadcast by Red Gate on 11 Apr...

10 April 2012 2 min read

Martin Giffy DSouza

Building Apex Plugins 101

Martin Giffy D’Souza has created some of the most popular plug-ins available on the APEX plug-in community page. He has...

28 March 2012 1 min read

Dominic Delmolino

ORA-01801: Date Format is too Long for Internal Buffer

Oracle 10.2.0.1 (I know, version out-of-date) on Windows 2003: The other day one of my stored procedures error’ed out with:...

27 March 2012 1 min read

Martin Giffy DSouza

How APEX Processes Various Conditions and Validations

I was recently teaching an Intro to APEX course and the students had some questions about what to put in...

26 March 2012 1 min read

David Njoku

The 40 Most Common Oracle Errors

I have been in this industry long enough to remember the bad old days, when every developer and DBA had...

12 March 2012 6 min read