| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: 7.3 anyone?
No you're not. I'm a left coaster - well compared to you anyway. Connor can take the title from me.
Pete
"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook
"Oh no, it's not. It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Cary Millsap
Sent: Tuesday, February 24, 2004 7:20 PM
To: oracle-l_at_freelists.org
Subject: RE: 7.3 anyone?
Hey, I'm a "left-coaster" for the night. I'm in San Diego to teach PD101 tomorrow morning.
Thanks for the response!
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...
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: Tuesday, February 24, 2004 2: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...
>
>
>
>
-- 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 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 - 09:46:10 CST
 |
 |