>We are converting from SQL Server and Sybase to >Oracle. >To convert functions and stored procedures we have >been using the >Oracle Migration Workbench (OMWB) which produced >WEAK REF CURSOR and >TRANCOUNT global variable. >I looked at (trace and explain plan) statements in >the procedures >and functions, it seems everything are OK. Init.ora >parameters >are big enough, statspack generated good values. >The same function and procedure took about 1 minute > >in Sybase but take 9 minutes in Oracle. The >difference is the procedures >or functions after migration calling OMWB package >(globalpkg). >Any idea or tuning tips after migrating to Oracle ? > >Is Oracle slower than Sybase and SQL Server ? > >Tia. > >Rivaldi
I have had this kind of problem (only 8mn against 80mn) some months ago ... not exactly the same physical schema in Oracle as in Sybase :-). You cannot say that Oracle is inherently slower or faster than Sybase or SQL Server. It depends on a lot of things, the underlaying hardware, your application of course, the use of some 'native tricks' (and from experience IOTs are not exactly equivalent to clustered indexes). The problem is that automated tools may be good for a first pass, but you really need to dive in the code and tweak it manually if you want good results. A RDBMS is not the 'neutral' component you may think. FYI we managed to bring Oracle performance in line (very slightly better, in fact) with Sybase performance in the case mentioned above. But it hasn't been easy. HTH, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
