Code Tester 1.8 is able to run about 3500 test cases spread across about 50 test definitions with all in a single test suite. After upgrading to Code Tester 2.5.1, running all the tests in the single test suite gave the following error:
“ORA-04031 unable to allocate string bytes of shared memory ("string","string","string","string")”
Running each Test Definition individually from the UI works fine. Also exporting that single test suite with contains all the test cases results in “out of memory error.”
More shared memory is needed than what is allocated in the shared pool.
If the shared pool is out of memory, either use the DBMS_SHARED_POOL package to pin large packages, reduce your use of shared memory, or increase the amount of available shared memory by increasing the value of the initialization parameters SHARED_POOL_RESERVED_SIZE and SHARED_POOL_SIZE. If the large pool is out of memory, increase the initialization parameter LARGE_POOL_SIZE.
Referring to the link below from OTN Discussions, it talks about defragmenting, flushing, and allocating more memory to the Shared Pool as well as restarting the database may help resolve the ORA-04031 error.
https://forums.oracle.com/forums/thread.jspa?threadID=484820
