Re: Oracle client processes memory requirements - Info needed

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/03
Message-ID: <38c032ae.20447373@news.earthlink.net>#1/1

search technet.oracle.com on
sort_area_size
and
sort_area_retained_size
They probobly contribute to the most of your 8Meg

On Fri, 03 Mar 2000 12:29:29 +0100, Mauro Bregolin <bregolin_at_isyi.it> wrote:

>This is a multi-part message in MIME format.
>--------------33DF4D2EA247905A8CF4215B
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>I'd like to know if (and how) it is possible to reduce the memory
>requirements of an Oracle client.
>My specific problem is related to a perl CGI which accesses 8.0.5 via
>DBI (on HP-UX, if it matters); at the moment of login, it makes a
>requests for about 8Mb of RAM. Does connecting to Oracle really need all
>that?
>Is it a problem related to the plethora of Oracle libs perl is
>ultimately linked to when using the Oracle access module? (If so, shared
>libraries could help, I guess...)
>Or is the problem due to the "particular" client implementation of the
>Perl DBI module? - in other words, I could speculate that OCI calls may
>be tailored to the needs of the client (e.g., in terms of RAM
>allocations for data structures) but the implementation made in DBI
>defaults to a given set of values to accommodate the majority of the
>scenarios. If so, a well designed C program should provide better
>results...
>Any help is greatly appreciated.
>
>Thanks,
>
>Mauro Bregolin
>
>
>--------------33DF4D2EA247905A8CF4215B
>Content-Type: text/x-vcard; charset=us-ascii;
> name="bregolin.vcf"
>Content-Transfer-Encoding: 7bit
>Content-Description: Card for Mauro Bregolin
>Content-Disposition: attachment;
> filename="bregolin.vcf"
>
>begin:vcard
>n:Bregolin;Mauro
>tel;fax:+39 049 8073066
>tel;work:+39 049 8073066
>x-mozilla-html:TRUE
>adr:;;;;;;
>version:2.1
>email;internet:bregolin_at_isyi.it
>end:vcard
>
>--------------33DF4D2EA247905A8CF4215B--
>

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Fri Mar 03 2000 - 00:00:00 CST