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 ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 6:04 PM > 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:[EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
