RE: 7.3 anyone?

From: Cary Millsap <cary.millsap_at_hotsos.com>
Date: Tue, 24 Feb 2004 02:19:42 -0600
Message-ID: <003601c3faae$f4a407f0$d06a8640@CVMLAP02>

Hey, I'm a "left-coaster" for the night. I'm in San Diego to teach PD101 tomorrow morning.

Thanks for the response!

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...

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still Sent: Tuesday, February 24, 2004 2:16 AM To: Oracle-L Freelists
Cc: Cary Millsap
Subject: Re: 7.3 anyone?

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_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
-----------------------------------------------------------------

----------------------------------------------------------------
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
-----------------------------------------------------------------

Received on Tue Feb 24 2004 - 02:18:48 CST