| package performance [message #359110] |
Thu, 13 November 2008 14:37  |
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  |
rleishman
Messages: 3728
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 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
