What is a good blocksize to use.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 26 Sep 2002 09:42:44 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702B43238@lnewton.leeds.lfs.co.uk>

Hi Ben,

you mention that you database is a 'port' from SQLServer, and that Oracle performs worse that SQLServer. Fair point, but ....

did you actually convert the system to make best use of Oracle features or simply 'copy' it all over and expect similar results ? have you taken into account the fact that both database systems are totally different in working etc ?
have you converted any of the SQL used (I'm presuming you have an app that accesses the db) to change it from the SQLServer way of things to the Oracle way ?
do you use 'temporary' tables in your processing - because this is required by SQLServer but Oracle doesn't need them because of 'read consitency' etc ?

I suggest a good look at Tom Kyte's book Exprert one-on-one Oracle - especially the first few chapters where he discusses the differences between different databases.

Regards,
Norman (being constructive and not starting any religous wars !)

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

Received on Thu Sep 26 2002 - 03:42:44 CDT