Home » RDBMS Server » Performance Tuning » Performance regression from 8i to 10G (Oracle 10G)
Performance regression from 8i to 10G [message #445011] Thu, 25 February 2010 03:55 Go to next message
Irena
Messages: 3
Registered: May 2001
Junior Member
We have a module that contains C and ProC code and compiled with Oracle 8i; it runs against the database using versions Oracle 8i and Oracle 10G (10.2.0.4) on Linux 5.3.

The initial conditions ( tables, indexes, data) and server machine are the same. In our test case, the module checks/inserts 45000 units of data (a lot of SELECT and INSERT statements).

The problem is :
1. Oracle 8i - the elapsed time is about 1 hour
2. Oracle 10G - the elapsed time is more than 4 hours.

What may be cause of this difference in performance?
Re: Performance regression from 8i to 10G [message #445021 is a reply to message #445011] Thu, 25 February 2010 04:47 Go to previous messageGo to next message
cookiemonster
Messages: 12320
Registered: September 2008
Location: Rainy Manchester
Senior Member
Trace both sessions and compare the tkprof results.
Re: Performance regression from 8i to 10G [message #445354 is a reply to message #445011] Mon, 01 March 2010 01:53 Go to previous message
michael_bialik
Messages: 611
Registered: July 2006
Senior Member
Did you run DBMS_STATS in 10g?
Previous Topic: Restructering
Next Topic: question about stats
Goto Forum:
  


Current Time: Thu Sep 29 00:30:12 CDT 2016

Total time taken to generate the page: 0.08095 seconds