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

David Njoku on 16 May 2012 with 0 comments

Imagine, if you will, that someone invented time travel. What would you do with it? Nip back into the past and fix that error you made? And maybe you’d want to do something about that silly, ill-advised haircut you had when you were 17. Well, the good news is that, in a manner of speaking, time travel has been invented…. Continue Reading →

Free eBook: Expert Oracle Database Architecture

All Things Oracle on 23 April 2012 with 0 comments

Download your FREE eBook Expert Oracle Database Architecture (Apress Media) provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world’s foremost Oracle experts, Thomas Kyte. This fully revised second edition covers the developments up to Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only… Continue Reading →

Migrating Oracle Single Instance to RAC

Syed Jaffer Hussain on 17 April 2012 with 0 comments

This video is a recording from the webinar broadcast by Red Gate on 29th March 2012. Oracle Database administrators have to cope with numerous challenges when migrating an existing non-cluster environment to a cluster environment. One of the most significant challenges a DBA faces is to migrate/convert an existing single instance to RAC. Oracle provides several easy methods to carry… Continue Reading →

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

Dominic Delmolino on 27 March 2012 with 0 comments

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: ORA-01801: date format is too long for internal buffer somewhere near a line in which I was doing the following assignment: d := to_char(c.date_field,’YYYYMMDD’); Where d is of type varchar2, and c is a row from a cursor for loop,… Continue Reading →

Method for Huge Diagnostic Information in Exadata

Fahd Mirza on 23 March 2012 with 0 comments

During the management of the Exadata, we have seen numerous incidents ranging from the eviction of the nodes to the hanging cluster and from cooked controllers to bad hard disks. On all the occasions we have been engaged with the My Oracle Support to identify the root cause, which more often than not results in either a known bug or… Continue Reading →

The 40 Most Common Oracle Errors

David Njoku on 12 March 2012 with 12 comments

I have been in this industry long enough to remember the bad old days, when every developer and DBA had a pile of dusty Oracle user guides on their desks and, every time their database or application coughed up an error, would thumb through the books with mounting desperation. Fortunately, the times have moved on and we now all outsource… Continue Reading →

DBA Monitoring Top Five

Michelle Malcher on 19 January 2012 with 4 comments

Have you ever just sat there watching all of the processes running against the database, just waiting for something to happen? Of course not! We are database administrators, architects, developers and we don’t have time for that! We also might get bored wondering why there seems to be millions of the same query running against the database – a discussion… Continue Reading →

SQL Developer Data Modeler Quick Tip: Use SubViews

Jeff Smith on 16 November 2011 with 0 comments

Modeling is cute when you’re in a class and the sample application is for a rotisserie league for fantasy football, or you need a shopping cart ordering system for online retail. You spend a few hours and might come up with several dozen tables. But what about in the real world when you are trying to wrap your head around… Continue Reading →

Which of these things is not like the other?

Jim Tilson on 11 November 2011 with 1 comments

Have you ever played the game where you try to identify the differences between two side-by-side seemingly-identical pictures? Sometimes answering the question “why does my query perform well in development, but it drags in test and production” is the same sort of game: you must identify where your environments differ, either obviously and subtly, then weigh those differences to determine… Continue Reading →

What’s new in Oracle APEX 4.1? – from the inside

Peter Raganitsch on 02 November 2011 with 0 comments

We all read the blog postings about what features were added in Oracle APEX 4.1, like the ones here, here, here and here. But what does that mean on a more technical level? Which Views have changed, which API’s have changed? Inspired by the webinar over here I thought I’d give the Red Gate Schema Compare Tool a try. The… Continue Reading →