RE: username

thank you very much! I read the notes and learned a lot.

Lucy

On Wed, 9 May 2001, Seley, Linda wrote:

> 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

condenet.com 212-286-3852

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Lucy Lin
  INET: llin_at_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_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).