Re: ORA-04030 beating

Hey Mark, thanks for your input.
I've been able to duplicate the error on various windows clients as well as in sessions on the database server connecting user_at_sid. So the client version is different in some cases, the same in others. So far this only runs successfully from a session on the database server connected locally.

I just finished an hour conference with Oracle support, gathering info from v$ views, truss, etc. I'm just glad I'm not stumped alone. Although, I fully expect the solution, when and from wherever it comes, to be something I should have thought of already.

Thanks!
Darrell

Sent from my iPhone

On Nov 21, 2008, at 12:54, "Powell, Mark D" <mark.powell_at_eds.com> wrote:

> The maximum size of a pl/sql table (array) used to be OS dependent.
> I can remember when we tested and found the limit was only around
> 10M on a Pyramid on 7.0 or maybe 7.1.
>
> I image that the amount of available free real memory on the client
> may also be important.
>
> Is the client where the task is failing at 111M a Windows or UNIX
> box? Is the client version the same as the database version?
>
> Interested in what others can add.
> -- Mark D Powell --
> Phone (313) 592-5148
>
>
>

--
http://www.freelists.org/webpage/oracle-l