AW: v$session question

[Foelz.Frank]

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 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]>
>> Subject: v$session question
>> 
>> 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. 
--- 
Confidentiality Note 
  
Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
Vervielfältigung   oder  Weitergabewie   auchdas   Ergreifen   oder 
Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
untersagt.   Sollten   Siediese  E-Mail  irrtümlicherhalten  haben, 
benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
Mitteilung, die nach dem Senden vorgenommen wurden.  
Herzlichen Dank für Ihre Unterstützung! 
  
This email and any  files transmitted  is intended  only for  the person or 
entity  to  which  it is  addressed  and  may  contain  confidential and/or 
privileged  material. If  you are  not the  authorised recipient,  any use, 
disclosure,  copying,  distribution  or any  action taken or omitted  to be 
taken in reliance  on it,  is prohibited.  If you  received this  in error, 
please contact  the  sender  and  delete the  material  from  any computer. 
E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
accept  responsibility  for  any  changes  made  to this  message after  it 
was sent. 
Thank you for your cooperation! 
--- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: v$session question

[Nigel Bishop]

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 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 keyword FILE as required, and try again. 

 
ORA-02030 can only select from fixed tables/views 

> Frank Foelz  Ó¿Ò <
_
Scheidt & Bachmann GmbH
Gestaltung Parkhaussysteme
Breite Strasse 132
41238 Moenchengladbach

Phone  :  ++49 2166 / 266 - 837
Fax:  ++49 2166 / 266 - 615
e-mail :  mailto:[EMAIL PROTECTED]
 
URL:  http://www.scheidt-bachmann.de  



 
--- 
Confidentiality Note 
  
Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
Vervielfältigung   oder  Weitergabewie   auchdas   Ergreifen   oder 
Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
untersagt.   Sollten   Siediese  E-Mail  irrtümlicherhalten  haben, 
benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
Mitteilung, die nach dem Senden vorgenommen wurden.  
Herzlichen Dank für Ihre Unterstützung! 
  
