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 -> Who's sorting ?

Who's sorting ?

From: Andrew Gilkes <andyg_at_kalamazoo.co.uk>
Date: Mon, 15 Feb 1999 14:45:07 -0000
Message-ID: <c0g9a7.duk.ln@betanews.int.kalamazoo.co.uk>


Occassionally we have a session that does a lot of sorting. We see this as a large drop in the free space of the Sort tablespace (TMP). What I would like to know is, how can you determine which user is using which sort segment and hence, which user is performing the large sort ?

We are currently using Oracle 7.3.4.2 on NCR 03.02 --
Andrew Gilkes
Sr. Technical Support Specialist
Kalamazoo PLC
Andrew.Gilkes_at_NOTkalamazoo.co.uk <-- to reply, remove the obvious Received on Mon Feb 15 1999 - 08:45:07 CST

Original text of this message

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