Home » RDBMS Server » Performance Tuning » package performance (oracle10.2.0.3)
package performance [message #359110] Thu, 13 November 2008 14:37 Go to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
experts,

i am facing one problem. one of package in the database will run on as nightly job. this job is taking long time during the Saturday
and it is running file during weekday.

when i am planning to put 10046 trace on Saturday it went fine.

i am not sure how do i track this problem. can any one guide me
to find the potential cause of this problem.


Regards,

Kumar
Re: package performance [message #359143 is a reply to message #359110] Thu, 13 November 2008 19:26 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Keep tracing it until it exhibits the bad behaviour.

Otherwise, try running a StatsPack after it run badly.

Ross Leishman
Re: package performance [message #359319 is a reply to message #359143] Fri, 14 November 2008 14:10 Go to previous messageGo to next message
skumar.dba
Messages: 82
Registered: October 2007
Member
Thanks for updates,

i ran the awr report. i can see below wait events. i am not sure whey PX Deq Credit: send blkd wait event is in top list;

can any one guide me what is this wait event. why it is coming on Saturday only

Top 5 Timed Events                                         Avg %Total
~~~~~~~~~~~~~~~~~~                                        wait   Call
Event                                 Waits    Time (s)   (ms)   Time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
PX Deq Credit: send blkd            788,584     189,286    240   48.7      Other
CPU time                                         90,488          23.3
db file sequential read          33,353,969      83,715      3   21.5   User I/O
direct path read                 11,506,827      20,502      2    5.3   User I/O
SQL*Net more data to client      21,320,765       7,490      0    1.9    Networ
Re: package performance [message #359334 is a reply to message #359319] Fri, 14 November 2008 23:10 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See if you can find any poor performing SQLs in the report.
Previous Topic: Interpreting "Row Source Operation" Output of TKPROF
Next Topic: Error in Materialized view refresh
Goto Forum:
  


Current Time: Sat Dec 03 18:01:08 CST 2016

Total time taken to generate the page: 0.11306 seconds