-
how to solve : ORA-04031
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|