Re: temporary tablespace is running full

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Mon, 19 May 2003 23:22:03 +0200
Message-ID: <omiicvkv8stpaeikns8s09h7k0k6vlkcdv@4ax.com>

On Mon, 19 May 2003 23:03:53 +0200, Christian Hartmann <cha_at_christian-hartmann.de> wrote:

>Hi there,
>
>I am currently facing a little problem rgearind the
>temporary-tablespace.
>
>From time to time the temporary tablespace is running full so that no
>new extent can be allocated and I don't want to set the tablespace to
>unlimited extends due to lack of space on the device. The datafiles of
>the temporary tablespace are now 4 GB large.
>
>My question is: Can I dtermine who (user, session, sql-statement) is
>or was using the segments in the temp-tablespace? Is there a
>script/sql-statement with which I can do this? If yes, may you please
>post it....?
>
>Any help will be greatly appreciated.
>
>Thanx in advance,
>
>Christian Hartmann

Check out v$sort_usage (that is, if you are on 8i, which you didn't mention)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon May 19 2003 - 16:22:03 CDT