| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: more questions about SID
Howe about this little ditty:
select s.sid sid, c.sql_text sql_text, c.address address,
ltrim(to_char(c.hash_value,'9999999999'),' ') hash_value
from v$open_cursor c, v$session s
where c.saddr = s.saddr and c.hash_value != s.sql_hash_value and s.username
= 'YOUR_USER_NAME'
This should give you all SQL being executed by your user name, unless all
users log on to an app, that then uses the same username to access the
database. In this case, you could change s.username to OSUSER, if known, or
in fact TERMINAL. You should know these for your own PC..
Is this what you are looking for?
Regards
Mark
-----Original Message-----
sahani
Sent: Monday, February 19, 2001 02:31
To: Multiple recipients of list ORACLE-L
Thankx for info.
But these SID are unique for each oracle user.They can't be distingish if 10 persons using same Oracle login and issuing 10 different queries.
I want to know SID for a specific query issued by me.
Is there a way to find it out???????
Thankx and regards
Bipin
--- "Trassens, Christian" <CTrassens_at_uni2.es> wrote: >
You have some options:
>
> select sid from v$mystat
> where rownum=1;
>
> If the user has privilege to access sys.v_$session,
> then you can issue:
>
> select sid from v$session
> where audsid=userenv('SESSIONID');
>
> However connected as internal the
> userenv('SESSIONID') gives you a 0. Hence,
> you couldn't recognize the sid.
>
> Regards.
>
> > -----Mensaje original-----
> > De: bipin sahani [SMTP:bipinsahani_at_yahoo.co.in]
> > Enviado el: sábado 17 de febrero de 2001 12:56
> > Para: Multiple recipients of list ORACLE-L
> > Asunto: Re:Thankx and more questions about SID
> >
> > Thankx for info
> >
> > Can I write a query which will give me a SESSION
> ID of
> > only
> > my session??????????
> >
> >
> > And where system id is stored?????????????
> >
> >
> > Thankx and regards
> > Bipin
> > --- Arun Aggarwal <arun_at_ggn.aithent.com> wrote: >
> The
> > SID in V$SESSION is session id not the system ID
> > > given to the Instance.
> > >
> > > These are two different things.
> > >
> > > Regards
> > > Arun Aggarwal
> > > Aithent Technologies (P) Ltd.
> > > arun_at_ggn.aithent.com
> > > +91-124-6455504 (101)
> > >
> > > "If I knew what I was so anxious about, I
> wouldn't
> > > be so anxious."
> > > --Mignon McLaughlin
> > >
> > > ----- Original Message -----
> > > To: "Multiple recipients of list ORACLE-L"
> > > <ORACLE-L_at_fatcity.com>
> > > Sent: Saturday, February 17, 2001 13:55
> > >
> > >
> > > > Hi ALL,
> > > > I'm confused regarding numeric and multiple
> SIDs
> > > > present in V$SESSION for same USER# and
> USERNAME
> > > > How is it possible??????????
> > > > As far as I know there should be one SID for
> every
> > > > instance of oracle.
> > > > Then how v$session shows me more than one SID
> > > > for same user.And if all these numeric SIDs
> > > > correspond to one alphanumeric SID
> > > > which is SID of that instance then where is
> the
> > > > mapping between numeric and alpha numeric SID?
> > > >
> > > >
> > > > Thankx and regards
> > > > Bipin
> > > >
> > > >
> > > >
> > >
> >
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?bipin=20sahani?= INET: bipinsahani_at_yahoo.co.in 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: ListGuru_at_fatcity.com (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: DIRCON INET: mark_at_cool-tools.co.uk 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: ListGuru_at_fatcity.com (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).Received on Mon Feb 19 2001 - 11:03:47 CST
 |
 |