RE: username

From: Seley, Linda <LSeley_at_IQNavigator.com>
Date: Wed, 09 May 2001 12:56:03 -0700
Message-ID: <F001.002FE641.20010509130056@fatcity.com>

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_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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Seley, Linda
INET: LSeley_at_IQNavigator.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------