Re: DIRECT PATH READ wait events

://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 22 May 2002 06:43 |List, | |I am trying to tune a SQL query. |Oracle 8163 , Windows NT 6 SP6. | |How can I eliminate DIRECT PATH READ wait events. |I have traced

DIRECT PATH READ wait events

List, I am trying to tune a SQL query. Oracle 8163 , Windows NT 6 SP6. How can I eliminate DIRECT PATH READ wait events. I have traced a session (10046, level 12) and find a whole lot of waits for DIRECT PATH READ. It waits 200 seconds for this event. WAIT #1: nam='direct path read' ela= 0 p1