Hi List
Does anyone have an idea about the value in V$session
program column value for Java Thin driver and OCI
driver
Any help would be really appreciated.
TIA
Sami
__
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http
Title: MTS v$session
First
question I would have is Why does a user have access to V$SESSIONS in the first
place?
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Wiegand, Kurt
[mailto:[EMAIL PROTECTED]Sent: Friday, August 01, 2003 11:19
AMTo
rs with the DBA role on this database! Why?
> I'm too new here to ask. I view them as users/support personnel.
>
> Kurt
>
> -Original Message-
> Sent: Friday, August 01, 2003 11:34 AM
> To: Multiple recipients of list ORACLE-L
>
>
> did you look at th
Title: RE: MTS v$session
No, they are not "SNIPED"; I've worked with those before.
They are in fact all "INACTIVE". I suspect they are waiting on the
client for their next messages. As for your 2nd question:
I've got 7 users with the DBA role on this datab
Title: MTS v$session
Yes;
at least on the server side.
#
SQLNET.ORA Network Configuration File:
/u01/app/oracle/product/817/network/admin/sqlnet.ora# Generated by Oracle
configuration tools. #NAMES.DIRECTORY_PATH=
(TNSNAMES)SQLNET.EXPIRE_TIME= 10
-Original Message-From
Title: MTS v$session
Hi
Kurt,
Have
you set the sqlnet.expire_time in the sqlnet.ora file?
N.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Wiegand,
KurtSent: 01 August 2003 16:19To: Multiple recipients of
list ORACLE-LSubject: MTS v
did you look at the status column in v$session for the ones that don't
match?
IIRC, there can be a status of "SNIPED" where the session is not
actually connected but has not been cleaned up.
curiosity -- why is a user looking at v$session?
--- "Wiegand, Kurt" <[EMA
Title: MTS v$session
I've got an 8.1.7.4.0 instance running under Solaris 2.8.
I've never worked with MTS before, but got a call from a user telling me that there
were about 700 rows in v$session but they only had about 130 sessions open.
The user believes that when the sessio
that helped, tnx a lot !
> Frank <
>-Ursprüngliche Nachricht-
>Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
>Gesendet am: Dienstag, 15. Juli 2003 16:15
>An: Multiple recipients of list ORACLE-L
>Betreff: Re: v$session question
>
>v$session is a synonym.
recipients of list ORACLE-L
Hi all,
anyone able to tell me, how to grant v$session select privileges to a user ?
grant select on v$session to xyuser*
ORA-02030: can only select from fixed tables/views
Cause:
The keyword FILE is required in this context.
Action:
Check syntax, insert
v$session is a synonym.
all the v$ are really v_$. go to dba_views... see for yourself.
so grant on v_$. everyone gets nabbed by that one atleast once.
>
> From: "Foelz.Frank" <[EMAIL PROTECTED]>
> Date: 2003/07/15 Tue AM 09:59:31 EDT
> To: Multiple recipie
sorry, cut/copy/paste mismatch. I took the wrong error description.
again..
anyone able to tell me, how to grant v$session select privileges to a user ?
---
grant select on v$session to xyuser*
ORA-02030: can
Title: RE: v$session question
grant select on sys.v_$session to xyuser
/
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts
Hi all,
anyone able to tell me, how to grant v$session select privileges to a user ?
grant select on v$session to xyuser*
ORA-02030: can only select from fixed tables/views
Cause:
The keyword FILE is required in this context.
Action:
Check syntax, insert keyword FILE as required
TED]>
Sent by: [EMAIL PROTECTED]
03/24/2003 09:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: AW: Remove killed session from v$session
This is going to remove killed session from v$s
laden" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/24/2003 09:18 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: AW: Remove killed session from v$session
This is going to remove
of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: AW: Remove killed session from v$session
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m
Next time you connect to the database, the killed session will not
be visible in the v$session table.
-
lt;[EMAIL PROTECTED]>
cc:
Subject:RE: AW: Remove killed session from v$session
This is going to remove killed session from v$session:
ps -fu oracle|grep -v PID|awk '{ print $2; }'|xargs kill -9
ipcs -m|grep oracle|awk '{ print $2; }'|xargs ipcrm -m
Next ti
king place in the session you kill, it will still
need time to rollback.
Jared
On Monday 24 March 2003 04:28, Stefan Jahnke wrote:
> Thanks all, the time for the rollback to take place seems to explain why it
> takes so long before the session actually disappears from v$session. It's a
Thanks all, the time for the rollback to take place seems to explain why it
takes so long before the session actually disappears from v$session. It's a
development system running long data conversion procedures. Hence, there
will be lots of rollback. ... and I guess I'll opt for or
abase at the Weekend and I have
noticed that PROGRAM field in V$SESSION no longer displays the
program all the time i.e. SQLPLUS and Microsoft Access in
particular. I use this fields in capturing illegal log ons etc.. Anybody
have an idea before I try Support.
--
Please see the officia
I have just upgraded my database at the Weekend and I have
noticed that PROGRAM field in V$SESSION no longer displays the
program all the time i.e. SQLPLUS and Microsoft Access in
particular. I use this fields in capturing illegal log ons etc.. Anybody
have an idea before I try Support
day 21 March 2003 05:53, Stefan Jahnke wrote:
> Hi list
>
> Is there any way to remove a killed session from v$session. Is it even
> necessary to do that ?
> I ran this:
>
> select spid, status, osuser, s.program from
> v$process p, v$session s where p.addr=s.paddr
>
> T
: Friday, March 21, 2003 8:54 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Remove killed session from v$session
>
>
> Hi list
>
> Is there any way to remove a killed session from v$session. Is it even
> necessary to do that ?
> I ran this:
>
> select
HTH.
Arup Nanda
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, March 21, 2003 8:53 AM
> Hi list
>
> Is there any way to remove a killed session from v$session. Is it even
> necessary to do that ?
> I ran t
Hi list
Is there any way to remove a killed session from v$session. Is it even
necessary to do that ?
I ran this:
select spid, status, osuser, s.program from
v$process p, v$session s where p.addr=s.paddr
To check for the killed processes' spid in order to remove the thread (it's
9.
ql_text
> 2 from v$open_cursor oc, v$session ss, v$sqlarea sa
> 3 where oc.sid = ss.sid
> 4 and oc.address = sa.address
> 5 and oc.hash_value = sa.hash_value
> 6* and buffer_gets > 1
> SQL> /
>
--
Please see the official ORACLE-L FAQ:
THANKS AK!
1 select oc.sid, ss.serial#, user_name, osuser, sa.sql_text
2 from v$open_cursor oc, v$session ss, v$sqlarea sa
3 where oc.sid = ss.sid
4 and oc.address = sa.address
5 and oc.hash_value = sa.hash_value
6* and buffer_gets > 1
SQL> /
SID
Join sql_address from v$session to address from v$sqlarea .
Regards,
Denny
Quoting [EMAIL PROTECTED]:
>
> I'm suffering from a senior moment.
> The question is at the every bottom.
>
>
> SQL> select sql_text from v$sqlarea sa where buffer_gets
How about:
SELECT a.sid,
a.username,
c.disk_reads,
c.buffer_gets,
c.sorts,
c.executions,
c.rows_processed,
c.sql_text
FROM v$session a,
v$sqlarea c
WHERE a.sid = &&sessid
AND a.sql_address = c.address
;MWHCOM' AND
> TRUNC(NV
> L(P.EFFDT,SYSDATE+1)) <= TRUNC(SYSDATE) ORDER BY 1
>
> 1 select sql_text
> 2 ,sid, username, osuser, logon_time
> 3 from v$sqlarea sa
> 4 , v$session ss
> 5 where buffer
ogon_time
3 FROM v$sqlarea sa
4 --, v$session s
5 where buffer_gets > 1
6 --sa.address = s.sql_address
7 --and sa.hash_value = s.sql_hash_value
8*--and s.sid = 173
[EMAIL PROTECTED]> /
ADDRESS HASH_VALUE BUFFER_GETS
-- -
T(RP.RELPART)
> = 'Y'
> AND RP.RELPART = PO.PARTID AND PO.TYP = 'WEB' AND PO.VAL = 'MWHCOM' AND
> TRUNC(NV
> L(P.EFFDT,SYSDATE+1)) <= TRUNC(SYSDATE) ORDER BY 1
>
>
>
> 1 select sql_text
> 2 ,sid, username, osuser, logo
How about:
SELECT a.sid,
a.username,
c.disk_reads,
c.buffer_gets,
c.sorts,
c.executions,
c.rows_processed,
c.sql_text
FROM v$session a,
v$sqlarea c
WHERE a.sid = &&sessid
AND a.sql_address = c.address
-- AND a.SQL_HA
Perhaps this is what you're looking for?
select sql_text ,sid, username, osuser, logon_time
from v$sqlarea sa, v$session ss
where sa.buffer_gets > 1-- that's a lot of gets!
and sa.hash_value = ss.sql_hash_value;
HTH! GL! :)
Rich
Rich Jesse
Join sql_address from v$session to address from v$sqlarea .
Regards,
Denny
Quoting [EMAIL PROTECTED]:
>
> I'm suffering from a senior moment.
> The question is at the every bottom.
>
>
> SQL> select sql_text from v$sqlarea sa where buffer_gets
R BY 1
>
>
>
> 1 select sql_text
> 2 ,sid, username, osuser, logon_time
> 3 from v$sqlarea sa
> 4 , v$session ss
> 5 where buffer_gets > 1
> 6* and sa.address= ss.sad
t sql_text
2 ,sid, username, osuser, logon_time
3 from v$sqlarea sa
4 , v$session ss
5 where buffer_gets > 1
6* and sa.address= ss.saddr
SQL> /
no rows selected
1 select sql_text
2 ,
-Original Message-
Sent: Thursday, January 16, 2003 8:09 PM
To: Multiple recipients of list ORACLE-L
Subject:Blank username in v$session
Hi,
I have an instance that is showing null in username, and schemaname = 'sys'
in v$session, these are jdbc client not background
This is server activity not client activity. see program on v$session (it
runs oracle.exe).
> -Original Message-
> From: Ken Heng [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, January 17, 2003 8:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Blank userna
Hi,
I have an instance that is showing null in username, and schemaname = 'sys'
in v$session, these are jdbc client not background processes. Anyone know
why this is the case?
Rgds, Ken Heng
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ken Heng
IN
Sorry for the confusion.
My questions are:
1. Why is the machine name in 'MACHINE' column of V$SESSION appended by a
chr(0) for user connections and not for background processes?
2. And why is the machine name prefixed by 'domain_name\' for user
connections and not for
You've got questions, we've got answers; but interrogative sentences may help
the twain to meet.
On Thu, Oct 31, 2002 at 08:28:51AM -0800, Naveen Nahata wrote:
> I have 2 questions regarding the machine column in V$SESSION.
>
> 1. It shows just the machine name of the
so what is your question .
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 31, 2002 8:28 AM
I have 2 questions regarding the machine column in V$SESSION.
1. It shows just the machine name of the server for al
I have 2 questions regarding the machine column in V$SESSION.
1. It shows just the machine name of the server for all the background
processes, but for all user connections it shows domain\machine_name
2. Also for user processes, the machine name is appended with a chr(0)
whereas for background
is v$process.spid
Run orakill with no parameters to see the join syntax for v$process and
v$session
Regards,
Bruce Reardon
-Original Message-
Sent: Saturday, 12 October 2002 5:03 AM
Charlie,
= NT Domain
= Machine Name
Hope this helps.
PS - do I get a Home Depot Discount
Charlie,
= NT Domain
= Machine Name
Hope this helps.
PS - do I get a Home Depot Discount Card for this? :)
Tom Mercadante
Oracle Certified Professional
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Friday, October 11, 2002 11:59 AM
To: Multiple recipients of list ORA
For folks connecting to the DB server from another Unix box the PROCESS
field is the Process ID on the host named in the MACHINE field.
For folks connecting to the DB server from a PC the values are in the form
of :
So what do & signify?
WENDYC
nal Message-
> From: kommareddy sreenivasa [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 26, 2002 3:38 AM
> To: Multiple recipients of list ORACLE-L
> Subject: strange behaviour of status column in v$session
>
>
> Hi all,
>
> OS: solaris
> DB: 8173
>
> when i
Hi all,
OS: solaris
DB: 8173
when i logged into db when I check the column status
for some of the users, its status is blank.
I checked metalink. In that I found, it is a bug on
clinet versions <817.
But I logged into the server as telnet (bequeth).
I logged into the server from my PC as 2 se
Thanks Jared. Works great.
-Original Message-
Sent: Thursday, May 23, 2002 9:55 PM
To: Multiple recipients of list ORACLE-L
you can also do:
select osuser
fromv$session s
where sys_context('userenv', 'SESSIONID') = s.audsid;
This requires a direct grant to v_$
you can also do:
select osuser
fromv$session s
where sys_context('userenv', 'SESSIONID') = s.audsid;
This requires a direct grant to v_$session only.
Jared
Denham Eva <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
05/22/2002 11:23 PM
Please respond
Wow, this worked exactly as I hoped.
Many Thanks.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 22, 2002 8:49 PM
To: Multiple recipients of list ORACLE-L
Try:
select osuser
fromv$session
where sid in (select sid
from v$mystat);
Chk
u can lookup the pertinent info in the v$session table.
-Original Message-
Sent: Wednesday, May 22, 2002 2:52 PM
To: Multiple recipients of list ORACLE-L
Denham Eva wrote:
>
> Hello Listers,
>
> I have what I hope is challenging problem.
> I am trying to create a procedu
I am trying to create a procedure that execs from a trigger on a table.
> Simple enough.
> But I want to capture the OSUSER value from v$session so that the there is
a
> history of changes to the table and by whom.
> Problem with using USER function is that all the users access the server
Denham Eva wrote:
>
> Hello Listers,
>
> I have what I hope is challenging problem.
> I am trying to create a procedure that execs from a trigger on a table.
> Simple enough.
> But I want to capture the OSUSER value from v$session so that the there is a
> history of cha
Try:
select osuser
fromv$session
where sid in (select sid
from v$mystat);
Chk
[EMAIL PROTECTED]@fatcity.com on 05/22/2002 01:14:52 PM
Please respond to [EMAIL PROTECTED]
Sent by:[EMAIL PROTECTED]
To:Multiple recipients of list ORACLE-L <[EM
procedure.Includes insert etc
END TEST
HTH
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Denham Eva [mailto:[EMAIL PROTECTED]]
Gesendet: Mittwoch, 22. Mai 2002 17:34
An: Multiple recipients of list ORACLE-L
Betreff: OSUSER in V$SESSION
Hello Listers,
I have what I hope is challenging problem.
I am trying to create a procedure that execs from a trigger on a table.
Simple enough.
But I want to capture the OSUSER value from v$session so that the there is a
history of changes to the table and by whom.
Problem with using USER function is
Hello Listers,
I have what I hope is challenging problem.
I am trying to create a procedure that execs from a trigger on a table.
Simple enough.
But I want to capture the OSUSER value from v$session so that the there is a
history of changes to the table and by whom.
Problem with using USER
Title: RE: Zero-term'd machine in V$SESSION from Winders
Rich,
I tested on 8.1.7.2 on HP.
For Windows client (7.3, 8.0, 8.1) "machine" has null terminator, "terminal" does not.
For HP client neither does.
For backgrounds "machine" does not, but "termina
--
, vs.logon_time, vs.last_call_et, vp.SPID
FROM v$session vs, v$process vp
WHERE vs.username IS NOT NULL
AND vs.paddr = vp.addr
ORDER BY vs.last_call_et DESC;
BEGIN
FOR rsess
Rich,
We do have Win clients, and V$SESSION does show proper values for machine
and terminal. Are these sessions for background processes and/or slave
processes?
Jay
-Original Message-
Sent: Tuesday, May 14, 2002 4:23 PM
To: Multiple recipients of list ORACLE-L
So, there I am
OCEDURE Euthanize AS
v_printline VARCHAR2(140);
CURSOR c_sessions IS
SELECT vs.username, vs.osuser,
--
--REPLACE(vs.machine,CHR(0),NULL) "MACHINE",
vs.machine,
--
, vs.logon_time, vs.last_call_et, vp.SPID
Message-
Mengler
Sent: 11 April 2002 21:29
To: Multiple recipients of list ORACLE-L
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 ob
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
: very interesting problem with
V$SESSION and web applications
Dear Gurus , I have a comic question .
?
We have a db and ias and portal . users log in by
using portal login page .
The problem is : because application server
connects to db , in v$session the machines are all the
lient_info passing
the real username as a parameter. This sets v$session.client_info to the
real username.
T10-PARTS> select client_info from v$session 2 where
sid = (select sid from v$mystat where rownum = 1) ;
Assuming that the application "knows" the real username, let the first
thing that the app does is call dbms_application_info.set_client_info passing
the real username as a parameter. This sets v$session.client_info to the
real username.
T10-PARTS> select client_info from
Dear Gurus , I have a comic question .
?
We have a db and ias and portal . users log in by
using portal login page .
The problem is : because application server
connects to db , in v$session the machines are all the application server
machine .
Although the users are db users , when you
Sinard Xing wrote:
>
> Hi all,
>
> I'm using Sun Solaris 7 with Sun Clustering cluster 2.2
> I have 4 strange users connected in this machine Oracle 8.1.6.0.0
> (Dedicated)
>
> Characteristic of unknown users (from v$session) :
> - 4 of them connected w
Hi all,
I'm using Sun Solaris 7 with Sun Clustering cluster 2.2
I have 4 strange users connected in this machine Oracle 8.1.6.0.0
(Dedicated)
Characteristic of unknown users (from v$session) :
- 4 of them connected without USERNAME, OSUSER, PROGRAM, TERMINAL, MACHINE
(they are
unning.
> Joe, I have a script to show all active connections and all that stuff if
> you want it.
>
> Catherine LeBlanc
> DBA, Bates College, Lewiston, ME
>
> At 07:36 AM 1/25/02 -0800, you wrote:
>
> >Hi,
> >
> >Try module in v$session (just a guess)
>
IL PROTECTED]
> >
> >
> >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >cc:(bcc: Jack van Zanen/nlzanen1/External/MEY/NL)
> >
> >
> >In the past, I was running Oracle 8.1.5 and the clients were running
> >Oracle Forms 4.5. Whe
:
>Hi,
>
>Try module in v$session (just a guess)
>
>Jack
>
>
>Joe LaCascio <[EMAIL PROTECTED]>@fatcity.com on 25-01-2002 15:35:24
>
>Please respond to [EMAIL PROTECTED]
>
>Sent by: [EMAIL PROTECTED]
>
>
>To: Multiple recipients of list ORACLE
What platform?
On HP-UX 11.0 and Oracle 8.1.6.2.0 and w/ Clients on Win/NT 4 Workstations,
here is what I get: (last few lines)
SQL> select username, program from v$session;
USERNAMEPROGRAM
--- ---
X468Y02 C:\orant\bin\ifrun60.exe
X0C0AJF
Hi,
Try module in v$session (just a guess)
Jack
Joe LaCascio <[EMAIL PROTECTED]>@fatcity.com on 25-01-2002 15:35:24
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:(bcc: Jack van Za
In the past, I was running Oracle 8.1.5 and the clients were running
Oracle Forms 4.5. When I queried v$session and looked at the program
field I could see what clients where running f45run32.exe.
Now we are on Oracle 8.1.6 and the clients are running Forms60. When I
now query v$session the
xt I
went to look at the SQL in v$sql querying on the sql_address value in
v$session. The query I found had only one table, and it was local. Going
back to v$session_wait, I still found the same event and seq#.
What's up? Any ideas here?
Henry
--
Please see the official ORACLE-L F
I was wondering if anyone else has seen this? There seems to be a mismatch
between v$session and v$transaction (7.3.4). v$transaction.ses_addr matches
an entry in v$session.saddr, but the v$session.taddr does not match
v$transaction.addr. Huh??? Another interesting point is that the
v
DBMS_APPLICATION_INFO
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 018
This column is 64 characters in length - if for example the shortcut to a
program is longer than
this, it can't all be stored, so is there any way of getting this info?
Thanks,
Steven H.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Steven Hovington
INET: [EMAIL
Hi Seema
v$session does not have os process id. v$process has the column spid
which is the unix process id. You could join v$session and v$process using
the columns paddr and addr respectively.
select sid,b.serial#,b.program,b.username from v$process a,v$session b
where a.addr=b.paddr
and
erm.. process !!
Regards
Lee
-Original Message-
Sent: 02 May 2001 17:01
To: Multiple recipients of list ORACLE-L
Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN
The column named PROCESS.
>>> [EMAIL PROTECTED] 05/02/01 12:00PM >>>
Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Pleas
16:52:16 - 0:00 oracleeval
(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
Going into sqlplus I queried V$session with the following query
select sid,serial#,paddr,process from v$session order by 2,4
and determined that the process 22138 was not listed in Oracle and therefore
was defunct. I
Title: RE: V$session
It's in v$process. Here's a script that displays it that I got off this list a while ago
set linesize 2000
column logon_time format a17
column username format a16
column unix_pid format a8
column machine format a20
column client_Program format a20
set pa
Hi
Which column in v$session indicate os process?
Thanks
-seema
_
Get your FREE download of MSN Explorer at http://explorer.msn.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Seema Singh
INET
On Unix I run 'netstat -a', count the number of SQLNet connections per remote host,
then
compare that with the number of connections per username in v$session. With that you
can
kinda deduce what hosts are connected to what username. Maybe there is a better way...
"Jes
So, there I am, trying to find out what client a connection to an 8.1.7 DB
on Solaris is coming from. Naturally, I "SELECT USERNAME, MACHINE, TERMINAL
FROM V$SESSION;" Lo and behold, there is a generic login for the username,
column MACHINE in all rows contains "jdbcclien
Hello List,
I've a simple question.
Why do I see this output when I execute the following
query:
SQL> l
1 select a.USERNAME,a.SPID "unix
pid",b.SID,b.serial#,b.osuser,b.program,a.program
2 from v$process a, v$session b
3 where a.spid='&unixpid'
4* and
Mitchell,
By hostname I take it you mean the hostname of the server where oracle is installed. I
believe that you can call the server anything you want because the ODBC driver looks
up the hostname in the tnsnames.ora and gets the ip address from the host file you are
calling from. If you use O
Hi DBAs
what is impact if I change the host name on unix
with oracle installed.
Mitchell
ername,
Osuser in v$session with the Username in v$process.
"select a.program, b.program,a.username,b.username,b.osuser from v$process a, v$session b
where
a.addr=b.paddr and sid in (18,33,68,115,144,150)"
One of the results is as follows:
a.program :oracle@vantive (TNS V1-V3)
b.us
95 matches
Mail list logo