pl/sql table size

From: <babu.nagarajan_at_mail.iflexsolutions.com>
Date: Mon, 24 Jul 2000 09:58:25 +0530
Message-Id: <10567.112731@fatcity.com>

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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">

<META content="MSHTML 5.00.2314.1000" name=GENERATOR></HEAD>
<BODY>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=575202004-24072000>Hi
List/Steve</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=575202004-24072000>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.</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=575202004-24072000>On my HPUX
all parameters reg user memory is set to unlimited and maxdsize is set to 67Mb - output from my sysadmin.</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=575202004-24072000>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.
</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN class=575202004-24072000>Also any
ideas on parameters i should set at the hpux level...</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000>TIA</SPAN></FONT></DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000></SPAN></FONT> </DIV>
<DIV><FONT face="Book Antiqua" size=2><SPAN
class=575202004-24072000>Babu</SPAN></FONT></DIV></BODY></HTML> Received on Sun Jul 23 2000 - 23:28:25 CDT