New Year’s Resolutions II

At work, I am resolved to push through the upgrade from Oracle 8.1.7 to 10.2.x

The client currently has a live 8.1.7 instance on some pretty old hardware that uses Shareplex to replicate to a standby.

Any planned upgrade is going to have some teething problems and I’m sure every installation and every upgrade is unique.

I am encouraged by one case study experience of Database Specialists whilst being wary of some of the problems that others (can’t find the relevant articles at the moment) have experienced.

In terms of application SQL performance, I think that the key to the initial migration is going to be the use of Stored Outlines to preserve the current perceived dodgy optimizer stability. Once the upgrade has been implemented and is stable, then I think we can start to optimise the SQL and, for example,remove some of the push_subq hints from queries that have no subqueries….

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 72 other followers

%d bloggers like this: