Performance - EBS (MOSC)

MOSC Banner

Interorg transfer very slow

edited Sep 20, 2012 11:55PM in Performance - EBS (MOSC) 3 commentsAnswered
 Hi there,

We are facing sever performance issue while doing the interorg transfer.
our database is Oracle 10g RAC, with multnode application tier.

As per the document I enabled QUEUE for Transport Type from PIPE, as its Oracle 10g RAC.

Now initial 2-3 transaction is damn slow after opening the form, the it becomes fast. What could be the reason.

Trace:

DECLARE
pragma autonomous_transaction;
rpc_timeout NUMBER := 172800 ;
BEGIN
:1 := fnd_transaction.synchronous(rpc_timeout,:2,:3,'PO','RCVTPO','ONLINE',:4, NULL, NULL, NULL, NULL, NULL,
NULL,NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,NULL, NULL, NULL, NULL);
COMMIT; 

Thanks,
saroj

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS Performance Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center