Lucy,
All temporary segments are owned by SYS. They are created on behalf of the
user by the RDBMS.
____________________Reply Separator____________________
Author: Lucy Lin <[EMAIL PROTECTED]>
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: [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:
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).
