Re: TEMP tablespace problem

Have seen this problem with an excel app using DAO.

DAO was causing large internal sorts to take place, which clobbered the temp segment.
All sorts of queries cause a sort e.g. select distinct, group by etc and DAO was making things worse.
Try and trace the SQL activity e.g. using odbc trace.

An option is to create a specific large temp segment for the user running the access query but best to solve the problem rather than the symptom.

RobW95 wrote in message <19980127234701.SAA03619_at_ladder03.news.aol.com>...
>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
Received on Fri Jan 30 1998 - 00:00:00 CST