$sysmetric 'Session Count' != Count(*) from v$session;
From: kyle Hailey <kylelf_at_gmail.com>
Date: Wed, 9 Mar 2022 10:54:28 -0800
Message-ID: <CADsdiQhSBhWL9nnWCcw2JO_RMKHb-JQbTiVEo6ejb5L2+E02hg_at_mail.gmail.com>
Anyone know why the following two are different?
Date: Wed, 9 Mar 2022 10:54:28 -0800
Message-ID: <CADsdiQhSBhWL9nnWCcw2JO_RMKHb-JQbTiVEo6ejb5L2+E02hg_at_mail.gmail.com>
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-lReceived on Wed Mar 09 2022 - 19:54:28 CET