Path: news.f.de.plusline.net!news-fra1.dfn.de!newsfeed.hanau.net!news.tiscali.de!tiscali!newsfeed1.ip.tiscali.net!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!q40g2000cwq.googlegroups.com!not-for-mail
From: DBdude_From_NY@yahoo.com
Newsgroups: comp.databases.oracle.server
Subject: Query Slow in 10g, runs very fast in 8i
Date: 4 Jan 2007 16:44:46 -0800
Organization: http://groups.google.com
Lines: 12
Message-ID: <1167957886.638614.123220@q40g2000cwq.googlegroups.com>
NNTP-Posting-Host: 67.83.68.65
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1167957890 7736 127.0.0.1 (5 Jan 2007 00:44:50 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 5 Jan 2007 00:44:50 +0000 (UTC)
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: q40g2000cwq.googlegroups.com; posting-host=67.83.68.65;
   posting-account=ykAVuA0AAABjDl6CS_fVwe6v5PR_5RZQ
Xref: news.f.de.plusline.net comp.databases.oracle.server:191761

We have a 8i DB on VMS-VAX machine. We copied the DB to Unix on Oracle
10g. Unix machine is more powerful then VMS and its 10g. A SP which was
taking less then 10 minutes on 8i is taking close to 11 hours (Yes,
Hours) on Unix, 10g. From where should I start looking in order to make
it faster.
On Oracle 8i statistics was not being gathered and on 10 g we are
gathering stats.
BTW, the SP is written real bad, but it was finishing its job in less
then 10 minutes and that also with 3 times more data because we have
not migrated entire data. We do have migrated all tables, indexes, SPs
etc.