Re: Who's sorting ?

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Tue, 16 Feb 1999 21:12:02 -0000
Message-ID: <919199740.22116.1.nnrp-06.9e984b29@news.demon.co.uk>

Here's a dirty trick method for Oracle 7.

Event 10032 set at the init.ora level will make Oracle dump a trace file for every sort event that takes place.

If you keep tracking the trace files as they appear you might be able to find the guilty party from the unix pid, and also see how much sorting they've actually done.

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

P.S. I've only done this for individual sessions on a production system. The trace files are quite small.

Andrew Gilkes wrote in message ...
>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 Tue Feb 16 1999 - 15:12:02 CST