SHOW PARAMETER performs a 'FIXED TABLE FULL' scan of x$ksppi and x$ksppcv. Exactly
what I would expect.
SHOW USER did not show up in the trace file, which tells me it is internal code path.
SHOW ALL did the same. I think that the difference is that PARAMETERs are database
level information,
Hi!
Yep, show user for example doesn't even generate any sqlnet traffic to
server. The username is retrieved by sqlplus once during logon using select
user from dual query.
One small detail is that when connecting as sysdba, no select user from
dual query is executed during logon, because you'll
Have him try SHOW ERRORS PROCEDURE proc. name
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent: Monday, July 21, 2003 11:45 AM
To: Multiple recipients of list ORACLE-L
I have a developer that has ALTER ANY PROCEDURE rights. He changes a
Title: RE: SHOW ERRORS not working
select grant on all_errors ??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
Not sure, what causes the problem.
But, probably a workaround is to grant him rights to select from
dba_errors.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
-Original Message-
Farnsworth, Dave
Sent: Monday, July 21, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
I have a developer
Not sure how SHOW ERRORS is implemented in SQLPlus, but it may only be
looking at USER_ERRORS intead of ALL_ERRORS. So if your developer is
altering another schema's procedure (via the alter ANY procedure privilege)
those errors will not show up in his USER_ERRORS.
BTW, this is just my guess on
This used to get me all the time. I'm pretty sure you need to issue
SET SERVEROUTPUT ON;
to see the output.
Ciao
Fuzzy
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Farnsworth, Dave
Sent: Monday, July 21, 2003 16:45
To: Multiple recipients
Dave,
Is the procedure owner the developer? If there are errors then they
would show up in user_errors other wise the errors are owned by the
owner of the procedure. Check the grants on the different xxx_error
tables and grant accordingly.
Ron
[EMAIL PROTECTED] 07/21/03 11:44AM
I have a
ORACLE-L [EMAIL PROTECTED]
Subject: RE: SHOW ERRORS not working
This used to get me all the time. I'm pretty sure you need to issue
SET SERVEROUTPUT ON;
to see the output.
Ciao
Fuzzy
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf
on user_errors etc. are on the right track.
Ciao
Fuzzy
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
[EMAIL PROTECTED]
Sent: Monday, July 21, 2003 17:44
To: Multiple recipients of list ORACLE-L
Subject: Re: RE: SHOW ERRORS not working
you sure
I don't think SHOW is a function that you will find in any of the Oracle db creation
scripts. It is most likely part of the sql*plus program. The keyword SHOW can be used
for a lot of things (USER and PARAMETER come to mind). Obviously, it reads some data
structures, but I am sure it is not a
11 matches
Mail list logo