Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: parallel query wait events
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