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

Jared..

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

Babu

----- Original Message -----
From:
OrclBabu

To: oracle-l@freelists.org
Sent: Tuesday, February 24, 2004 4:27
PM
Subject: Re: 7.3 anyone?

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

SVRMGR> select * from
v$version;BANNER----------------------------------------------------------------Oracle7
Server Release 7.3.4.5.0 with the 64-bit option - ProducPL/SQL Release
2.3.4.5.0 - ProductionCORE Version 3.5.4.0.0 - ProductionTNS for DEC
OSF/1 AXP: Version 2.3.4.0.0 - ProductionNLSRTL Version 3.2.4.0.0 -
Production5 rows selected.


Babu

----- Original Message -----
From:
Jared.Still@radisys.com
To: oracle-l@freelists.org
Sent: Tuesday, February 24, 2004 2:02
PM
Subject: Re: 7.3 anyone?
Exacly which version of
Oracle 7.x would this be from? To the best of my knowledge, doing a describe on a package
never worked this way in 7.x.
Jared

"OrclBabu" <orclbabu@hotmail.com>
Sent by: oracle-l-bounce@freelists.org

02/24/2004 08:33 AM
Please respond to oracle-l


To:        <oracle-l@freelists.org>
cc:
Subject:
Re: 7.3 anyone?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
binary_integer,
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# number,

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
indentation.end; -----
Original Message ----- From: Cary Millsap To: oracle-l@freelists.org Sent: Tuesday,
February 24, 2004 2:37 AM Subject: 7.3 anyone? Would someone with a 7.3 database mind running the following
query?
connect sys desc dbms_system exit;
Again, thanks in advance.
Cary 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
details...

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

Previous

Follow ups

Related Discussions

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

People

Translate

site design / logo © 2022 Grokbase