Skip to Content
author's profile photo Former Member
Former Member

Database

Helo

I am having performance issues with the oracle system, we use stored procedures to connect with oracle but we r getting memory buffer issues and oracle server needs to be optimised. does anybody have suggestions.?

yours sincerely

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Jan 16, 2009 at 06:51 PM

    Hi XI_Project

    I am not sure if it is the right place for you to ask, but check out SAP Note Number: 618868

    And also: http://help.sap.com/saphelp_nw04/helpdata/en/c4/3a724a505211d189550000e829fbbd/frameset.htm

    Best regards,

    Chris

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Instead of connecting multiple time to oracle ,you could collect a collection of data and send to oracle.

      Eg : If you are sending multiple repeating segments via xi and sending them to stored procedure ,better is to concatenate or club these repeating segments ( maybe you could talk to the Database professional) about how many strings of data it can accept and send this clubbed data to stored procedure.

      So initally if you had 1000 strings of data ,you might be connecting 1000 times with oracle but now if you bunch 100 strings together then it will be 1000/100=10 connections.

      Just a thought.

      Thanks

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.