Message-Id: <10567.112731@fatcity.com>
From: babu.nagarajan@mail.iflexsolutions.com
Date: Mon, 24 Jul 2000 09:58:25 +0530
Subject: pl/sql table size
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01BFF527.58407654
Content-Type: text/plain;
charset="iso-8859-1"
Hi List/Steve
We are facing a problem in building pl/sql tables. The platform is HPUX11
with Oracle 815. I am trying to build a huge PL/SQL table - rough estimates
of size to be around 20-30 mb and then planning to use bulk-bind.
On my HPUX all parameters reg user memory is set to unlimited and maxdsize
is set to 67Mb - output from my sysadmin.
Now when I run this process oracle fails with ora-4030. I want to know where
woudl pl/sql tables be stored in the memory and how do i find out what
exactly my pl/sql table is occupying. right now i am going by the size of
the data.
Also any ideas on parameters i should set at the hpux level...
TIA
Babu
------_=_NextPart_001_01BFF527.58407654
Content-Type: text/html;
charset="iso-8859-1"
Hi
List/Steve
We are
facing a problem in building pl/sql tables. The platform is HPUX11 with Oracle
815. I am trying to build a huge PL/SQL table - rough estimates of size to be
around 20-30 mb and then planning to use bulk-bind.
On my HPUX
all parameters reg user memory is set to unlimited and maxdsize is set to 67Mb -
output from my sysadmin.
Now when I
run this process oracle fails with ora-4030. I want to know where woudl pl/sql
tables be stored in the memory and how do i find out what exactly my pl/sql
table is occupying. right now i am going by the size of the data.
Also any
ideas on parameters i should set at the hpux level...
TIA
Babu