On hp-ux 10.20/Oracle 8.0.5, we had to increase memory
parameters so a process can go up to 400M (and avoid
ora-4030). If my memory is correct, the parameters
were maxdsize, maxcsize and maxssize.
- babu.nagarajan_at_mail.iflexsolutions.com a écrit : >
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
>
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com
spaquette_at_houra.fr
(33) 01 53 93 06 50
Do You Yahoo!?
Get Yahoo! Mail – Free email you can access from anywhere!
Received on Wed Jul 26 2000 - 02:42:19 CDT
