Re: Oracle and SQL Server

Garrick Bigwood wrote:
>
> Hello,
>
> I am doing some comparison testing between SQL Server and Oracle for
> evaluation of possible migration of existing app from SQL server to Oracle.
> The tests involve doing full table Updates (eg Update table1 set col1 = 5; -
> this is basically what our system does!!) on say 500,000 rows. Running this
> on Oracle 8.1.6 on Sun Enterprise 450 server with files spread across 3
> disks , I can get this to about 40-45 secs, with SQL Server 7 on a Compaq
> server with Raid 5 and 1.1 Gb CPU this takes about 3 - 4 secs. Looking at
> the trace files one of the problems with Oracle seems to be the amount of
> physical writes done to datafiles and rollback files(also redo of course),
> when I look at the SQL Server trace files there does'nt to be any writing
> done. I'm not sure if this is because they are not recorded or done at some
> point after the transaction has completed which would make comparison of the
> results difficult.
> Has anyone similar experience of testing SQL Server and Oracle, or is Oracle
> slow at Updates, or ...??
> thanks.

So how did you set up Oracle? from your description, it looks like you are comparing apples to oranges. How are your data files configured on the disks?

What does your SGA look like? What does the Oracle explain plan and tkprof look like for these statements? Are the indexes for the affected tables separated from the tables? etc., etc.

There is not enough info given here to begin to guess.

-- 
Ron Reidy
Oracle DBA