Database   Sql   Functions   Packages   Performance   Books   Oracle   Other   About   XML   ORA-messages

Common error messages

TNS connection closed
IO error writing block
Resource busy
Invalid character
Invalid datatype
Syntax error
Looping chain synonyms
Resolve connect identifier
number too large for buffer
All error messages


ORA-04031:Unable to allocate string bytes of shared memory

Cause: More shared memory is needed than was allocated in the shared pool.
Action: 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 INIT.ORA parameters "shared_pool_reserved_size" and "shared_pool_size". If the large pool is out of memory, increase the INIT.ORA parameter "large_pool_size".