It would seem that dbms_system has become undocumented. It used to be partially documented, e.g. there was a description of set_sql_trace_in_session, but they seem to have pulled that as of 8.1. You're supposed to use dbms_support now, but that too seems to be undocumented.
At least on Solaris, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] > Sent: Friday, July 25, 2003 1:20 PM > To: Multiple recipients of list ORACLE-L > Subject: dbms_job > > > Hello list, > I am running 9.2.0.1.0 enterprise edition on win32. > Why doesn't the "Supplied PLSQL Packages and Types Reference" > docs mention > dbms_system ? > It doesn't seem to be explained anywhere in the docs although > the admin > docs say that it can be used enable sql_trace for another session. > I was able to do that only after learning about its parameters thru : > sql> describe dbms_system > while I was logged in as sysdba. > .................. > > LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
