Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Need help on temp-usage
Yes, I'd do that if only I ran Oracle8. I forgot to mention that I run
Oracle7.3.4
Markus Korn wrote in message <375FA849.53382052_at_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 - 08:14:47 CDT