On 8.1.7 on AIX I have seen ORA-04031 and then ORA-03780 errors when a
large pool was not used with large complex queries (a 15 table join).
I always suggest turning it on by using the parallel_automatic_tuning
initialization parameter. As long as you don't have DOP set and have
no parallel slaves configured it shouldn't be harmful. Also, manually
set the size of V$SGASTAT may not see it.
Mike Ault
"Kevin S. Smith" <SpamNoMore_at_EriePlating.com> wrote in message news:<ug1hb5d0ikbvfa_at_corp.supernews.com>...
> Oracle 8i on Redhat 7.2.
>
> I read that instead of using a large pool, you can set the
> SHARED_POOL_RESERVED_SIZE init.ora parameter to reserve memory in the shared
> pool for large SQL statments to be processed. Is there an advantage to using
> either one of these? We are not running multithreaded server, but we do run
> some very large SQL queries. Any insight on this would be appreciated.
>
>
> Kevin
Received on Fri Jun 07 2002 - 13:54:04 CDT
