RE: 7.3 anyone?

Jonathan,

Your dim and distant memory is indeed correct, in dbmsutil.sql :-

create or replace package dbms_system is

• OVERVIEW
  --
  
• This package provides some system level utilities.
• SECURITY
  --
  
• This package is only accessible to user SYS by default. You can control
• access to these routines by only granting execute to privileged users.

  ---

• PROCEDURES AND FUNCTIONS
  --
  procedure set_ev(si binary_integer, se binary_integer, ev binary_integer, le binary_integer, nm varchar2);
• This is an internally used routine that should never be called by users.

  procedure read_ev(iev binary_integer, oev out binary_integer);

• This is an internally used routine that should never be called by users.
  --
  --
  procedure dist_txn_sync(inst_num number);
• This should be normally be only called by the XA library.

  procedure set_sql_trace_in_session(sid number, serial# number,

                                     sql_trace boolean);

• Enable sql_trace in the session identified by (sid, serial#). These
• value are gotten from v$session.
• Input arguments:
• sid
• session id
• serial#
• session serial number
• sql_trace
• if true then enable tracing, if false disable tracing.
  --
  end; /

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---