From jonathan@jlcomp.demon.co.uk Wed, 08 Aug 2001 12:54:14 -0700 From: "Jonathan Lewis" Date: Wed, 08 Aug 2001 12:54:14 -0700 Subject: Re: Timed statistics and SQL_TRACE for already running session Message-ID: MIME-Version: 1.0 Content-Type: text/plain It's pure 8.1.6+ something like: dbms_system.set_bool_param(sid, serial,'parameter',true/false); I don't think there is ANYTHING sneaky you can do prior to 8.1.6; alter system is the only option for avoiding the bounce. Jonathan Lewis Seminars on getting the best out of Oracle Last few places available for Sept 10th/11th See http://www.jlcomp.demon.co.uk/seminar.html -----Original Message----- To: Multiple recipients of list ORACLE-L Date: 08 August 2001 20:38 session | |Jonathan, | |Version is 8.0.4. I looked at the parameters for dbms_system in the 8.0.4 |documentation |and saw nothing pertaining to timed_statistics. | |I did an alter system over lunch and set timed statistics for the entire |database without |bouncing the database. That did the trick. | |Thanks for taking time to reply. It's cool to correspond directly with |someone whose |book I have read. | |Cherie Machler |Oracle DBA |Gelco Information Network | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: jonathan@jlcomp.demon.co.uk 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).