ora-1652 unable to extend temp segment tablespace temp

have gotten this error two nights in a row
the error is in the alert log for
9:45:37
and
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
LVL 1
bkreynolds48Asked:
Who is Participating?
 
SurranoSystem EngineerCommented:
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:
http://blog.flimatech.com/2009/07/23/how-to-force-an-error-to-generate-a-trace-file-when-an-ora-error-occurs/
0
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.

All Courses

From novice to tech pro — start learning today.