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
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]
GRANT SELECT ON V_$SESSION TO user;
Regards
Nigel Bishop
Snr. Oracle DBA
ioko
Tel DDI: +44 (0) 1904 435 458
Mobile: +44 (0) 7881 624 386
Fax: +44 (0) 1904 435 450
Email:[EMAIL PROTECTED]
www.ioko.com
-Original Message-
Sent: 15 July 2003 15:00
To: Multiple
Rabbit
I haven't heard this reported and I did a quick Google search and
couldn't find a mention. You might check Metalink. I think that Oracle
Support will probably say that what gets posted to the PROGRAM field is the
responsibility of the client program. Are you certain that the behavior
1. The user has connected, but not issued a SQL statement.
2. The user has been connected a while, issued a statement some time ago,
but that statement has been flushed via the buffer under the LRU algorithm.
Any more?
HTH
Mark
===
Mark Leith
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,
Thanks for the info about module. I've got a script myself that
show's info like GUI/character users, connect times etc...
The piece I was now missing was the module field. Thanks for the info.
Joe
On Fri, 25 Jan 2002, Catherine LeBlanc wrote:
Yes, that will do it, but module does not have
Hi,
There is a bug (1237128,
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUGp_id=1237128)
that might be related to this.
The title of the bug is V$SESSION.PROGRAM HAS NO VALUE USING WINNT ORACLE8/8I CLIENT
CONNECTION
In our case, we see this when 816 NT
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
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
Yes, that will do it, but module does not have 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:
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
13 matches
Mail list logo