Test window/debugger terrible slow

B

bsteerne

Member
I'm an technical EBS consultant for Oracle Netherlands and happily using PL/SQL developer as my IDE.

I use the test window quite often, normally it runs a little slower than just executing to code, but now and then it runs terrible slow under almost the same conditions (same server, same test script, low server load). It takes about 10 to 15 seconds to take one step.

I was wondering what causes these enormous delays and how I can solve this problem.

Kind regards,

Bert-Jan Steerneman
 
Assuming that PL/SQL Developer performs the same actions, there must be a performance bottleneck on the client PC, the network, the Server, or within the database. It's difficult to say anything more from here.
 
Hi,

As you run EBS, you can try this:

Code: 
alter PACKAGE APPS.MSC_CL_PRE_PROCESS compile body;
If you get ORA-04031, you need to increase the shared pool size. Other than that, no ideas.

Regards,
Gustavo
 
You must log in or register to reply here.
Back
Top