• SPEForums need your contributions to build up a strong repository of performance engineering resources.

Hi anyone Plz Answer to my question I Have 5...

S

Swathi Ch

Guest
Hi anyone Plz Answer to my question I Have 5 scripts, 4 scripts are meeting SLA executing transaction in 5 seconds, 5th script not meeting SLA it is taking 20 seconds to execute what could be the issue, It is Application issue or network issue?
 
Any issue, it's like asking: "my car won't start, is it an engine issue? Starter issue? Battery issue?..."
 
There can be long list of issues If it is web page then try to see the breakup time for each component in that trasaction..if any one object on that page is taking long, fix that. If it is Arthematical and logical operation, try working on code. Also check the resource utilization of that transaction, if its high, it might need attension. It will be better if you can share the whole detail about that transaction
 
All the 5 scripts using same transactions or different transactions
 
Why you need 5 script if they r using same transaction?
 
what is the load generator for the 5th script..? is that same for remaining 4scripts..
 
Run 5th script for some time and see transaction time .
 
Please stop shotgun spamming your messages to multiple forums. This behavior will bet you banned from many locations on the internet
 
it might be test data issue. Go for the Awr reports so that u can find which query is cauwing the delay.
 
Someone said AWR reports. How did they come to a conclusion that oracle is the back end?
 
Execute the 5th script alone for 1 hour and see the response times. If it is completing within SLA, and if ur script uses web protocol , check for web page diagnostics
 
You must log in or register to reply here.
Back
Top