From oracle-l-bounce@freelists.org Tue Feb 24 12:58:21 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OIwLH22732 for ; Tue, 24 Feb 2004 12:58:21 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1OIwLo22727 for ; Tue, 24 Feb 2004 12:58:21 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 99ACA395B88; Tue, 24 Feb 2004 13:59:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 13:58:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mx10.radisys.com (mx10.radisys.com [206.102.10.36]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 78F3E394B5C for ; Tue, 24 Feb 2004 13:58:26 -0500 (EST) Received: by mx10.radisys.com (Postfix, from userid 5) id 0B549142E45; Tue, 24 Feb 2004 11:01:00 -0800 (PST) Received: from UNKNOWN(206.103.52.194), claiming to be "dcblackberry.radisys.com" via SMTP by mx10, id smtpdAAAhaZCG_; Tue Feb 24 11:00:59 2004 To: oracle-l@freelists.org Subject: RE: 7.3 anyone? MIME-Version: 1.0 X-Mailer: Lotus Notes Release 5.0.10 March 22, 2002 Message-ID: From: Jared.Still@radisys.com Date: Tue, 24 Feb 2004 11:00:57 -0800 X-MIMETrack: Serialize by Router on DCBlackBerry/Radisys_Corporation/US(Release 5.0.12 |February 13, 2003) at 02/24/2004 10:58:13 AM, Serialize complete at 02/24/2004 10:58:13 AM Content-Type: multipart/alternative; boundary="=_alternative 006860FC88256E44_=" X-archive-position: 1770 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jared.Still@radisys.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l --=_alternative 006860FC88256E44_= Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Sorry, no 5.x or 6.x   ;)


Mercadante, Thomas F <thomas.m= ercadante@labor.state.ny.us>
Sent by: oracle-l-bounce@freelists.o= rg

 02/24/2004 04:51 AM
 Please respond to oracle-l

       
        To: &nbs= p;      'oracle-l@freelists.org' <oracle-l@freelists.org&= gt;
        cc: &nbs= p;      
        Subject:=        RE: 7.3 anyone?



God Jared.

Any other db versions you got lying around?  You went from 10g to 7.3 = in an
eyeblink!

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Jared Still [mailto:jkstill@cybcon.com]
Sent: Tuesday, February 24, 2004 3:16 AM
To: Oracle-L Freelists
Cc: Cary Millsap
Subject: Re: 7.3 anyone?


Isn't it bedtime in Dallas?

desc dbms=5Fsystem does not work in 7.3


00:08:44  - sys@ SQL> desc dbms=5Fsystem
SP2-0581: Object dbms=5Fsystem is a package; use 'DESCRIBE
<package>.<procedure>'
00:08:46  - sys@ SQL>


However, this does:

1  select line,text from dba=5Fsource
 2* where name =3D 'DBMS=5FSYSTEM' and type =3D 'PACKAGE'
00:08:13  - sys@ SQL> /

     LINE TEXT
---------- --------------------------------------------------
        1 package dbms=5Fsystem is
        2   ------------
        3   --  OVERVIEW
        4   --
        5   --  This package provides some s= ystem level util
          ities.

        6
        7   --  SECURITY
        8   --
        9   --  This package is only accessi= ble 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=5Fev(si binary=5Fintege= r, se binary=5Fin
          teger,

       16             &n= bsp;   ev binary=5Finteger, le binary=5Finteger,
          nm varchar2);

       17   --  This is an internally used r= outine that shou
          ld never be called by users.

       18
       19   procedure read=5Fev(iev binary=5Finte= ger, oev out bi
          nary=5Finteger);

       20   --  This is an internally used r= outine that shou
          ld never be called by users.

       21   --

     LINE TEXT
---------- --------------------------------------------------
       22   --
       23   procedure dist=5Ftxn=5Fsync(inst=5Fnu= m number);
       24   --  This should be normally be o= nly called by th
          e XA library.

       25
       26   procedure set=5Fsql=5Ftrace=5Fin=5Fse= ssion(sid number, s
          erial# number,

       27             &n= bsp;                     = sql=5Ftrace boolean);
       28   --  Enable sql=5Ftrace in the se= ssion identified b
          y (sid, serial#).  These

       29   --  value are gotten from v$sess= ion.
       30   --  Input arguments:
       31   --   sid
       32   --   session id
       33   --   serial#
       34   --      session serial= number
       35   --  sql=5Ftrace
       36   --      if true then e= nable tracing, if false di
          sable tracing.

       37   --
       38
       39   procedure ksdwrt(dest in binary=5Fint= eger, 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 spe= cifying both, the value of dest
           should be

     LINE TEXT
---------- --------------------------------------------------

       44   --        trace= =5Ffile+alert=5Ffile
       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=5Finte= ger);
       54   -- Set the indentation level for the = further out
          put to trace file.

       55   -- Level - the level of indentation.<= br>        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=5Fsystem
>
> 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@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@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
-----------------------------------------------------------------

--=_alternative 006860FC88256E44_=-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------