Re: Need help on temp-usage

From: Markus Korn <markus.korn_at_at.siemens.de>
Date: Thu, 10 Jun 1999 13:58:01 +0200
Message-ID: <375FA849.53382052@at.siemens.de>

you can query v$sort_usage

if you want to see the statement of this session join the sql_adr with v$sql_with_new_lines

Ivan Bajon wrote:
>
> I urgently need a way to figure out which user and which sql is causing my
> temporary tablespace to fill up. DBA_SEGMENTS show a segment which takes up
> 1GB but the owner is SYS. I think that's because the sorts or whatever is
> done by the system on behalf of the user. Is there a sure way of seeing who
> & what is the cause?
>
> Any help much appreciated. Plz reply to the NG.
Received on Thu Jun 10 1999 - 06:58:01 CDT