max connections to the database

[Shestakov]

Originally posted by thanigai

SQL> select * from v$sysstat where name like '%LOGON%';
no rows selected

but : select * from v$sysstat where name like '%logon%';
STATISTIC# NAME CLASS VALUE
--- ------------------- ----- ------
0 logons cumulative 1 5127282
1 logons current 1 20