From oracle-l-bounce@freelists.org Fri Aug 5 18:57:11 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j75NvBxd004213 for ; Fri, 5 Aug 2005 18:57:11 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j75Nv2IP004203 for ; Fri, 5 Aug 2005 18:57:02 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 734091DCDC3; Fri, 5 Aug 2005 18:56:55 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 10382-06; Fri, 5 Aug 2005 18:56:55 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DF5381DCD05; Fri, 5 Aug 2005 18:56:54 -0500 (EST) Message-ID: <019101c59a19$19437b80$0301a8c0@porgand> From: =?iso-8859-1?Q?Tanel_P=F5der?= To: "ORACLE-L" References: Subject: Re: JDBC buffer? Date: Sat, 6 Aug 2005 00:55:02 +0100 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_018E_01C59A21.7A50A170" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-archive-position: 23493 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: tanel.poder.003@mail.ee X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-1.8 required=5.0 tests=AWL,BAYES_00, FROM_ENDS_IN_NUMS,HTML_60_70,HTML_FONTCOLOR_UNKNOWN,HTML_MESSAGE autolearn=no version=2.63 ------=_NextPart_000_018E_01C59A21.7A50A170 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, At least OCI allows LOB buffering (search for LOB buffering subsystem) = and also LOB update bundling, so you can create several LOBs in your = application and flush these to database later on. Actual network = transfer and inserts are done only during flush operation. JDBC might have something similar... Tanel. ----- Original Message -----=20 From: Wolfson Larry - lwolfs=20 To: Oracle-L@freelists.org=20 Sent: Thursday, August 04, 2005 1:58 AM Subject: JDBC buffer? Hi, everyone! =20 Have a client who's having an intermittent problem while = inserting file_blobs into the database. The insert appears to be taking no time at all, but they're = complaining about 7 second (or more) response time to app server. =20 Asked them to put in JDBC trace but they say they're too busy to = restart app. =20 I was wondering what kind of tuning could be done in JBDC? =20 =20 Thanks Larry Wolfson ------=_NextPart_000_018E_01C59A21.7A50A170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

At least OCI allows LOB buffering = (search for LOB=20 buffering subsystem) and also LOB update bundling, so you can create = several=20 LOBs in your application and flush these to database later on. Actual = network=20 transfer and inserts are done only during flush operation.

JDBC might have something = similar...

Tanel.

----- Original Message -----

From:=20 Wolfson Larry - lwolfs =

To: Oracle-L@freelists.org =

Sent: Thursday, August 04, 2005 = 1:58=20 AM

Subject: JDBC buffer?

Hi,=20 everyone!

= =20 Have a client who=92s having an intermittent problem while inserting = file_blobs=20 into the database.

The insert = appears to=20 be taking no time at all, but they=92re complaining about 7 second (or = more)=20 response time to app server.

Asked them = to put in=20 JDBC trace but they say they=92re too busy to restart=20 app.

= =20 I was wondering what kind of tuning could be done in=20 JBDC?

= =20 Thanks

= =20 Larry Wolfson

------=_NextPart_000_018E_01C59A21.7A50A170-- -- http://www.freelists.org/webpage/oracle-l