From oracle-l-bounce@freelists.org Tue Feb 24 15:28:09 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OLS9n25182 for ; Tue, 24 Feb 2004 15:28:09 -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 i1OLS6o25175 for ; Tue, 24 Feb 2004 15:28:06 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 906323957BC; Tue, 24 Feb 2004 16:28:52 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 16:27:31 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from hotmail.com (law10-oe24.law10.hotmail.com [64.4.14.81]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 74B6A395680 for ; Tue, 24 Feb 2004 16:27:25 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 24 Feb 2004 13:30:03 -0800 Received: from 192.158.61.142 by law10-oe24.law10.hotmail.com with DAV; Tue, 24 Feb 2004 21:30:02 +0000 X-Originating-IP: [192.158.61.142] X-Originating-Email: [orclbabu@hotmail.com] X-Sender: orclbabu@hotmail.com From: "OrclBabu" To: Subject: Re: 7.3 anyone? Date: Tue, 24 Feb 2004 16:30:02 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0248_01C3FAF3.73E8F630" 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:30:03.0059 (UTC) FILETIME=[5D120030:01C3FB1D] X-archive-position: 1805 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_0248_01C3FAF3.73E8F630 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Jared..

Thinking abt it - try it from SVRMGRL = instead of=20 SQLPlus...

Babu

----- Original Message -----
From:=20 OrclBabu=20
To: oracle-l@freelists.org =

Sent: Tuesday, February 24, = 2004 4:27=20 PM

Subject: Re: 7.3 anyone?

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=20 Oracle 7.x would this be from?

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

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
=20
= =20 To: <oracle-l@freelists.org>=20
= cc:=20
Subject: = =20 Re: 7.3 = anyone?

SVRMGR> connect = internal
Connected.
SVRMGR>=20 desc dbms_system
package dbms_system = is
------------
--=20 OVERVIEW
--
-- This package provides = some=20 system level utilities.

--=20 SECURITY
--
-- This package is only = accessible=20 to user SYS by default. You can control
-- = access to=20 these routines by only granting execute to privileged users.=20

----------------------------
-- = PROCEDURES AND=20 FUNCTIONS
--
procedure set_ev(si binary_integer, = se=20 binary_integer,
= =20 ev binary_integer, le binary_integer, nm = varchar2);
--=20 This is an internally used routine that should never be called = by=20 users.
=20
procedure read_ev(iev = binary_integer, oev=20 out binary_integer);
-- This is an internally used = routine=20 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

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

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

= procedure=20 ksdfls;
-- flush the output written to trace file. =

procedure ksdddt;
-- Dump date and time = information=20 to trace file
=20
procedure ksdind(lvl in=20 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?
=20
connect sys
desc dbms_system
exit;=20

Again, 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 7=9610 Dallas
- Visit www.hotsos.com for schedule=20 details...
=20

------=_NextPart_000_0248_01C3FAF3.73E8F630-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------