Re: SHOW ERRORS not working

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 become sys anyway...

Tanel.

• Original Message ----- From: "Daniel Fink" <daniel.fink_at_sun.com> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, July 22, 2003 6:04 PM Subject: Re: SHOW ERRORS not working

> 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, where USER and ALL are related to sql*plus.
>
> Pete Finnigan wrote:
> >
> > Hi Dave
> >
> > I have had the same issue before but i don't remember the answer but I
> > think i found it with either trace or SQL*Net trace.
> >
> > I think show is a keyword implemented in SQL*Plus that simply translates
> > into some SQL. Set trace on your session and on your users session and
> > use tkprof with SYS = yes to collect all SQL including ddl and see if a
> > difference is shown between your session and his, you in theory should
> > have the same SQL as him but it could indicate where the difference
> > lies. Or an alternative is to use SQL*Net trace at SUPPORT level and you
> > should see the SQL used in the packet contents.
> >
> > hope this helps
> >
> > kind regards
> >
> > Pete
> > --
> > Pete Finnigan
> > email:pete_at_petefinnigan.com
> > Web site: http://www.petefinnigan.com - Oracle security audit
specialists
> > Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Pete Finnigan
> > INET: oracle_list_at_peterfinnigan.demon.co.uk
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
Received on Tue Jul 22 2003 - 10:53:49 CDT