RE: set_sql_trace_in

From: Paul Baumgartel <treegarden_at_yahoo.com>
Date: Mon, 19 Nov 2001 09:49:46 -0800
Message-ID: <F001.003C88BE.20011119082518@fatcity.com>

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 <John.Hallas@btcellnet.net> 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 <a href="http://rd.yahoo.com/mktg/mail/txt/tagline/?http://personals.yahoo.com" target="_blank">Yahoo! Personals.

Received on Mon Nov 19 2001 - 11:49:46 CST

RE: set_sql_trace_in_session