Re: Full scan perf. problem after mig Oracle 7.3.4/8.0.5

Since you did not say what type of machines you were using and if they were the same type of machine I will assume they are not the same. In addition you did not give any info on how Oracle was setup on each machine.

I would get some benchmarking software and see how fast each system can read/write to the hardrives first. You may have other system related issues that make NT to appear lots faster.

Steve McAllister
IXL
-----Original Message-----
From: Emmanuel Bontemps <michele-manu_at_wanadoo.fr> Newsgroups: comp.databases.oracle.server Date: Thursday, April 29, 1999 1:18 PM
Subject: 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
>- table 1 contain about 8,300,000 small rows (700 Mo), table 2 contain
>735,000 bigger records (600 Mo).
>
>
>
>
>
>
>
Received on Sun May 02 1999 - 10:14:14 CDT