Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Wait Event Direct path read TEMP

709382Jul 2 2009 — edited Jul 8 2009

HI,

I have two sessions waiting on wait event "DIECT PATH READ TEMP" (both the sessions with same SQL).Those sessions are almost in hung state.If i run that query from any other session,even that gets hanged.I have generated 10046 trace for these and found that all of them are waiting for a index object in TEMP datafile.
Has anyone of you had the same issue.
Please explain me what kind of action i have taken.
I have verified the stats..they are all up to date.

Thanks,
Pramod Garre

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 5 2009

Added on Jul 2 2009

#general-database-discussions

6 comments

2,401 views