Re: network vector IO
From: Yong Huang <yong321_at_yahoo.com>
Date: Tue, 22 Jun 2010 11:12:34 -0700 (PDT)
Message-ID: <98167.64424.qm_at_web80608.mail.mud.yahoo.com>
> What this feature is? How to turn it on? Off?
Date: Tue, 22 Jun 2010 11:12:34 -0700 (PDT)
Message-ID: <98167.64424.qm_at_web80608.mail.mud.yahoo.com>
> What this feature is? How to turn it on? Off?
Try changing _use_zero_copy_io to false and bounce the database. The description of this parameter is "Should network vector IO interface be used for data transfer".
If you use JDBC, there's a documented way to turn it off with
OracleConnection.CONNECTION_PROPERTY_THIN_NET_USE_ZERO_COPY_IO
It's in the "Working with LOBs and BFILEs" chapter but I doubt it's limited to that. Ref: http://download.oracle.com/docs/cd/E11882_01/java.112/e10589/oralob.htm
Yong Huang
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 22 2010 - 13:12:34 CDT