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

  • From: kyle Hailey <kylelf@xxxxxxxxx>
  • To: ORACLE-L <Oracle-L@xxxxxxxxxxxxx>
  • Date: Wed, 9 Mar 2022 10:54:28 -0800

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

Other related posts: