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

TX-level lock

We found a TX-level lock on one of our tables. When we checked our application logs we found that it is throwing an ORA-01652 exception, saying "unable to extend tempspace." Our tempspace is already 27GB, is it less? Secondly, can dropping this tempspace in between a running query cause the lock to exist?

We found a TX-level lock on one of our tables. When we checked our application logs we found that it is throwing an ORA-01652 exception, saying "unable to extend tempspace." Our tempspace is already 27GB, is it less? Secondly, can dropping this tempspace in between a running query cause the lock to exist?
If you have the ORA-1652 error, then your temp tablespace is out of available space. There were some bugs in early Oracle 9i versions with temp tablespaces that were locally managed that did not release space to new users. So if you are running Oracle 9i, then apply the 9.2.0.7 patchset at a minimum. Otherwise, consider adding more space.

Dig Deeper on Oracle database design and architecture

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