Re: Use of TEMP tablespace other than sorting

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 27 Feb 2003 23:56:48 +0100
Message-ID: <6j5t5v4261vpcj9tke3vr6eom63eh6phl1@4ax.com>

DA Morgan <damorgan_at_exesolutions.com> wrote:

>I'd suggest a couple of things. The first is the you run explain plan to
>see what is happening. The second is that you post the query and give us
>some idea of how many rows are in the tables. At first blush it appears
>that something is wrong. But without more background I wouldn't want to
>speculate as to what.
>
>BTW: CBO or RBO and are statistics with DBMS_STATS current?

All right, I will give you more details tomorrow, when I am at office.

I just wanted to avoid overloading you with information, but if you are willing to glance at it, I would very much appreciate your effort.

I should add that the pertinent query was running without any problem for a long time. This problem came up suddenly, presumably due to the larger number of records in the involved tables.

Bye
Rick Denoire Received on Thu Feb 27 2003 - 16:56:48 CST