Re:username

From: <dgoulet_at_vicr.com>
Date: Wed, 09 May 2001 10:53:17 -0700
Message-ID: <F001.002FE35A.20010509105808@fatcity.com>

Lucy,

All temporary segments are owned by SYS. They are created on behalf of the user by the RDBMS.

____________________Reply Separator____________________
Author: Lucy Lin <llin_at_versus.dmz.advance.net>
Date:       5/9/2001 9:46 AM

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:
INET: dgoulet_at_vicr.com

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