Home » Infrastructure » Windows » InitialLOBFetchSize & FetchSize."oracle" (oracle.DataAccess for oracle9i and 10g)
InitialLOBFetchSize & FetchSize."oracle" [message #356036] Wed, 29 October 2008 02:14 Go to next message
startanew
Messages: 6
Registered: October 2008
Junior Member
Hi guys,

There seems to be alot of explanation on both the oracle property in the oracleCommand object. But non does clearly explain the usage in the real life situation

Let say i have a table :

Table : Customer

Field : Name varchar(255)

Filed : Address (Blob/Lob)

when retrieving the whole data in customer table it will use FetchSize to determine each round of data retrieval.

The question is, when i set the FetchSize do i need to consider the initiallobfetzhsize ? Since initiallobfetchsize determine how big oracle will fetch the blob/lob (e.g. Address)

How you guys understand my query.

Thank you in advance.

Re: InitialLOBFetchSize & FetchSize."oracle" [message #358687 is a reply to message #356036] Wed, 12 November 2008 03:04 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Documenation migh help you
Re: InitialLOBFetchSize & FetchSize."oracle" [message #358697 is a reply to message #358687] Wed, 12 November 2008 03:43 Go to previous message
startanew
Messages: 6
Registered: October 2008
Junior Member
thxs for the heads up
Previous Topic: Installing Oracle developer suite on Vista
Next Topic: Windows batch job Help
Goto Forum:
  


Current Time: Thu Mar 28 05:06:10 CDT 2024