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 reci
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
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
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
hasn
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
Hi,
There is a bug (1237128,
http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUG&p_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
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
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:
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:\oran
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/Exter
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 Explorer
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 OR
FOR YOUR INFORMATION
ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has
changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails
using the old format will continue to be delivered until 30th June 2001.
Funnily enough I have just been trying t
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
16 matches
Mail list logo