RE: v$session question
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
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. 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).
RE: v$session question
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] 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: 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 Details Changed after upgrade Database to 8.1.7.4
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't changed, but you've just looked more closely since the upgrade? Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Sunday, March 23, 2003 2:09 AM To: Multiple recipients of list ORACLE-L 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. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: DENNIS WILLIAMS 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
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 | T: +44 (0)1905 330 281 Sales Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput performance -Original 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 obtain any SQL from V$SQLAREA for any given SID? 1 select username, osuser, sql_text 2 from v$session ss, v$sqlarea sa 3 where ss.sid = 861 4 and ss.sql_address = sa.address 5* and ss.sql_hash_value = sa.hash_value [EMAIL PROTECTED] / no rows selected [EMAIL PROTECTED] select * from v$session where sid = 861; SADDR SIDSERIAL# AUDSID PADDR USER# USERNAME COMMAND TADDR -- -- -- -- -- -- LOCKWAIT STATUS SERVER SCHEMA# SCHEMANAME OSUSER PROCESS - -- -- -- - - MACHINE TERMINAL - PROGRAM TYPE SQL_ADDR SQL_HASH_VALUE PREV_SQL -- --- --- PREV_HASH_VALUE MODULE MODULE_HASH --- --- ACTION ACTION_HASH --- CLIENT_INFO FIXED_TABLE_SEQUENCE ROW_WAIT_OBJ# --- - - ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIM LAST_CALL_ET -- --- - - AF4518E4861680 47669205 AF289B1C 2494 OPS$RCAMPBEL 0 INACTIVE DEDICATED 2494 OPS$RCAMPBEL rcampbel25645 titanpts/200 runform30@titan (TNS interface) USER 00 0 A54EFF6C -2.129E+09 frmula_inq1635528872 from menu_driver 306861083 683581-1 14 13785328 11-APR-02 117 -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Daylight Savings Time means that everybody gets up 1 hour earlier. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler 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: Mark Leith 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 with no osuser and no username
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, MACHINE (they are NULLl) - Logon_time keep changing to the current time, - user# = 0 (SYS according to dba_users) - status = active - type = user - Last_call_et values are the same for four of them (20) Can someone explain who are those users Thanks Sinardy Sinardy, Can be processes for jobs (most likely), Intermedia-style processes, etc. Join on V$PROCESS or V$BGPROCESS to have the fuller picture. -- Regards, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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
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
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 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
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).
RE: v$session question
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
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
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
select
s.username,
s.sid,
s.serial#,
to_char(p.spid) unix_pid,
s.status,
to_char(logon_time, 'mm/dd/yy hh24:mi:ss') logon_time,
-- idle time
-- days added to hours
--( trunc(LAST_CALL_ET/86400) * 24 ) || ':' ||
-- days separately
substr('0'||trunc(LAST_CALL_ET/86400),-2,2) || ':' ||
-- hours
substr('0'||trunc(mod(LAST_CALL_ET,86400)/3600),-2,2) || ':' ||
-- minutes
substr('0'||trunc(mod(mod(LAST_CALL_ET,86400),3600)/60),-2,2) || ':' ||
--seconds
substr('0'||mod(mod(mod(LAST_CALL_ET,86400),3600),60),-2,2) idle_time,
substr(s.program,1,20) client_program,
s.machine,
s.process client_process,
s.osuser,
substr(p.program,1,20) server_program
from v$session s, v$process p
where s.username is not null
and p.addr = s.paddr
order by username, 2
/
Lisa Rutland Koivu
Oracle Database Administrator
Certified Self-Important Database Deity
Slayer of Unix Administrators
Wanton Kickboxing Goddess
[EMAIL PROTECTED]
NeoMedia
2201 Second St., Suite 600
Fort Myers, FL 33901, USA
Phone: 941-337-3434
Fax: 941-337-3668
www.neom.com http://www.neom.com
www.paperclick.com http://www.paperclick.com
www.qode.com http://www.qode.com
P a p e r C l i c k . c o m http://www.paperclick.com/home.htm
Enter Your PaperClick Code Here!
-Original Message-
From: Seema Singh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 02, 2001 12:01 PM
To: Multiple recipients of list ORACLE-L
Subject: V$session
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: [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
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-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: Tim Sawmiller 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).
