Hi,
DB Release: 9.2.0.5.0
For the first time I am looking into Statspack report and I am not sure what to look at while reading this report. Below are some of my observations from report which may be critical
The current issue is a daily job is running for 6hours which too slow and customer have shared Statspack report to identify root cause. Please let me know where do I start from and is there anything else that will help identify the problem.
Shared Pool Size: 384M
Parse CPU to Parse Elapsd %: 13.54
Top 5 Timed Events
~~~~~~~~~~~~~~~~~~ % Total
Event Waits Time (s) Ela Time
-------------------------------------------- ------------ ----------- --------
db file sequential read 27,469,371 125,169 41.23
PX Deq Credit: send blkd 30,297,906 91,778 30.23
db file scattered read 9,832,411 38,751 12.76
CPU time 18,183 5.99
db file parallel write 93,071 10,162 3.35
-------------------------------------------------------------
Background Wait Events for DB
Waits
Event Waits Timeouts Time (s) (ms) /txn
---------------------------- ------------ ---------- ---------- ------ --------
db file parallel write 93,071 0 10,162 109 0.1
LGWR wait for redo copy 381,093 399 4,196 11 0.3
thanks is advance.