ralph_rea
asked on
Oracle TEMP tablespace
Hi,
yesterday at 13:00 I have been getting the ORA-1652 error:
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Now I'd like to know what sessions have used the TEMP tablespace and how much space has been used by every session
What query can I use to get these informations?
My Oracle version is 10g
Thanks in advance!
yesterday at 13:00 I have been getting the ORA-1652 error:
ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
Now I'd like to know what sessions have used the TEMP tablespace and how much space has been used by every session
What query can I use to get these informations?
My Oracle version is 10g
Thanks in advance!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>>my oracle version is 10g (not 11g)
I got that from the original question. The links I posted was 10g's docs and the Support notes are not 11g specific.
Without the session active you might be able to use AWR or some of the historical views but I'm not that familiar with them.
I'll have to defer to other Experts that are more familiar with them.
I got that from the original question. The links I posted was 10g's docs and the Support notes are not 11g specific.
Without the session active you might be able to use AWR or some of the historical views but I'm not that familiar with them.
I'll have to defer to other Experts that are more familiar with them.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER