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
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 session is ended
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 [EMAIL PROTECTED] wrote:
I've got
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
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: Nuala
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 database! Why?
I'm too new here to ask. I
personnel.
Kurt
-Original Message-
Sent: Friday, August 01, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
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
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
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
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
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
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 recipients of list ORACLE-L [EMAIL PROTECTED
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
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.
all the v$ are really v_$. go
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 orakill
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
development system
:
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 time you connect to the database, the killed 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 time you connect to the database, the killed session will not
be visible in the v$session table.
-Original Message
[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 time you connect
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 killed session from v$session
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$session:
ps -fu oracle|grep -v
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
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 official ORACLE-L FAQ: http
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.2 on win2k
.
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 this:
select spid, status, osuser, s.program
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 spid, status, osuser, s.program from
v$process p, v$session s where p.addr
: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
To check for the killed processes' spid in order to remove
, 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 ,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 ,sid, username, osuser, logon_time
3 from v$sqlarea sa
4 , v$session ss
5
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 1
SQL_TEXT
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 JesseSystem
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_HASH_VALUE
' 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_gets 1
6* and sa.address= ss.saddr
SQL
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
-- ---
SQL_TEXT
,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 ,sid, username, osuser
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_HASH_VALUE
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 1
SQL_TEXT
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 /
SIDSERIAL
Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: 12 March 2003 23:04
THANKS AK!
1 select oc.sid, ss.serial#, user_name, osuser, sa.sql_text
2 from v$open_cursor oc, v$session
-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 processes
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
INET: [EMAIL
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 username in v$session
Hi
$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 Card
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
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
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
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 logged into db when I check the column status
for some of the users, its
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_$session only.
Jared
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 to ORACLE-L
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
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
.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 capture
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 [EMAIL
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 changes to the table and by whom
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
via
a third party app and therefore
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 procedure that execs from a trigger
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
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
FROM v$session vs
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
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 IN c_sessions LOOP
v_printline := rsess.username
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 terminal set to UNKNOWN with null terminator.
HTH
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 obtain any SQL
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
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
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
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 v$sessi
fo 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) ;
CLIENT_INFO
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 NULLl
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 without USERNAME, OSUSER, PROGRAM, TERMINAL
ifrun60, it has the actual
Oracle form name that the user is running.
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
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)
Jack
Joe LaCascio [EMAIL PROTECTED]@fatcity.com on 25-01-2002 15:35:24
cc:(bcc
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
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 Zanen/nlzanen1/External
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 C
:
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 Zanen/nlzanen1/External/MEY/NL
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 FAQ: http://www.orafaq.com
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
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
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 pagesize 200
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
--
Please see the official ORACLE
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...
Jesse, Rich wrote:
So
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 jdbcclient and TERMINAL contains
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 a.addr=b.paddr
SQL
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
e,
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.username: iw
85 matches
Mail list logo
