Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to configure async io on windows 2003 server ntfs system

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

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Mon, 21 Nov 2005 18:59:25 GMT
Message-ID: <438218da.441133953@localhost>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US