Home » RDBMS Server » Performance Tuning » AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" (Oracle 11.2.0.3.0 on HP-UX (64-Bit))
AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" [message #608294] Tue, 18 February 2014 08:02 Go to next message
hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA
Member
Hi,

We have INSERT scheduled job, which runs from App server to DB server, now a days it takes longer time than normal.

Database - Oracle 11.2.0.3.0 on HP-UX (64-Bit)

AWR shows (During INSERT Job) -

Top 5 Timed Foreground Events
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Avg
wait % DB
Event Waits Time(s) (ms) time Wait Class
------------------------------ ------------ ----------- ------ ------ ----------
direct path read 352,033 826 2 28.3 User I/O
db file parallel read 1,279 806 630 27.6 User I/O

Please help.
Thanks in advance.
Re: AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" [message #608298 is a reply to message #608294] Tue, 18 February 2014 08:20 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
we need a few more details.
http://www.orafaq.com/forum/m/433888/#msg_433888
Please refer to URL above & be sure to provide the details requested:
1) DDL for all tables & indexes
2) EXPLAIN PLAN
3) output from SQL_TRACE & tkprof
Re: AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" [message #608671 is a reply to message #608298] Fri, 21 February 2014 20:46 Go to previous messageGo to next message
Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA
Senior Member
maybe you just have a lot more data to scan today than you did in the past.
Re: AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" [message #609115 is a reply to message #608671] Sun, 02 March 2014 22:03 Go to previous message
trantuananh24hg
Messages: 742
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
And maybe the object table had lost statictis, the indexes could be INVALID, or something else.
Previous Topic: Oracle contain clause performance issue
Next Topic: Difference in elapsed time of the query where everything in the trace seems to be identical
Goto Forum:
  


Current Time: Thu Dec 02 09:18:20 CST 2021