This email and any  files transmitted  is intended  only for  the person or 
entity  to  which  it is  addressed  and  may  contain  confidential and/or 
privileged  material. If  you are  not the  authorised recipient,  any use, 
disclosure,  copying,  distribution  or any  action taken or omitted  to be 
taken in reliance  on it,  is prohibited.  If you  received this  in error, 
please contact  the  sender  and  delete the  material  from  any computer. 
E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
accept  responsibility  for  any  changes  made  to this  message after  it 
was sent. 
Thank you for your cooperation! 
--- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, 
include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 
removed from).  You may also send the HELP command for other information (like 
subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nigel Bishop
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: v$session question

[rgaffuri]

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]>
> Subject: v$session question
> 
> 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, and try again. 
> 
>  
> ORA-02030 can only select from fixed tables/views 
> 
> > Frank Foelz  Ó¿Ò <
> _
> Scheidt & Bachmann GmbH
> Gestaltung Parkhaussysteme
> Breite Strasse 132
> 41238 Moenchengladbach
> 
> Phone  :  ++49 2166 / 266 - 837
> Fax:  ++49 2166 / 266 - 615
> e-mail :  mailto:[EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> 
> URL:  http://www.scheidt-bachmann.de <http://www.scheidt-bachmann.de/> 
> 
> 
> 
>  
> --- 
> Confidentiality Note 
>   
> Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
> Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
> vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
> Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
> berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
> Vervielfältigung   oder  Weitergabewie   auchdas   Ergreifen   oder 
> Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
> untersagt.   Sollten   Siediese  E-Mail  irrtümlicherhalten  haben, 
> benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
> jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
> Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
> Mitteilung, die nach dem Senden vorgenommen wurden.  
> Herzlichen Dank für Ihre Unterstützung! 
>   
> This email and any  files transmitted  is intended  only for  the person or 
> entity  to  which  it is  addressed  and  may  contain  confidential and/or 
> privileged  material. If  you are  not the  authorised recipient,  any use, 
> disclosure,  copying,  distribution  or any  action taken or omitted  to be 
> taken in reliance  on it,  is prohibited.  If you  received this  in error, 
> please contact  the  sender  and  delete the  material  from  any computer. 
> E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
> accept  responsibility  for  any  changes  made  to this  message after  it 
> was sent. 
> Thank you for your cooperation! 
> --- 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> -- 
> Author: Foelz.Frank
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
> 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: <[EMAIL PROTECTED]
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

v$session question

[Foelz.Frank]

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 only select from fixed tables/views
---
ORA-02030 can only select from fixed tables/views 
Cause: An operation other than SELECT on a fixed dynamic performance table
or view was attempted. It is only possible to select from fixed tables or
views. 
Action: Remove the fixed table or view name from the SELECT statement. 
---

But I must know, what user is doing things to a definite table !


> Frank <
--- 
Confidentiality Note 
  
Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
Vervielfältigung   oder  Weitergabewie   auchdas   Ergreifen   oder 
Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
untersagt.   Sollten   Siediese  E-Mail  irrtümlicherhalten  haben, 
benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
Mitteilung, die nach dem Senden vorgenommen wurden.  
Herzlichen Dank für Ihre Unterstützung! 
  
This email and any  files transmitted  is intended  only for  the person or 
entity  to  which  it is  addressed  and  may  contain  confidential and/or 
privileged  material. If  you are  not the  authorised recipient,  any use, 
disclosure,  copying,  distribution  or any  action taken or omitted  to be 
taken in reliance  on it,  is prohibited.  If you  received this  in error, 
please contact  the  sender  and  delete the  material  from  any computer. 
E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
accept  responsibility  for  any  changes  made  to this  message after  it 
was sent. 
Thank you for your cooperation! 
--- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: v$session question

[Jamadagni, Rajendra]

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, having an opinion is an art !



-Original Message-
From: Foelz.Frank [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, July 15, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L
Subject: v$session question



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, and try again. 


 
ORA-02030 can only select from fixed tables/views 


> Frank Foelz  Ó¿Ò <
_
Scheidt & Bachmann GmbH
Gestaltung Parkhaussysteme
Breite Strasse 132
41238 Moenchengladbach


Phone  :  ++49 2166 / 266 - 837
Fax:  ++49 2166 / 266 - 615
e-mail :  mailto:[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]> 
URL    :  http://www.scheidt-bachmann.de <http://www.scheidt-bachmann.de/> 




 
--- 
Confidentiality Note 
  
Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
Vervielfältigung   oder  Weitergabe    wie   auch    das   Ergreifen   oder 
Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
untersagt.   Sollten   Sie    diese  E-Mail  irrtümlich    erhalten  haben, 
benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
Mitteilung, die nach dem Senden vorgenommen wurden.  
Herzlichen Dank für Ihre Unterstützung! 
  
This email and any  files transmitted  is intended  only for  the person or 
entity  to  which  it is  addressed  and  may  contain  confidential and/or 
privileged  material. If  you are  not the  authorised recipient,  any use, 
disclosure,  copying,  distribution  or any  action taken or omitted  to be 
taken in reliance  on it,  is prohibited.  If you  received this  in error, 
please contact  the  sender  and  delete the  material  from  any computer. 
E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
accept  responsibility  for  any  changes  made  to this  message after  it 
was sent. 
Thank you for your cooperation! 
--- 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California    -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*1

v$session question

[Foelz.Frank]

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, and try again. 

 
ORA-02030 can only select from fixed tables/views 

> Frank Foelz  Ó¿Ò <
_
Scheidt & Bachmann GmbH
Gestaltung Parkhaussysteme
Breite Strasse 132
41238 Moenchengladbach

Phone  :  ++49 2166 / 266 - 837
Fax:  ++49 2166 / 266 - 615
e-mail :  mailto:[EMAIL PROTECTED]
 
URL:  http://www.scheidt-bachmann.de  



 
--- 
Confidentiality Note 
  
Diese  E-Mail  mit  allen angehängten Dateien  ist  ausschließlich  für die 
Person/Personen  bestimmt,   an  die   diese  adressiert   ist  und  könnte 
vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten 
Sie  nicht der  für diese E-Mail  bestimmte Adressat oder nicht zum Empfang 
berechtigt  sein,  ist Ihnen  jeder Gebrauch,  sowie jede Veröffentlichung, 
Vervielfältigung   oder  Weitergabewie   auchdas   Ergreifen   oder 
Unterlassen   von   Maßnahmen   im  Vertrauen   auf   erlangte  Information 
untersagt.   Sollten   Siediese  E-Mail  irrtümlicherhalten  haben, 
benachrichtigen  Sie  bitte   den  Absender und  löschen  diese E-Mail  von 
jedem  Computer.  E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. 
Scheidt &  Bachmann übernimmt  keine Verantwortung für Veränderungen dieser 
Mitteilung, die nach dem Senden vorgenommen wurden.  
Herzlichen Dank für Ihre Unterstützung! 
  
This email and any  files transmitted  is intended  only for  the person or 
entity  to  which  it is  addressed  and  may  contain  confidential and/or 
privileged  material. If  you are  not the  authorised recipient,  any use, 
disclosure,  copying,  distribution  or any  action taken or omitted  to be 
taken in reliance  on it,  is prohibited.  If you  received this  in error, 
please contact  the  sender  and  delete the  material  from  any computer. 
E-mail messages are  not necessarily  secure.  Scheidt  & Bachmann does not 
accept  responsibility  for  any  changes  made  to this  message after  it 
was sent. 
Thank you for your cooperation! 
--- 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: v$session question

[Reardon, Bruce (CALBBAY)]

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 NT OCI apps connect to our NT 817 database - we did 
not see it with the 816 OCI clients connecting to NT 815 database.

HTH,
Bruce Reardon

-Original Message-
Sent: Tuesday, 29 January 2002 1:35

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 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 a guess)
> >
> >Jack
> >
> >
> >Joe LaCascio <[EMAIL PROTECTED]>@fatcity.com on 25-01-2002 15:35:24
> >
> >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.  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 program filed is null?
> >
> >What view could I query in 8.1.6 to see which users are running
> >ifrun60.exe?
> >
> >Thanks,
> >Joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Reardon, Bruce (CALBBAY)
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: v$session question

[Joe LaCascio]

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 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 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)
> >
> >
> >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 program filed is null?
> >
> >What view could I query in 8.1.6 to see which users are running
> >ifrun60.exe?
> >
> >Thanks,
> >Joe
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Catherine LeBlanc
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> 
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).  You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe LaCascio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: v$session question

