[ITS] [EMAIL PROTECTED] writes
You should be aware that Oracle relies on the client providing this information,
so it isn't always available. In particular, the JDBC thin driver tends to
always use __jdbc__.
Hi,
certainly for the IP address you have to be using TCP.
kind regards
Pete
--
You should be aware that Oracle relies on the client providing this information, so it
isn't always available. In particular, the JDBC thin driver tends to always use
__jdbc__.
-Original Message-
Lisa R. Clary
Sent: Wednesday, January 07, 2004 3:05 PM
To: Multiple recipients of list
insert into log values (sys_context('USERENV', 'OS_USER'));
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 10:14 PM
Hi all,
Can anyone point me in the direction on how to isolate the osuser for a
single
Lisa,
I use the following SQL comand to check the system at various times
during the day. I'm sure that it will give you the info you need from
the V$sessions, V$Process, V$Sqlarea tables.
When V$sqlarea like DELETE FROM TABLEX
gather sytem id , osuerid etc and place in table.
Ron
--
set
select sys_context('USERENV','OS_USER') from dual;
On 01/07/2004 03:14:32 PM, Lisa R. Clary wrote:
Hi all,
Can anyone point me in the direction on how to isolate the osuser for a
single session? (I do know about V$SESSION). What I am trying to accomplish
is when a delete is made on a table,
Wow---I guess I have been missing out quite a bit going from 7.3.4 to 9i.
Thanks to Tanel Mladen! I didn't know it was that easy!
lc
-Original Message-
Mladen Gogala
Sent: Wednesday, January 07, 2004 3:45 PM
To: Multiple recipients of list ORACLE-L
select