Mailing-List: contact dev-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@jackrabbit.apache.org
Date: Thu, 13 Oct 2011 05:59:11 +0000 (UTC)
From: =?utf-8?Q?Claus_K=C3=B6ll_=28Commented=29_=28JIRA=29?= <jira@apache.org>
To: dev@jackrabbit.apache.org
Message-ID: 
 <1508033824.7997.1318485551755.JavaMail.tomcat@hel.zones.apache.org>
In-Reply-To: 
 <565820444.19027.1297811157592.JavaMail.tomcat@hel.zones.apache.org>
Subject: [jira] [Commented] (JCR-2892) Large fetch sizes have potentially
 deleterious effects on VM memory requirements when using Oracle
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


    [ https://issues.apache.org/jira/browse/JCR-2892?page=3Dcom.atlassian.j=
ira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D131263=
62#comment-13126362 ]=20

Claus K=C3=B6ll commented on JCR-2892:
---------------------------------

Modified (fetch Size 0 per default) patch applied in rev 1182667.
PostreSQL has a fetchSize of 10000 as before. If it makes no problems we ca=
n leave it so high.
               =20
> Large fetch sizes have potentially deleterious effects on VM memory requi=
rements when using Oracle
> -------------------------------------------------------------------------=
-------------------------
>
>                 Key: JCR-2892
>                 URL: https://issues.apache.org/jira/browse/JCR-2892
>             Project: Jackrabbit Content Repository
>          Issue Type: Bug
>          Components: jackrabbit-core, sql
>    Affects Versions: 2.2.2
>         Environment: Oracle 10g+
>            Reporter: Christopher Elkins
>            Assignee: Claus K=C3=B6ll
>             Fix For: 2.2.10, 2.3.2
>
>         Attachments: JCR-2892.patch, oracleFetchSize.patch
>
>
> Since Release 10g, Oracle JDBC drivers use the fetch size to allocate buf=
fers for caching row data.
> cf. http://www.oracle.com/technetwork/database/enterprise-edition/memory.=
pdf
> r1060431 hard-codes the fetch size for all ResultSet-returning statements=
 to 10,000. This value has significant, potentially deleterious, effects on=
 the heap space required for even moderately-sized repositories. For exampl=
e, the BUNDLE table (from 'oracle.ddl') has two columns -- NODE_ID raw(16) =
and BUNDLE_DATA blob -- which require 16 b and 4 kb of buffer space, respec=
tively. This requires a buffer of more than 40 mb [(16+4096) * 10000 =3D 41=
120000].
> If the issue described in JCR-2832 is truly specific to PostgreSQL, I thi=
nk its resolution should be moved to a PostgreSQL-specific ConnectionHelper=
 subclass. Failing that, there should be a way to override this hard-coded =
value in OracleConnectionHelper.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrato=
rs: https://issues.apache.org/jira/secure/ContactAdministrators!default.jsp=
a
For more information on JIRA, see: http://www.atlassian.com/software/jira