Re: Identifing temporary tables to SID

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: 2000/04/11
Message-ID: <38F3290D.63FF@yahoo.com>#1/1

luke.davies wrote:
>
> Hello
>
> Is there any way to identify specific temporary table ids with
> the SID that is running it.
> i.e.
>
> In DBA_SEGMENTS I have a temporary segment name of 3.124995
> amongst others. I want to know the SID that is creating this
> temporary table.
>
> I hope that makes sense.
>
> TIA
>
> Luke
>
> * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network *
> The fastest and easiest way to search and participate in Usenet - Free!

You may get some joy from v$sort_segment and v$sort_usage

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk

We are born naked, wet and hungry...then things get worse

Received on Tue Apr 11 2000 - 00:00:00 CDT