Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Full scan perf. problem after mig Oracle 7.3.4/8.0.5
Hi,
The database work under NT4. Before I migrate it I have meseared the time
for full scan (count(*)) on 2 big tables. With 7.3.4 database the time was
58 secondes for table 1, 22 secondes for table2. After migrate with mig80,
the time is 137 secondes for table1 and 54 secondes for table2. More than
two times slower.
An insert stored procedure (a loop on an insert statement) is two time
slower with Oracle 8 (2300 record/secons .
Anybody have an idea ? Any idea will be welcome.
Consider the folowing information :
- Optimizer mode was choose on 7.3.4. But they wasn't any statistics on the
database. Explicitly optimizer rule with Oracle 8, that solve performance
problem with indexed nested loop statements.
- init.ora exactly the same between the two version, except,
compatible=8.0.4
- I have not measered the sum of physical/logical reads in 7.3.4