want to reduce the COST [message #276551] |
Thu, 25 October 2007 08:30 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
AshaAtrey
Messages: 4 Registered: October 2007 Location: pune
|
Junior Member |
|
|
Hi,
I am working in a B2B setup, and made programs to cancel an IR/PR line if an ISO/PO line get cancelled and vise versa.
the program is taking almost 10-12 mins to run from the front end.
Attaching both the programs, The cursor used in the programs seems too costly,
I tried to reduce the cost but could not reduce further.
Plz if any of senior member can help will be so helpful for me.
-
Attachment: Programs.zip
(Size: 6.54KB, Downloaded 1275 times)
|
|
|
|
|
|
|
|
|
Re: want to reduce the COST [message #276956 is a reply to message #276551] |
Sat, 27 October 2007 05:07 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
michael_bialik
Messages: 621 Registered: July 2006
|
Senior Member |
|
|
IMHO - you have a severe performance problems within your application:
1. Very high parsing times:
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 2 0.00 42.43 0 0 0 0
Elapse time for parse is not acceptable.
It may mean that your application shared pool is not sized correctly and the application is waiting a lot of time for each parse.
2. In most cases there is a huge difference between CPU and elapse times, meaning that application is waiting for some resource.
Instead of
Alter session set sql_trace = true;
try
Alter session set events '10046 trace name context forever, level 8';
Look at the raw trace file and try to find what is the resource.
Michael.
|
|
|