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 **************************************************************************************************************** This e-mail, including any attachments, may include confidential and/or proprietary information, and is intended for use only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient, or his or her authorized agent, the reader is hereby notified that any dissemination, distribution, or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. **************************************************************************************************************** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bahar, Rivaldi (BBASSI-CHQ) 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).
