Report running is way slow on a new database

From: LittleDBA <mlei_at_txi.com>
Date: 9 Nov 2002 11:59:22 -0800
Message-ID: <b6ba5bb.0211091159.5f9798e0@posting.google.com>

Most recently i moved our production database (8.1.6.1.0) to a newly purchased sun solaris box (sun fire 280) and upgrade the database to 8.1.7.2.0.

Developer reported that a report is running very slow. It is through a cobol application called CYBORG. From what he said the old box and new box setting and configuration is the same.

i ran statspack and turn on sql trace and found out even both optimizers pick up the same path and utilize indexes. However the new database trace file is huge (500MB).

Any help is very much appreciated.

Regards,
LittleDBA Received on Sat Nov 09 2002 - 13:59:22 CST