hi all,

I am getting this error whenever i am running a big query which has couple of inline views in it. I have recently loaded oracle9i and this problem started occurring after that. I know that I have to increase the shared memory size and the only way to do that is to increase the SGA size. is there a way to find out what should be the approximate size of SGA so that this error never appears in future? pls guide me once again to get rid of this problem for once and for all.
-----------------the error message----------------------

SQL error occurred while retrieving data. Error: ORA-04031: unable t
o allocate 71416 bytes of shared memory ("large pool" "unknown object" "hash-join subh" "kllcqc:kl
lcqslt")
--------------------------------------------------------

thanks a lot!

Parijat