Re: Q How to find owner using tablespace temp

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Jan 1999 18:16:51 -0000
Message-ID: <916942550.11251.0.nnrp-09.9e984b29@news.demon.co.uk>

If you are running Oracle 8, then there is a new internal monitor view called v$sort_usage which gives you the real time usage of TEMP

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

>> Roman Starek <starek_at_pluto.spsselib.hiedu.cz> wrote:
>> >
>> > I have problem with growing up tablespace temp. Is there any
>> > way to find out which user is using tablespace temp ?
Received on Thu Jan 21 1999 - 12:16:51 CST