Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> USER SESSION & TEMPORARY SEGMENT
Hi,
A temporary segment is created by SYS when a sort is performed.
Does anyone know a way to determine the SQL statement and the user session (SID in v$session) that correspond to the temporary segment?
TIA
-- Naren ChintalaReceived on Tue Mar 11 1997 - 00:00:00 CST