Re: Session ID

From: MarkP28665 <markp28665_at_aol.com>
Date: 1997/11/12
Message-ID: <19971112224101.RAA24085@ladder01.news.aol.com>#1/1

From: Pepe Galindo <ppgg_at_lcc.uma.es>
>>1. What number/s identify a Oracle session.
2. How can a normal user (not dba) know that numbers? <<

Oracle provides a utility monitor script usually under the $ORACLE_HOME/rdbms/admin directory (Unix) that can be used to grant access to a whole series of the v$ tables to public or a role. Using the same grant in the script, sys, can directly grant the desired package owner select on v$ whatever like 'grant select on v_$session to joe_bob;' so that sys does not need to be the package owner.

The function userenv('sessionid') value can be used to get the sid and serial# from v$session by matching to the audsid column.

Hope this helps.
Mark Powell -- The only advise that counts is the advise that you follow so follow your own advise Received on Wed Nov 12 1997 - 00:00:00 CST