From treegarden@yahoo.com Mon, 19 Nov 2001 09:49:46 -0800 From: Paul Baumgartel Date: Mon, 19 Nov 2001 09:49:46 -0800 Subject: RE: set_sql_trace_in_session Message-ID: MIME-Version: 1.0 Content-Type: text/plain Thanks. I'm looking at the online version of that manual, same part number, and DBMS_SYSTEM doesn't even appear on the list of packages: 52 DBMS_STATS Using DBMS_STATS Types Summary of Subprograms Setting or Getting Statistics PREPARE_COLUMN_VALUES Procedure SET_COLUMN_STATS Procedure SET_INDEX_STATS Procedure SET_TABLE_STATS Procedure CONVERT_RAW_VALUE Procedure GET_COLUMN_STATS Procedure GET_INDEX_STATS Procedure GET_TABLE_STATS Procedure DELETE_COLUMN_STATS Procedure DELETE_INDEX_STATS Procedure DELETE_TABLE_STATS Procedure DELETE_SCHEMA_STATS Procedure DELETE_DATABASE_STATS Procedure Transferring Statistics CREATE_STAT_TABLE Procedure DROP_STAT_TABLE Procedure EXPORT_COLUMN_STATS Procedure EXPORT_INDEX_STATS Procedure EXPORT_TABLE_STATS Procedure EXPORT_SCHEMA_STATS Procedure EXPORT_DATABASE_STATS Procedure IMPORT_COLUMN_STATS Procedure IMPORT_INDEX_STATS Procedure IMPORT_TABLE_STATS Procedure IMPORT_SCHEMA_STATS Procedure IMPORT_DATABASE_STATS Procedure Gathering Optimizer Statistics GATHER_INDEX_STATS Procedure GATHER_TABLE_STATS Procedure GATHER_SCHEMA_STATS Procedure GATHER_DATABASE_STATS Procedure GENERATE_STATS Procedure Example 53 DBMS_TRACE Do you find it in the printed manual? --- Hallas John wrote: > 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 > To: Multiple recipients of list ORACLE-L > > > 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 se! ! ssion? > > __________________________________________________ > Do You Yahoo!? > Find the one for you at Yahoo! Personals > http://personals.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Paul Baumgartel > INET: treegarden@yahoo.com > > 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). > > >! ! ********************************************************************** > This email and any attachments may be confidential and the subject of > legal professional privilege. Any disclosure, use, storage or > copying > of this email without the consent of the sender is strictly > prohibited. > Please notify the sender immediately if you are not the intended > recipient and then delete the email from your inbox and do not > disclose the contents to another person, use, copy or store the > information in any medium. > ********************************************************************** > > Do You Yahoo!? Find the one for you at Yahoo! Personals.