Isn't it bedtime in Dallas? desc dbms_system does not work in 7.3 00:08:44 - sys@ SQL> desc dbms_system SP2-0581: Object dbms_system is a package; use 'DESCRIBE <package>.<procedure>' 00:08:46 - sys@ SQL> However, this does: 1 select line,text from dba_source 2* where name = 'DBMS_SYSTEM' and type = 'PACKAGE' 00:08:13 - sys@ SQL> / LINE TEXT ---------- -------------------------------------------------- 1 package dbms_system is 2 ------------ 3 -- OVERVIEW 4 -- 5 -- This package provides some system level util ities. 6 7 -- SECURITY 8 -- 9 -- This package is only accessible to user SYS by default. You can control 10 -- access to these routines by only granting ex ecute to privileged users. 11 12 ---------------------------- 13 -- PROCEDURES AND FUNCTIONS 14 -- 15 procedure set_ev(si binary_integer, se binary_in teger, 16 ev binary_integer, le binary_integer, nm varchar2); 17 -- This is an internally used routine that shou ld never be called by users. 18 19 procedure read_ev(iev binary_integer, oev out bi nary_integer); 20 -- This is an internally used routine that shou ld never be called by users. 21 -- LINE TEXT ---------- -------------------------------------------------- 22 -- 23 procedure dist_txn_sync(inst_num number); 24 -- This should be normally be only called by th e XA library. 25 26 procedure set_sql_trace_in_session(sid number, s erial# number, 27 sql_trace boolean); 28 -- Enable sql_trace in the session identified b y (sid, serial#). These 29 -- value are gotten from v$session. 30 -- Input arguments: 31 -- sid 32 -- session id 33 -- serial# 34 -- session serial number 35 -- sql_trace 36 -- if true then enable tracing, if false di sable tracing. 37 -- 38 39 procedure ksdwrt(dest in binary_integer, tst in varchar2); 40 -- Print the given string out to the trace file. 41 -- Input arguments 42 -- dest - destination of the output (Alert file or Trace file or both) 43 -- for specifying both, the value of dest should be LINE TEXT ---------- -------------------------------------------------- 44 -- trace_file+alert_file 45 -- tst - Trace string to print. 46 47 procedure ksdfls; 48 -- flush the output written to trace file. 49 50 procedure ksdddt; 51 -- Dump date and time information to trace file 52 53 procedure ksdind(lvl in binary_integer); 54 -- Set the indentation level for the further out put to trace file. 55 -- Level - the level of indentation. 56 end; 56 rows selected. Jared On Mon, 2004-02-23 at 23:37, Cary Millsap wrote: > Would someone with a 7.3 database mind running the following query? > > > > connect sys > > desc dbms_system > > exit; > > > > Again, thanks in advance. > > > > Cary Millsap > Hotsos Enterprises, Ltd. > http://www.hotsos.com > Nullius in verba > > Upcoming events: > - Performance Diagnosis 101: 2/24 San Diego, 3/23 Park City, 4/6 > Seattle > - Hotsos Symposium 2004: March 7–10 Dallas > - Visit www.hotsos.com for schedule details... > > > > ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------