topic Re: Oracle performance in Abap program in Application Development and Automation Discussions

Oracle performance in Abap program

Former Member — Fri, 15 May 2015 16:15:51 GMT

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

Re: Oracle performance in Abap program

Former Member — Fri, 15 May 2015 16:38:49 GMT

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

Re: Oracle performance in Abap program

Former Member — Sat, 16 May 2015 17:49:05 GMT

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

Re: Oracle performance in Abap program

Former Member — Thu, 21 May 2015 15:23:09 GMT

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

Re: Oracle performance in Abap program

Brindavan_M — Tue, 26 May 2015 11:35:51 GMT

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,