Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Large pool usage in full export

549694Oct 18 2007 — edited Oct 18 2007

Can someone please tell me what is the use of Large Pool in a full database export?
I was trying to perform a full export which was failing with error:

ORA-04031: unable to allocate 4032 bytes of shared memory ("shared pool","unknown object","joxs heap init","ioc_allocate_pal")

So I increased the Shared pool size and tried again. Again I got the same error.
After that I checked that the Large Pool size is set to 0. I increased it to 15M.
Then the export was successfull.

As far as my knowledge, Large Pool is used for other reasons like a RMAN backup. Can anyone please explain me what is the use of large pool in export?

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 15 2007

Added on Oct 18 2007

#general-database-discussions

8 comments

801 views