Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How to find the table and user in the session ?
Try this:
select a.username, b.start_time, c.sql_text from v$session a, v$transaction b, v$sqlarea c where a.saddr=b.ses_addr and a.sql_address=c.address;
HTP.
Gunawan Yuwono
Oracle DBA
Kansas City, MO
>--- Original Message ---
>From: Vasu Bolle - ISDX <vbolle_at_mail.maricopa.gov>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Date: 6/15/00 10:25:16 PM
>
>Dear List ,
>Is there any way to find the users (currently log on to ORACLE
),
>and their associated tables(currently updated , but not commited)
>as shown below .
>
>user Table
>--------- -------------
>scott emp
>......
>
>
>Thanks in advance,
> VB
>
>
>
>--
>Author: Vasu Bolle - ISDX
> INET: vbolle_at_mail.maricopa.gov
>
>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).
>
>
![]() |
![]() |