Wednesday, July 06, 2005

Back at work

Well, after 2 months off from work, I'm finally back at work and it has not been easy trying to get back into routine and catching up on what has happened during the time I was off.

Unfortunately, not much progress has been made. Our Data Warehouse upgrade from Oracle 8 to 9i has limped along. There are several problems that I am awared of which is causing some issues. These are not new issues in the world of Oracle but are new to the organization (limited hands-on Oracle 9i experience). The kicker seems to be slow performance of creating bitmap indexes on the large dimension tables (partitioned) which could take up to four times longer than when it ran under Oracle 8.1.7. Other issues included lost connections with sessions without reason. Will need sometime to do up some test scripts to see what is happening under the hood.

No comments: