From oracle-l-bounce@freelists.org Tue Feb 24 15:25:42 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OLPg524806 for ; Tue, 24 Feb 2004 15:25:42 -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 i1OLPco24790 for ; Tue, 24 Feb 2004 15:25:38 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC5F3394E47; Tue, 24 Feb 2004 16:26:46 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 16:25:25 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from hotmail.com (law10-oe66.law10.hotmail.com [64.4.14.201]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 409A5394BEE for ; Tue, 24 Feb 2004 16:25:07 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 24 Feb 2004 13:27:31 -0800 Received: from 192.158.61.142 by law10-oe66.law10.hotmail.com with DAV; Tue, 24 Feb 2004 21:27:29 +0000 X-Originating-IP: [192.158.61.142] X-Originating-Email: [orclbabu@hotmail.com] X-Sender: orclbabu@hotmail.com From: "OrclBabu" To: References: Subject: Re: 7.3 anyone? Date: Tue, 24 Feb 2004 16:27:29 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0231_01C3FAF3.18CE3530" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: X-OriginalArrivalTime: 24 Feb 2004 21:27:31.0174 (UTC) FILETIME=[028A3060:01C3FB1D] X-archive-position: 1803 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: orclbabu@hotmail.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_0231_01C3FAF3.18CE3530 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Its from a 7.3.4.. We may have the = turbo patch on=20 ;-)

SVRMGR> select * from=20 v$version;
BANNER
-------------------------------------------------= ---------------
Oracle7=20 Server Release 7.3.4.5.0 with the 64-bit option - Produc
PL/SQL = Release=20 2.3.4.5.0 - Production
CORE Version 3.5.4.0.0 - Production
TNS for = DEC=20 OSF/1 AXP: Version 2.3.4.0.0 - Production
NLSRTL Version 3.2.4.0.0 -=20 Production
5 rows selected.

Babu

----- Original Message -----
From:=20 Jared.Still@radisys.com =
To: oracle-l@freelists.org =

Sent: Tuesday, February 24, = 2004 2:02=20 PM

Subject: Re: 7.3 anyone?

Exacly which = version of Oracle=20 7.x would this be from?

To the=20 best of my knowledge, doing a describe on a package
never worked this way in 7.x. =

Jared

"OrclBabu" <orclbabu@hotmail.com>=20
Sent by: oracle-l-bounce@freelists.o= rg=20
02/24/2004 08:33 = AM=20
Please respond to oracle-l
=
To: = =20 <oracle-l@freelists.org>=20
= cc: =20
=20 Subject: Re: 7.3 = anyone?

SVRMGR> connect internal
Connected.
SVRMGR> desc=20 dbms_system
package dbms_system = is
------------
--=20 OVERVIEW
--
-- This package provides = some system=20 level utilities.
=20
-- = SECURITY
--
--=20 This package is only accessible to user SYS by default. = You can=20 control
-- access to these routines by only granting = execute to=20 privileged users.
=20
= ----------------------------
--=20 PROCEDURES AND FUNCTIONS
--
procedure = set_ev(si=20 binary_integer, se binary_integer,
= =20 ev binary_integer, le binary_integer, nm=20 varchar2);
-- This is an internally used routine that = should=20 never be called by users.

= procedure read_ev(iev=20 binary_integer, oev out binary_integer);
-- This is an=20 internally used routine that should never be called by=20 users.
--
--
procedure = dist_txn_sync(inst_num=20 number);
-- This should be normally be only called by = the XA=20 library.
=20
procedure = set_sql_trace_in_session(sid=20 number, serial# number,
= =20 = =20 sql_trace boolean);
-- Enable sql_trace in the session=20 identified by (sid, serial#). These

=20 -- value are gotten from v$session.
-- Input=20 arguments:
-- sid
-- = session=20 id
-- serial#
-- session = serial=20 number
-- sql_trace
-- if = true=20 then enable tracing, if false disable tracing.
-- =

=20 procedure ksdwrt(dest in binary_integer, tst in varchar2);
-- = Print=20 the given string out to the trace file.
-- Input=20 arguments
-- dest - destination of the output (Alert file or = Trace=20 file or both)
-- for specifying = both, the=20 value of dest should be
-- =20 trace_file+alert_file
-- tst - Trace string to = print.=20

procedure ksdfls;
-- flush the output written = to trace=20 file.
=
procedure ksdddt;
-- Dump date = and time=20 information to trace file

= procedure ksdind(lvl=20 in binary_integer);
-- Set the indentation level for the = further=20 output to trace file.
-- Level - the level of=20 indentation.
end;
-----=20 Original Message -----
From: Cary = Millsap
To: oracle-l@freelists.org
Sent: Tuesday,=20 February 24, 2004 2:37 AM
Subject: 7.3 anyone?

Would someone with a 7.3 database mind running the following=20 query?

connect sys
desc=20 dbms_system
exit; =

Again,=20 thanks in advance.
=20
Cary Millsap
Hotsos = Enterprises,=20 Ltd.
http://www.hotsos.com
Nullius in verba

Upcoming events:
- = Performance Diagnosis 101:=20 2/24 San Diego, 3/23 Park City, 4/6 Seattle
- Hotsos Symposium 2004: March=20 7=9610 Dallas
- Visit www.hotsos.com for schedule details...

------=_NextPart_000_0231_01C3FAF3.18CE3530-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------