Forum Stats

  • 3,875,427 Users
  • 2,266,915 Discussions
  • 7,912,205 Comments

Discussions

What is logons current?

User_Z28YP
User_Z28YP Member Posts: 2 Green Ribbon

Could you please let me know what the logon count metrics relate to ? Document says : : Total number of current logons. Useful only in V$SYSSTAT.

Is this the logins to DB ?

Answers

  • asahide
    asahide Expert Technical Engineer Member Posts: 1,509 Gold Trophy

    Hi,

    Is this the logins to DB ?

    Including background processes, but I think the perception is correct.

    SQL> select name, value from v$sysstat where name='logons current';
    NAME                                           VALUE
    ---------------------------------------------- ----------
    logons current                                 65
    
    SQL> select count(*) from v$session;
      COUNT(*)
    ----------
            65
    

    Regards,