[Catherine LeBlanc]

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:

>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)
>
>
>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 program filed is null?
>
>What view could I query in 8.1.6 to see which users are running
>ifrun60.exe?
>
>Thanks,
>Joe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Catherine LeBlanc
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: v$session question

[Deshpande, Kirti]

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:\orant\bin\ifrun60.exe
X020C7P C:\orant\bin\ifrun60.exe
XFZGBMX C:\orant\bin\ifrun60.exe
X225D64 C:\orant\bin\ifrun60.exe
XDTF9GR C:\orant\bin\ifrun60.exe


- Kirti

-Original Message-
Sent: Friday, January 25, 2002 8:35 AM
To: Multiple recipients of list ORACLE-L



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 program filed is null?

What view could I query in 8.1.6 to see which users are running
ifrun60.exe?

Thanks,
Joe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe LaCascio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: v$session question

[nlzanen1]

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)


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 program filed is null?

What view could I query in 8.1.6 to see which users are running
ifrun60.exe?

Thanks,
Joe

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Joe LaCascio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




==
De informatie verzonden in dit e-mailbericht is vertrouwelijk en is
uitsluitend bestemd voor de geadresseerde. Openbaarmaking,
vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan
derden is, behoudens voorafgaande schriftelijke toestemming van Ernst &
Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en
volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch
voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een
verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten
worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden.

Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u
vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender
en het origineel en eventuele kopieën te verwijderen en te vernietigen.

Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene
voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De
algemene voorwaarden worden u op verzoek kosteloos toegezonden.
=
The information contained in this communication is confidential and is
intended solely for the use of the individual or entity to whom it is
addressed. You should not copy, disclose or distribute this communication
without the authority of Ernst & Young. Ernst & Young is neither liable for
the proper and complete transmission of the information contained in this
communication nor for any delay in its receipt. Ernst & Young does not
guarantee that the integrity of this communication has been maintained nor
that the communication is free of viruses, interceptions or interference.

If you are not the intended recipient of this communication please return
the communication to the sender and delete and destroy all copies.

In carrying out its engagements, Ernst & Young applies general terms and
conditions, which contain a clause that limits its liability. A copy of
these terms and conditions is available on request free of charge.
===


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

v$session question

[Joe LaCascio]

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 program filed is null?

What view could I query in 8.1.6 to see which users are running
ifrun60.exe?

Thanks,
Joe

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe LaCascio
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).