Re: TEMP tablespace problem

RobW95 wrote:

> We have been experiencing some problems with our Temp tablespace. It is
> actually happening in two of our instances and it is basically the same
> problem. Everything is find for extended periods of time and then suddenly we
> notice that the temp tablespace is maxed out. It seems like they are big enough
> (100M in one, and 300M in the other). My guess is that the culprit is MS
> ACCESS, which our users utilize to query against the databases. One time when
> the 300M temp tablespace was maxed out I saw in V$session one woman who was
> running 10 Access queries at one time. She would submit one, it would run for
> about 15 minutes, she would get impatient when it didn't return results, and
> then just close Access. My guess is that this does not terminate Oracles
> response to the query request. She did this ten times and suddenly the temp
> tablespace is maxed out.
>
> Has anybody else experienced this problem? The only solution that we have found
> so far is to take the tablespace offline/online. Thanks. Rob

If you know that this is definitely the problem, try setting tablespace disk quotas for this user. Also have a look at the SQL. 300M is a lot of temp tablespace !

--
Hope this helps !
Regards,
Srini
(to reply via email, please change "nospam" to "chavali" in my email address -
:-)  )