From arun_k_c@hotmail.com Wed, 09 May 2001 13:31:07 -0700 From: "ARUN K C" Date: Wed, 09 May 2001 13:31:07 -0700 Subject: RE: username Message-ID: MIME-Version: 1.0 Content-Type: text/plain why dont you go to that view and edit that sql then it will give proper username >From: "Seley, Linda" >Reply-To: ORACLE-L@fatcity.com >To: Multiple recipients of list ORACLE-L >Subject: RE: username >Date: Wed, 09 May 2001 13:00:56 -0800 > >Lucy - > >The user column is broken in v$sort_usage in v8.1.6 and various v8.0.x. It >either always displays SYS or it displays the user that you are logged in >as >(apparently depending on the version of the DB you have). If you search >for >v$sort_usage on Metalink you will see a few related items but in particular >see notes 124298.1 and 1069041.6. > >HTH > >Linda > >-----Original Message----- >Sent: Wednesday, May 09, 2001 11:47 AM >To: Multiple recipients of list ORACLE-L > > >Hi all, >By selecting from v$sort_segment I found there is one user who is >currently use temporary TS, so I want to see who is the user by following >query: > >SQL> select USER , SESSION_ADDR, SESSION_NUM, SQLADDR , SQLHASH from >v$sort_usage; > >USER SESSION_ SESSION_NUM SQLADDR SQLHASH >------------------------------ -------- ----------- -------- ---------- >SYS 841CFFC0 60008 8043A9C0 2232545133 >then I want to find sid, osuser by runnig >SQL> select username, osuser, sid, serial# from v$session where >saddr='841CFFC0'; > >USERNAME OSUSER SID >------------------------------ ------------------------------ ---------- > SERIAL# >---------- >FORMS dervid 80 > 60008 > >my question is why the username from v$sort_usage is different from the >one from v$session. I thought they should be the same. > >Any idea is welcome. > >Thanks in advance! >-- >Lucy Lin Oracle DBA > > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Lucy Lin > INET: llin@versus.dmz.advance.net > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Seley, Linda > INET: LSeley@IQNavigator.com > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >To REMOVE yourself from this mailing list, send an E-Mail message >to: ListGuru@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). _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: arun_k_c@hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).