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: [EMAIL PROTECTED]
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: [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.com
--
Author: Seley, Linda
INET: [EMAIL PROTECTED]
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: [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).
