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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
