Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Identifing temporary tables to SID

Identifing temporary tables to SID

From: luke.davies <luke.daviesNOluSPAM_at_centers.co.uk.invalid>
Date: 2000/04/11
Message-ID: <1c12203c.ba6b3692@usw-ex0101-007.remarq.com>#1/1

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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US