Re: PL/SQL memory usage

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Fri, 17 Dec 1999 20:33:35 GMT
Message-ID: <83e6mv$9o9$1@nnrp1.deja.com>

Hi,

I want to repeat my question. Does anybody know how much memory Oracle uses for package variables in each session?

For example I checked background process size when package is called first time. It
increases by 120k if total size of
all variables in package is less than 30k. Why is it so?

Andrew Protasov

In article <838h5c$88d$1_at_nnrp1.deja.com>, Andrew Protasov <a_protasov_at_hotmail.com> wrote:
>
>
> Hi,
>
> I create package like
>
> create or replace package test is
> i1 integer default 1;
> i2 integer default 2;
> i3 integer default 3;
> i4 integer default 4;
> i5 integer default 5;
> i6 integer default 6;
> i7 integer default 7;
> i8 integer default 8;
> i9 integer default 9;
> i10 integer default 10;
> end;
> /
>
> How much memory will it use in PGA for each session?
> It looks like it is much more than 22*10 bytes. Why?
>
> Andrew
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 17 1999 - 14:33:35 CST