ora-1652 unable to extend temp segment tablespace temp

Posted on 2014-01-16
Medium Priority
Last Modified: 2014-01-29
have gotten this error two nights in a row
the error is in the alert log for
23:44:32 - was paged for this error

an rman backup was also running at this time

ora-1652 unable to extend temp segment by 128 in tablespace TEMP
ran this query:

SELECT s.username, s.sid, u.TABLESPACE, u.CONTENTS,
sum(u.extents) extents, sum(u.blocks*8*1024)/1024/1024 MB
FROM v$session s, v$sort_usage u
WHERE s.saddr = u.session_addr
GROUP BY s.username, s.sid, u.TABLESPACE, u.CONTENTS;

returned one row

how do I know what this query returned is the correct user, statement running for that time?

the statement is an insert
Question by:bkreynolds48
1 Comment

Accepted Solution

Surrano earned 2000 total points
ID: 39785727
My feeling is that you check "current" usage as opposed to usage at the time of ora-1652 error. Best would be to tell Oracle to write a trace file when this occurs:

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to recover a database from a user managed backup

600 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question