Re: JDBC / Oracle / MS SQL Server performance anomalies

From: Candido Dessanti <candido.dessanti_at_blunet.it>
Date: 5 Feb 2003 07:55:16 -0800
Message-ID: <11c1e2d8.0302050755.69776cb4@posting.google.com>

Well to improve performace using dynamic sql you have to set this instance parameter

cursor_sharing='FORCE'

using that i got 86secs on a notebook with a celeron 700Mhz with oracle 9i J= vM 1.3.1.

if cursor=5Fsharing=3D'EXACT' i get 156secs.

so you are getting rougly a 100% performance increase. Anyway using batch = update and prepared statement it takes 7-10secs :)

I guess you can further improve performance with a deeper tuning. Received on Wed Feb 05 2003 - 09:55:16 CST