Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-04031 with Collections and SGA Settings - Part II
> Are these settings normal or is there something off in them that would
> explain why I consistently ran out of memory when trying to use a collection
> of about only 972,000 records?
>
> Any assistance/comments would be appreciated.
Have you checked global temporary tables? For a million records I'd say this would be much more scalable and normal approach than store all this stuff in memory.
Gints Plivna
http://www.gplivna.eu/
Received on Sun Jul 02 2006 - 02:26:13 CDT
![]() |
![]() |