on 01-16-2009 6:48 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.