Re: Need help on temp-usage

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 10 Jun 1999 18:21:41 +0100
Message-ID: <929036042.2129.0.nnrp-03.9e984b29@news.demon.co.uk>

There is a script on my website that allows you to identify owners of current sort segments.

A trick that may help if you miss the actual sort is to look at v$sql, columns

executions, sorts, disk_reads_buffer_gets, rows_processed and sql_text
where sorts > 0

You may be able to deduce the most likely candidates for the quantity of I/O done and rows-processed. The first_load_time and parsing user may then tell you who owns the problem,

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Ivan Bajon wrote in message <7jo0ce$3sr$1_at_news.inet.tele.dk>...
>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 - 12:21:41 CDT