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: parallel query wait events

Re: parallel query wait events

From: hopehope_123 <hopehope_123_at_yahoo.com>
Date: 18 Jul 2005 23:16:18 -0700
Message-ID: <1121753778.867284.119760@z14g2000cwz.googlegroups.com>


Hi Sybrand , Daniel ,

Thanks for your answers. This oracle 9.2.0.5 rac with 2 nodes on redhat linux 2.1 ia64 and data warehouse type system. The disk subsystem is emc and raid 10 . (So the data is in theory distributed inside the emc. )

Anyway , when i query the table by using sqlplus , it is very fast . After than , i started to check the spss part. This tool uses odbc , (data direct odbc for sun - 64 bit) , after enabling the odbc trace , i see for the above query and wait events , the spss process waits on sqlfetch odbc call. There exist a parameter called ARRAY SIZE (client fetch buffer size) which is 60000 by default for the odbc driver , i changed it to a lower value( 1000) and things has started to run fast . Now the client runs faster.

Kind Regards,
hope Received on Tue Jul 19 2005 - 01:16:18 CDT

Original text of this message

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