During a Reorg you receive the following error and the script aborts:
From the script log:
......
[385] 10/30 14:04:02 Error occurred during execution of posting procedure
[385] 10/30 14:04:32 ExecLwrp returned: ORA-04031
[385] 10/30 14:04:32 ORA-04031: unable to allocate bytes of shared memory ("","","","")
[385] 10/30 14:04:32 Posting session failed: ORA-04031
[385] 10/30 14:04:32 ORA-04031: unable to allocate bytes of shared memory ("","","","")
[385] 10/30 14:04:32 AbortScript()
[385] 10/30 14:04:32 AbortScript: Aborted QSA-20391 ORA-04031 during internal SQL (os errno 0)
[385] 10/30 14:04:47 Can't update QUEST_SCRIPT end date: ORA-00604
[385] 10/30 14:04:47 ORA-00604: error occurred at recursive SQL level
The memory allocated to the Oracle shared pool is insufficient for answering the user request.
RESOLUTION:
1. Increase the size of your Oracle shared pool.
2. Restart Reorg job
WORKAROUND:
1. Flush the Shared pool by issuing "alter system flush shared_pool;" in Oracle
2. Restart Reorg job
3. If it still fails with the same error, then you will have to increase the size of your shared pool.
