Re: $sysmetric 'Session Count' != Count(*) from v$session;

It looks like the value in v$sysmetric matches the current_utilization in v$resource_limit, and that may be derived as the count from x$ksuse where bitand(ksspaflg,1) != 0, which is one predicate short of x$ksuse which also tests for bitand(ksuseflg,1)!=0

Regards
Jonathan Lewis

On Wed, 9 Mar 2022 at 18:55, kyle Hailey <kylelf_at_gmail.com> wrote:

>
> Anyone know why the following two are different?
>
> SQL> select metric_name, value from v$sysmetric where metric_name = 'Session Count';
>
> METRIC_NAME VALUE
> ---------------------------------------------------------------- ----------
> Session Count 84
>
> SQL>
> SQL> select Count(*) from v$session;
>
> COUNT(*)
> ----------
> 58
>
>
> Thanks
>
> Kyle
>
>

--
http://www.freelists.org/webpage/oracle-l