| Performance regression from 8i to 10G [message #445011] |
Thu, 25 February 2010 03:55  |
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?
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
