Sorry, no 5.x or 6.x ;)
|
| Mercadante, Thomas F <thomas.mercadante@labor.state.ny.us>
Sent by: oracle-l-bounce@freelists.org
02/24/2004 04:51 AM
Please respond to oracle-l
|
To: 'oracle-l@freelists.org' <oracle-l@freelists.org>
cc:
Subject: RE: 7.3 anyone? |
God Jared.
Any other db versions you got lying around? You went from 10g to 7.3 in an
eyeblink!
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
From: Jared Still [mailto:jkstill@cybcon.com]
Sent: Tuesday, February 24, 2004 3:16 AM
To: Oracle-L Freelists
Cc: Cary Millsap
Subject: Re: 7.3 anyone?
Isn't it bedtime in Dallas?
desc dbms_system does not work in 7.3
00:08:44 - sys@ SQL> desc dbms_system
SP2-0581: Object dbms_system is a package; use 'DESCRIBE
<package>.<procedure>'
00:08:46 - sys@ SQL>
However, this does:
1 select line,text from dba_source
2* where name = 'DBMS_SYSTEM' and type = 'PACKAGE'
00:08:13 - sys@ SQL> /
LINE TEXT
---------- --------------------------------------------------
1 package dbms_system is
2 ------------
3 -- OVERVIEW
4 --
5 -- This package provides some system level util
ities.
6
7 -- SECURITY
8 --
9 -- This package is only accessible to user SYS
by default. You can control
10 -- access to these routines by only granting ex
ecute to privileged users.
11
12 ----------------------------
13 -- PROCEDURES AND FUNCTIONS
14 --
15 procedure set_ev(si binary_integer, se binary_in
teger,
16 ev binary_integer, le binary_integer,
nm varchar2);
17 -- This is an internally used routine that shou
ld never be called by users.
18
19 procedure read_ev(iev binary_integer, oev out bi
nary_integer);
20 -- This is an internally used routine that shou
ld never be called by users.
21 --
LINE TEXT
---------- --------------------------------------------------
22 --
23 procedure dist_txn_sync(inst_num number);
24 -- This should be normally be only called by th
e XA library.
25
26 procedure set_sql_trace_in_session(sid number, s
erial# number,
27 sql_trace boolean);
28 -- Enable sql_trace in the session identified b
y (sid, serial#). These
29 -- value are gotten from v$session.
30 -- Input arguments:
31 -- sid
32 -- session id
33 -- serial#
34 -- session serial number
35 -- sql_trace
36 -- if true then enable tracing, if false di
sable tracing.
37 --
38
39 procedure ksdwrt(dest in binary_integer, tst in
varchar2);
40 -- Print the given string out to the trace file.
41 -- Input arguments
42 -- dest - destination of the output (Alert file
or Trace file or both)
43 -- for specifying both, the value of dest
should be
LINE TEXT
---------- --------------------------------------------------
44 -- trace_file+alert_file
45 -- tst - Trace string to print.
46
47 procedure ksdfls;
48 -- flush the output written to trace file.
49
50 procedure ksdddt;
51 -- Dump date and time information to trace file
52
53 procedure ksdind(lvl in binary_integer);
54 -- Set the indentation level for the further out
put to trace file.
55 -- Level - the level of indentation.
56 end;
56 rows selected.
Jared
On Mon, 2004-02-23 at 23:37, Cary Millsap wrote:
> Would someone with a 7.3 database mind running the following query?
>
>
>
> connect sys
>
> desc dbms_system
>
> exit;
>
>
>
> Again, thanks in advance.
>
>
>
> Cary Millsap
> Hotsos Enterprises, Ltd.
> http://www.hotsos.com
> Nullius in verba
>
> Upcoming 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@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
-----------------------------------------------------------------
----------------------------------------------------------------
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
-----------------------------------------------------------------
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
-----------------------------------------------------------------
Received on Tue Feb 24 2004 - 12:58:21 CST
