From Bruce.Reardon@comalco.riotinto.com.au Mon, 19 Nov 2001 16:14:55 -0800 From: "Reardon, Bruce (CALBBAY)" Date: Mon, 19 Nov 2001 16:14:55 -0800 Subject: RE: set_sql_trace_in_session Message-ID: MIME-Version: 1.0 Content-Type: text/plain Steve, How about writing a PL SQL cursor to loop through all dedicated connections and then for each Sid, to use: SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(v_sid, v_serial, TRUE); Do a similar thing to turn it off. Bruce Reardon -----Original Message----- Sent: Tuesday, 20 November 2001 10:25 On a similar note, I'm looking for a way to toggle trace system-wide. Changing the init.ora sql_trace parameter is not an option since it requires recycling the database. Any way to turn sql trace on for a few hours and then turn it back off? Steve Orr -----Original Message----- Sent: Monday, November 19, 2001 8:36 AM It is in the 8.1.6 documentation I have just looked at (Oracle8i Supplied PL/SQL Packages Reference Release 2 (8.1.6) A76936-01 However I have a page on my website which shows how to put various bits of tracing on try http://www.hcresources.co.uk for the home page or http://www.hcresources.f2s.com/trace.htm to go direct. John -----Original Message----- Sent: 19 November 2001 15:05 DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION isn't documented in the 8.1.6/7 doc sets. The package (and the procedure) exists, though even the package spec source code is wrapped. What gives? Is this package about to be desupported? Is there an alternative way of setting trace on in another session? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: Bruce.Reardon@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@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).