RE: pl/sql table size

I suggest you to increase the kernel parameters: maxdsiz and maxssiz. Also check the user limit ( ulimit ).

Then check the swap space too. And how the machine is swapping.

Regards.

> -----Mensaje original-----
> De: babu.nagarajan_at_mail.iflexsolutions.com
> [SMTP:babu.nagarajan_at_mail.iflexsolutions.com]
> Enviado el: Martes 25 de Julio de 2000 15:09
> Para: Multiple recipients of list ORACLE-L
> Asunto: pl/sql table size
>
> 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...
Received on Tue Jul 25 2000 - 17:18:04 CDT