Q
Problem solve Get help with specific problems with your technologies, process and projects.

Resolving errors ORA-01652 and ORA-04031

  1. ORA-01652: unable to extend temp segment by 250 in tablespace TEMP
  2. ORA-04031: unable to allocate 18048 bytes of shared memory ("shared pool","EVENT _HANDLING","PL/SQL MPCODE","BAMIMA: Bam Buffer")
What is the perfect solution for the above errors?

ORA-01652 is caused when Oracle tries to allocate an extent for a temporary tablespace and can't do to lack of space. The solution is to use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

ORA-04031 is caused when your shared pool is too small. You need to either increase the shared_pool_size (also note the shared_pool_reserved_size parameter as well) if you have available memory to do so. Otherwise, you can either use the DBMS_SHARED_POOL package to pin large packages or reduce your use of shared memory (for example: make sure to use bind variables in SQL to encourage reuse).

For More Information


This was last published in May 2003

Dig Deeper on Oracle error messages

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close