I need to convert MS-SQLServer stored procedure to Oracle stored procedure
and I need to tuning them for best performance ever.
What is the best way ?
Best regards and thanks a lot in advance.
This is not as easy as you seem to think. It's not simply a matter of translating syntax. MSSQL and Oracle are fundamentally and architecturally different. This has far reaching implications for any conversion/translation project. The only way to really do it - especially if 'best performance ever' is a goal, is to re-architect the system and re-write code from scratch, with that re-writing being done by someone who is fluent in oracle.
use the existing migration features in SQL Developer
then get ready to do lots and lots of testing and probably write as much as 20-50% PL/SQL on your own where our translators left off. Some customers get as high as 90% of their code translated w/o much work.
Ed's not wrong - if you want to do it 'right' - sometimes changing everything about how your application works with the database is required.