Re: how to configure async io on windows 2003 server ntfs system

On 21 Nov 2005 05:00:58 -0800, "lsllcm" <lsllcm_at_gmail.com> wrote:

>I have a table T1 with 900,000 rows, and join with 2-3 other tables,
>and retrieve out about 300,000 rows, then do "order by" operations. At
>last get the first 100 rows. It causes many direct path write and read
>events.
>
>Do you have any ideas about how to optimize this kind of sql?

Yes, you tune it.
check out tahiti.oracle.com for documentation also, Tom Kyte answered similar questions a few times asktom.oracle.com.
.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4 remove NSPAM to email Received on Mon Nov 21 2005 - 12:59:25 CST