RE: Setting event 10032

From: Reardon, Bruce (CALBBAY) <Bruce.Reardon_at_comalco.riotinto.com.au>
Date: Wed, 11 Jul 2001 00:47:21 -0700
Message-ID: <F001.003468DD.20010710235044@fatcity.com>

Hi,

1 way to do this (for the current session) is to use in SQL Plus:

alter session set events '10032 trace name context forever, level 1';

To do for another session you could use dbms_system.set_ev or oradebug. You could set if for all sessions by setting it in the init.ora file

I would recommend trying this in a test system first and use the first alter session in preference.

Regards,
Bruce Reardon

-----Original Message-----
Sent: Wednesday, 11 July 2001 3:45
To: Multiple recipients of list ORACLE-L

hi all,
this is an excerpt from Steve Adams site http://www.ixora.com.au/newsletter/2000_12.htm First you need to determine the largest disk sort that is performed by the batch process. This can be done by setting event 10032 at level 1 in the session and then examining the process trace file.  

I wanted to know how to set the event at level  

I use
8.1.5,8.1.6,8.1.7 on Windows NT 4.0
8.1.6,8.1.7 on RedHat Linux 7.0  

thanks in advance  

coz
I am a
novice
Oracle Certifiable DBBS  

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Reardon, Bruce (CALBBAY)
  INET: Bruce.Reardon_at_comalco.riotinto.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Jul 11 2001 - 02:47:21 CDT