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: windows batch file : variable assignment
Next Topic: Windows batch job Help
Goto Forum:
  


Current Time: Mon Jul 28 20:31:31 CDT 2014

Total time taken to generate the page: 0.11024 seconds