Temp tablespace constantly blowing out
We have a 2GB temp tablespace and I'm trying to find out what user is running the offending sort. Are there any scripts out there to find what this out.? We have added more space to the tablespace to 4GB and it blew out again. We have a 2mb sort area size and 2mb retained size.
Initial and next on the temp tablespace is 2mb.
any help would be grateful.
Re: Temp tablespace constantly blowing out
Quote:
Originally posted by rgaskell
We have a 2GB temp tablespace and I'm trying to find out what user is running the offending sort. Are there any scripts out there to find what this out.? We have added more space to the tablespace to 4GB and it blew out again. We have a 2mb sort area size and 2mb retained size.
Initial and next on the temp tablespace is 2mb.
any help would be grateful.
I'm also experienceing the same problem on 8i(8173)/AIX, and found that its bug. Not sure whats your platform and version of oracle.