Hi, Bipin,
The statistic# is the same as in v$statname or v$sysstat or v$sesstat.
By the way, select distinct sid from v$mystat is not as fast as select sid from
v$mystat where rownum = 1, which is the fastest way I've known to get your own
SID.
Yong Huang
[EMAIL PROTECTED]
you wrote:
But wha
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 recogni
Thankx for info
But what is significance of STATISTIC# and VALUE
in v$mystat?/
Thankx and regards
Bipin
--- Charlie Mengler <[EMAIL PROTECTED]> wrote: > I'm
doing this from home, from memory & still on my
> 1st cup of coffee.
>
> SQL> select distinct sid into n_sid from v$mystat;
>
I'm doing this from home, from memory & still on my 1st cup of coffee.
SQL> select distinct sid into n_sid from v$mystat;
HTH & YMMV!
bipin sahani wrote:
> Thankx for info
>
> Can I write a query which will give me a SESSION ID of
> only
> my session??
>
> And where system id is store