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

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

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

RE: get sid (session id) and serial#?

. 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 (

Re: get sid (session id) and serial#?

ort 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

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

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

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

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

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

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,

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

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

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

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

RE: get sid (session id) and serial#?

PROTECTED] Rajendra.Jamadagni cc: @espn.comSubject: RE: get sid (session id) and serial

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

RE: get sid (session id) and serial#?

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

RE: get sid (session id) and serial#?

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#?

ork. 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