If there is an entry in V$SESSION, does it imply that user has
a current session within the instance?
If not, how do I determine which users have logged out of the DB?
Under what conditions would I not be able to obtain any SQL from
V$SQLAREA for any given SID?
1 select username, osuser, sql_text
2 from v$session ss, v$sqlarea sa
3 where ss.sid = 861
4 and ss.sql_address = sa.address
5* and ss.sql_hash_value = sa.hash_value
[EMAIL PROTECTED]> /
no rows selected
[EMAIL PROTECTED]> select * from v$session where sid = 861;
SADDR SID SERIAL# AUDSID PADDR USER# USERNAME
COMMAND TADDR
-------- ---------- ---------- ---------- -------- ---------- --------------
---------- --------
LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER
PROCESS
-------- -------- --------- ---------- ------------------------------ ---------------
---------
MACHINE TERMINAL
---------------------------------------------------------------- ---------
PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE
PREV_SQL
------------------------------------------------ ---------- -------- --------------
--------
PREV_HASH_VALUE MODULE MODULE_HASH
--------------- ------------------------------------------------ -----------
ACTION ACTION_HASH
-------------------------------- -----------
CLIENT_INFO FIXED_TABLE_SEQUENCE
ROW_WAIT_OBJ#
---------------------------------------------------------------- --------------------
-------------
ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIM LAST_CALL_ET
-------------- --------------- ------------- --------- ------------
AF4518E4 861 680 47669205 AF289B1C 2494 OPS$RCAMPBEL 0
INACTIVE DEDICATED 2494 OPS$RCAMPBEL rcampbel
25645
titan pts/200
runform30@titan (TNS interface) USER 00 0
A54EFF6C
-2.129E+09 frmula_inq 1635528872
from menu_driver 306861083
683581
-1
14 137853 28 11-APR-02 117
--
Charlie Mengler Maintenance Warehouse
[EMAIL PROTECTED] 10641 Scripps Summit Ct.
858-831-2229 San Diego, CA 92131
Daylight Savings Time means that everybody gets up 1 hour earlier.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Charlie Mengler
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).
