Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Setting event 10032
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
![]() |
![]() |