Oracle performance in Abap program

[Former Member]

Dear Sirs,

I have an ABAP program that writte an Oracle Database using DBlink and using the following code.

l_prepstmt_ref->set_param_struct( l_dref ).

         l_prepstmt_ref->execute_update( ).

         CLEAR l_wa.

         COMMIT WORK.

We would like to improve the performance of the process and the database writting. What are the best practices to do this? And what about on Oracle side? Can we customize the database with some best practices?

Thank you and Best Regards

João Lages Fernandes

[Former Member]

"Dear Sirs"???  Are you not interested in answers from women? 

[Former Member]

Hi Jim,

Of course i want asnwer from women. i am sorry for the mistake. I mean "Hi everyone".

By the way your answer to the problem is...

Thank You and best regards

[Former Member]

Sorry Joao, I don't have an answer for you, just teasing you about "sirs"

I don't have a lot of experience with either DBlink or Oracle, but I would think that improvements would have to be with your actual SQL statements.  Have you tested whether the performance is the same if you do the same SQL directly in Oracle vs having it come from SAP?  If so, maybe work out what the best SQL statements are by working directly in Oracle, then port that over to SAP once it's sorted out.

Good luck,

Jim

[Brindavan_M]

Hello Joao Fernandes,

Better do some SQL trace and find to optimized from program or better switch the JOB to some application server which is performance is good.

Any program to make performance good by tuning from SQL or Program or hardware size.

For exa: Join quires , selection screen, closed method which were leak suspect wil cause perfomrance issue.

Thanks,

BM