From oracle-l-bounce@freelists.org Tue Feb 24 10:32:06 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1OGW6W27704 for ; Tue, 24 Feb 2004 10:32:06 -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 i1OGW5o27695 for ; Tue, 24 Feb 2004 10:32:05 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2E269395932; Tue, 24 Feb 2004 11:33:37 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 24 Feb 2004 11:32:28 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from hotmail.com (law10-oe36.law10.hotmail.com [64.4.14.93]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 33789395393 for ; Tue, 24 Feb 2004 11:32:22 -0500 (EST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 24 Feb 2004 08:34:58 -0800 Received: from 192.158.61.142 by law10-oe36.law10.hotmail.com with DAV; Tue, 24 Feb 2004 16:34:58 +0000 X-Originating-IP: [192.158.61.142] X-Originating-Email: [orclbabu@hotmail.com] X-Sender: orclbabu@hotmail.com From: "OrclBabu" To: References: <002c01c3faa9$12a1da80$d06a8640@CVMLAP02> Subject: Re: 7.3 anyone? Date: Tue, 24 Feb 2004 11:33:28 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0063_01C3FACA.05F47330" 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 16:34:58.0423 (UTC) FILETIME=[2448F070:01C3FAF4] X-archive-position: 1736 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_0063_01C3FACA.05F47330 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

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

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

procedure read_ev(iev = binary_integer, oev=20 out binary_integer);
-- This is an internally used = routine that=20 should never be called by users.
--
--
= procedure=20 dist_txn_sync(inst_num number);
-- This should be = normally be=20 only called by the XA library.

procedure = set_sql_trace_in_session(sid=20 number, serial#=20 number,
&n= bsp; &nb= sp; &nbs= p; =20 sql_trace boolean);
-- Enable sql_trace in the session=20 identified by (sid, serial#). These

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

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

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

procedure ksdddt;
-- = Dump date and=20 time information to trace file

procedure ksdind(lvl in=20 binary_integer);
-- Set the indentation level for the further = output=20 to trace file.
-- Level - the level of=20 indentation.
end;

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

Sent: Tuesday, February 24, = 2004 2:37=20 AM

Subject: 7.3 anyone?

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

connect = sys

desc = dbms_system

exit;

Again, thanks in=20 advance.

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

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

------=_NextPart_000_0063_01C3FACA.05F47330-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------