RE: get sid (session id) and serial#?
A good response Arup, gave me food for thought, now for some food for my stomach! Thanks John -Original Message- Sent: 01 September 2003 18:14 To: Multiple recipients of list ORACLE-L It's hardly illogical. The purpose of this view is not to provide the SID of the current session, but to show statistics, some of which the DBA may not want a user to know in all cases. Therefore the view is granted to a role SELECT_CATALOG_ROLE, similar to most other dictionary views. Any user with that role can see the view. However, granting the role SELECT_CATALOG_ROLE to all users is not advisable at all. If a user needs it, a very simple grant select on v_$mystat to username can be issued which will resolve the problem. At a development site, or a site where the security for this view is not quite pronounced, you can issue the follwing which will make everyone see this view. grant select on v_$mystat to public; This will make the view visible to even the users created after this command. The decision to hide this view from normal users is deliberate; but breaking that lock is not hard either using a simple grant as shown. Going back to the discussion on why it has been so hard for a user to know his/her SID - why does a user need to know the SID? To alter the DBA for some monitoring action and seeing the SID will help the DBA see that in V$SESSION? In that case, the proper technique is to set the client identifier using DBMS_APPLICATION_INFOR.SET_IDENTIFIER procedure. The value shows up in v$session, no need to know the SID. What else? In a web app maintain state between pages using SID? this approach is fraight with errors. First, SID is not guaranteed to be unique; SID and SERIAL# combination is. To guarantee a unique identifier, use the function DBMS_SESSION.UNIQUE_SESSION_ID to get an id that is unique in a session and use it to maintain state. If it is necessary that the user must know the SID, then the V$MYSTAT can be queried. Hope this helps. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:54 AM It does seem illogical than Oracle provide a view called mystat which tells you about your own statistics, including SID and yet a normal user does not have access to that view unless specifically given. John -Original Message- Sent: 30 August 2003 15:04 To: Multiple recipients of list ORACLE-L But the user need select access to v$mystat connect as sysdba and grant select on v_$mystat to user; HTH GovindanK Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: get sid (session id) and serial#?
On our production database there is the ability for the users to query the database with some long running, date intensive queries. We came up with a method of having the user kill is't own process if needed. We user roles to allow the users acces to the data. Granted select on V_$MYSTAT AND V_$SESSION to the role. Created a special ID that has the ability to kill the sessions. When needed the application will select the session_id and serial# and pass it on the the special ID and it will kill the session. Works great and the users do not have access to anything except what is granted in the role. Ron [EMAIL PROTECTED] 09/05/03 04:09AM A good response Arup, gave me food for thought, now for some food for my stomach! Thanks John -Original Message- Sent: 01 September 2003 18:14 To: Multiple recipients of list ORACLE-L It's hardly illogical. The purpose of this view is not to provide the SID of the current session, but to show statistics, some of which the DBA may not want a user to know in all cases. Therefore the view is granted to a role SELECT_CATALOG_ROLE, similar to most other dictionary views. Any user with that role can see the view. However, granting the role SELECT_CATALOG_ROLE to all users is not advisable at all. If a user needs it, a very simple grant select on v_$mystat to username can be issued which will resolve the problem. At a development site, or a site where the security for this view is not quite pronounced, you can issue the follwing which will make everyone see this view. grant select on v_$mystat to public; This will make the view visible to even the users created after this command. The decision to hide this view from normal users is deliberate; but breaking that lock is not hard either using a simple grant as shown. Going back to the discussion on why it has been so hard for a user to know his/her SID - why does a user need to know the SID? To alter the DBA for some monitoring action and seeing the SID will help the DBA see that in V$SESSION? In that case, the proper technique is to set the client identifier using DBMS_APPLICATION_INFOR.SET_IDENTIFIER procedure. The value shows up in v$session, no need to know the SID. What else? In a web app maintain state between pages using SID? this approach is fraight with errors. First, SID is not guaranteed to be unique; SID and SERIAL# combination is. To guarantee a unique identifier, use the function DBMS_SESSION.UNIQUE_SESSION_ID to get an id that is unique in a session and use it to maintain state. If it is necessary that the user must know the SID, then the V$MYSTAT can be queried. Hope this helps. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:54 AM It does seem illogical than Oracle provide a view called mystat which tells you about your own statistics, including SID and yet a normal user does not have access to that view unless specifically given. John -Original Message- Sent: 30 August 2003 15:04 To: Multiple recipients of list ORACLE-L But the user need select access to v$mystat connect as sysdba and grant select on v_$mystat to user; HTH GovindanK Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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
RE: get sid (session id) and serial#?
It does seem illogical than Oracle provide a view called mystat which tells you about your own statistics, including SID and yet a normal user does not have access to that view unless specifically given. John -Original Message- Sent: 30 August 2003 15:04 To: Multiple recipients of list ORACLE-L But the user need select access to v$mystat connect as sysdba and grant select on v_$mystat to user; HTH GovindanK Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing 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). Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Corniche Park 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:
RE: get sid (session id) and serial#?
Title: Message Hi, It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel. Regards Pete -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: 30 August 2003 00:30To: Multiple recipients of list ORACLE-LSubject: Re: get sid (session id) and serial#? Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work. Arup - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 5:29 PM Subject: RE: get sid (session id) and serial#? It's not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. __ The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED] __
Re: get sid (session id) and serial#?
Title: Message Oracle _officialy_doesn't support it even now. It is included in the sources with a caveat that it will be installed only under instructions from the Support Analysts only. That is why the package is not installed as a part of a normal installation. Think of it this way - even if it was not included "by mistake" in 8.1.5, there were two releases of 8i after that, 8.1.6 and 8.1.7, not to mention several patchkits. The mistake could have been easily fixed by including the source. However, that was not done. Similarly, if it was a mistake, Oracle support should havebeen more than happy to send out the source upon request; but they weren't. HTH. Arup - Original Message - From: Hitchman, Peter To: Multiple recipients of list ORACLE-L Sent: Monday, September 01, 2003 10:09 AM Subject: RE: get sid (session id) and serial#? Hi, It is my understanding that Oracle do support the dbms_support package and that it should have been in the 8i distribution, but was missed out by mistake. It's calls to sys.dbms_system.set_ev they do not supoprt since this enables you to set any debug event in the kernel. Regards Pete -Original Message-From: Arup Nanda [mailto:[EMAIL PROTECTED]Sent: 30 August 2003 00:30To: Multiple recipients of list ORACLE-LSubject: Re: get sid (session id) and serial#? Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work. Arup - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 5:29 PM Subject: RE: get sid (session id) and serial#? It's not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. __The information contained in this email is confidential and intended only for the use of the individual or entity named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. Thomson Scientific will accept no responsibility or liability in respect to this email other than to the addressee. If you have received this communication in error, please notify us immediately via email: [EMAIL PROTECTED]__
Re: get sid (session id) and serial#?
It's hardly illogical. The purpose of this view is not to provide the SID of the current session, but to show statistics, some of which the DBA may not want a user to know in all cases. Therefore the view is granted to a role SELECT_CATALOG_ROLE, similar to most other dictionary views. Any user with that role can see the view. However, granting the role SELECT_CATALOG_ROLE to all users is not advisable at all. If a user needs it, a very simple grant select on v_$mystat to username can be issued which will resolve the problem. At a development site, or a site where the security for this view is not quite pronounced, you can issue the follwing which will make everyone see this view. grant select on v_$mystat to public; This will make the view visible to even the users created after this command. The decision to hide this view from normal users is deliberate; but breaking that lock is not hard either using a simple grant as shown. Going back to the discussion on why it has been so hard for a user to know his/her SID - why does a user need to know the SID? To alter the DBA for some monitoring action and seeing the SID will help the DBA see that in V$SESSION? In that case, the proper technique is to set the client identifier using DBMS_APPLICATION_INFOR.SET_IDENTIFIER procedure. The value shows up in v$session, no need to know the SID. What else? In a web app maintain state between pages using SID? this approach is fraight with errors. First, SID is not guaranteed to be unique; SID and SERIAL# combination is. To guarantee a unique identifier, use the function DBMS_SESSION.UNIQUE_SESSION_ID to get an id that is unique in a session and use it to maintain state. If it is necessary that the user must know the SID, then the V$MYSTAT can be queried. Hope this helps. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 01, 2003 4:54 AM It does seem illogical than Oracle provide a view called mystat which tells you about your own statistics, including SID and yet a normal user does not have access to that view unless specifically given. John -Original Message- Sent: 30 August 2003 15:04 To: Multiple recipients of list ORACLE-L But the user need select access to v$mystat connect as sysdba and grant select on v_$mystat to user; HTH GovindanK Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing 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
RE: get sid (session id) and serial#?
But the user need select access to v$mystat connect as sysdba and grant select on v_$mystat to user; HTH GovindanK Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing 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). Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Corniche Park 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: get sid (session id) and serial#?
Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing 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: get sid (session id) and serial#?
select sid from v$mystat where rownum 2 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:34 AM DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Arup Nanda 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: get sid (session id) and serial#?
hi use v$mystat to find your sid. and v$session . Regards zhu chao msn:[EMAIL PROTECTED] www.cnoug.org - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 12:34 PM DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: zhu chao 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: get sid (session id) and serial#?
Thanks all for the input. the script is select sid,serial# from v$session where sid=(select sid from v$mystat where rownum=1) But the user need select access to v$mystat Chuan -Original Message- Sent: Friday, 29 August 2003 15:19 To: Multiple recipients of list ORACLE-L Hi Chuan, can v$session help you this view has information like machine, osuser, username, sid, program, and others SQL desc v$session SQL select columns,... from v$session where username = 'SCOTT' and machine = 'YOUR_HOSTNAME' if you do telnet you will get 2 rows (if scoot is only use by you) is not Sinardy -Original Message- Sent: 29 August 2003 12:34 To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Sinardy Xing 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). Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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).
RE: get sid (session id) and serial#?
Check SYS_CONTEXT Select sid,serial# from v$session where audsid = (select sys_context('USERENV','SESSIONID') from dual); Kind Regards, Hatzistavrou Yannis -Original Message- Sent: Friday, August 29, 2003 7:34 AM To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Hatzistavrou John 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: get sid (session id) and serial#?
Homes this may work select distinct s.sid,s.serial# from v$session s, V$MYSTAT m where s.sid=m.sid / - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 29, 2003 10:04 AM DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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: Manoj Kumar Jha 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: get sid (session id) and serial#?
Title: RE: get sid (session id) and serial#? use the function dbms_support.mysid if it is available on your version. 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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 12:34 AM To: Multiple recipients of list ORACLE-L Subject: get sid (session id) and serial#? DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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). 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.*2
RE: get sid (session id) and serial#?
Title: RE: get sid (session id) and serial#? [EMAIL PROTECTED] sys SQL*Plus: Release 9.2.0.2.0 - Production on Fri Aug 29 14:42:11 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 14:42:15 SQL desc dbms_support FUNCTION MYSID RETURNS NUMBER FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE Argument Name Type In/Out Default? -- --- -- WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE START_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE STOP_TRACE PROCEDURE STOP_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN 14:42:19 SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production you probably need to install dbms_support package. 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: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @ESPN.COM Subject: RE: get sid (session id) and serial#? Sent by: [EMAIL PROTECTED] om 08/29/2003 10:30 AM Please respond to ORACLE-L use the function dbms_support.mysid if it is available on your version. 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- Sent: Friday, August 29, 2003 12:34 AM To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- 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). (See attached file: ESPN_Disclaimer.txt) *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: get sid (session id) and serial#?
Raj, The comments in dbmssupp.sql suggest that this object needs to be installed only when requested by Oracle supportI was just curious why our databases did not have this object... :-). Thanks Murali. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @espn.comSubject: RE: get sid (session id) and serial#? Sent by: [EMAIL PROTECTED] om 08/29/2003 03:44 PM Please respond to ORACLE-L [EMAIL PROTECTED] sys SQL*Plus: Release 9.2.0.2.0 - Production on Fri Aug 29 14:42:11 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 14:42:15 SQL desc dbms_support FUNCTION MYSID RETURNS NUMBER FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE Argument Name Type In/Out Default? -- --- -- WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE START_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE STOP_TRACE PROCEDURE STOP_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN 14:42:19 SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production you probably need to install dbms_support package. 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- [mailto:Murali_Pavuloori/[EMAIL PROTECTED] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @ESPN.COM Subject: RE: get sid (session id) and serial#? Sent by: [EMAIL PROTECTED] om 08/29/2003 10:30 AM Please respond to ORACLE-L use the function dbms_support.mysid if it is available on your version. Raj
RE: get sid (session id) and serial#?
Title: RE: get sid (session id) and serial#? Go ahead, install the package, no problems. It is a better interface to enable/disable trace anyways. 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: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 4:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, The comments in dbmssupp.sql suggest that this object needs to be installed only when requested by Oracle supportI was just curious why our databases did not have this object... :-). Thanks Murali. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @espn.com Subject: RE: get sid (session id) and serial#? Sent by: [EMAIL PROTECTED] om 08/29/2003 03:44 PM Please respond to ORACLE-L [EMAIL PROTECTED] sys SQL*Plus: Release 9.2.0.2.0 - Production on Fri Aug 29 14:42:11 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. 14:42:15 SQL desc dbms_support FUNCTION MYSID RETURNS NUMBER FUNCTION PACKAGE_VERSION RETURNS VARCHAR2 PROCEDURE START_TRACE Argument Name Type In/Out Default? -- --- -- WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE START_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN WAITS BOOLEAN IN DEFAULT BINDS BOOLEAN IN DEFAULT PROCEDURE STOP_TRACE PROCEDURE STOP_TRACE_IN_SESSION Argument Name Type In/Out Default? -- --- -- SID NUMBER IN SERIAL NUMBER IN 14:42:19 SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production you probably need to install dbms_support package. 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- [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali. Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @ESPN.COM Subject: RE: get sid (session id) and serial#? Sent by: [EMAIL PROTECTED] om 08/29/2003 10:30 AM Please respond to ORACLE-L use the function dbms_support.mysid if it is available on your version. 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- Sent: Friday, August 29, 2003 12:34 AM To: Multiple recipients of list ORACLE-L DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/[EMAIL PROTECTED] In this connection, SQL What shoud I input to get this sid and serial#? TIA Chuan Important: This transmission is intended only for the use of the addressee and may contain confidential or legally privileged information. If you are not the intended recipient, you are notified that any use or dissemination of this communication is strictly prohibited. If you receive this transmission in error please notify the author immediately by telephone and delete all copies of this transmission together with any attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat
RE: get sid (session id) and serial#?
Title: Message Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali.
RE: get sid (session id) and serial#?
Title: Message Its not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Kanagaraj Sent: Friday, August 29, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John Kanagaraj DB Soft Inc Phone: 408-970-7002 (W) Disappointment is inevitable, but Discouragement is optional! ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali.
Re: get sid (session id) and serial#?
Title: Message Oracle officially "desupported" the package in 8i; but then included (by mistake?) in 9i. In 8i, however, you could pester your friendly neuighborhood Support Analyst to give you the package. You could try from 9i sources, too; but not sure if they work. Arup - Original Message - From: Igor Neyman To: Multiple recipients of list ORACLE-L Sent: Friday, August 29, 2003 5:29 PM Subject: RE: get sid (session id) and serial#? Its not in 8.1.5 Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John KanagarajSent: Friday, August 29, 2003 3:20 PMTo: Multiple recipients of list ORACLE-LSubject: RE: get sid (session id) and serial#? Need to install @?/rdbms/admin/dbmssupp while connected as SYS. Available on all platforms 8.0.6+ I understand. John KanagarajDB Soft IncPhone: 408-970-7002 (W)Disappointment is inevitable, but Discouragement is optional!** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Murali_Pavuloori/[EMAIL PROTECTED] [mailto:Murali_Pavuloori/[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 3:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: get sid (session id) and serial#? Raj, Which version of db are you on? This is not available on 9.2.0.3 Murali.