PL/SQL memory usage

From: Andrew Protasov <a_protasov_at_hotmail.com>
Date: Wed, 15 Dec 1999 16:55:12 GMT
Message-ID: <838h5c$88d$1@nnrp1.deja.com>

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. Received on Wed Dec 15 1999 - 10:55:12 CST