<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

@page Section1 {size: 8.5in 11.0in; margin: 1.0in 1.25in 1.0in 1.25in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
A:link {
COLOR: blue; TEXT-DECORATION: underline
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
A:visited {
COLOR: purple; TEXT-DECORATION: underline
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman"
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
DIV.Section1 {
page: Section1

SVRMGR> connect
internalConnected.SVRMGR> desc dbms_systempackage dbms_system
is  ------------  --  OVERVIEW  --
--  This package provides some system level utilities.

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

--  PROCEDURES AND FUNCTIONS  --  procedure set_ev(si
binary_integer, se
ev binary_integer, le binary_integer, nm varchar2);  --  This is
an internally used routine that should never be called by users.

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

procedure set_sql_trace_in_session(sid
number, serial#
sql_trace boolean);  --  Enable sql_trace in the session
identified by (sid, serial#).  These

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

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

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

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

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

----- Original Message -----
To: oracle-l@freelists.org
Sent: Tuesday, February 24, 2004 2:37
Subject: 7.3 anyone?

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

connect sys
desc dbms_system

Again, thanks in

MillsapHotsos Enterprises, Ltd.http://www.hotsos.comNullius in
verbaUpcoming 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

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

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 12 of 18 | next ›
Discussion Overview
grouporacle-l @
postedFeb 24, '04 at 1:36a
activeFeb 24, '04 at 4:16p



site design / logo © 2022 Grokbase