OraFAQ Forum: Performance Tuning » AWR - "db file parallel read" + "direct path read" wait events, wait class

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))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

AWR - "db file parallel read" + "direct path read" wait events, wait class - "User I/O" [message #608294]

Tue, 18 February 2014 08:02

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.

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

trantuananh24hg
Messages: 744
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.

Report message to a moderator

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:04:42 CST 2025