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.?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.