John .... "This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons)."
Thanks on this .... See note I sent just before this on what I did. Bottom line is the query now returns thousands of rows in a spilt second as opposed to the 8 seconds it took before. I believe when we were at IOUGA last year, I think Tim or Wolfgang said to be careful loading up on the hints 8i and beyond. Mike -----Original Message----- Sent: Friday, January 24, 2003 3:09 PM To: Multiple recipients of list ORACLE-L hinted Mike, > several Direct_Path_Write and Read waits with large elasped times > are showing up in the 10046 trace data on this query due to the > full table scan. This is not to distract you from the original problem, but Direct Path Reads/Writes is I/O that bypass the Db block buffers to read directly into PGA, and is typical of sort I/O and PQ (among many other reasons). I mention this as your original query does have a sort at the end... (Apparently, Direct read/writes is also used when async I/O is configured and used, but I will let the gurus address that!) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
