Sunday, December 5, 2010

viewing concurrent connections in oracle Database

viewing concurrent connections in oracle Database
------------------------------------------------

(Viewing Licensing Limits and Current Values)


select * FROM v$license;


SQL> desc v$license;
Name Null? Type
----------------------------------------- -------- ----------------
SESSIONS_MAX NUMBER
SESSIONS_WARNING NUMBER
SESSIONS_CURRENT NUMBER
SESSIONS_HIGHWATER NUMBER
USERS_MAX NUMBER
CPU_COUNT_CURRENT NUMBER
CPU_CORE_COUNT_CURRENT NUMBER
CPU_SOCKET_COUNT_CURRENT NUMBER
CPU_COUNT_HIGHWATER NUMBER
CPU_CORE_COUNT_HIGHWATER NUMBER
CPU_SOCKET_COUNT_HIGHWATER NUMBER

SQL>


SQL> SELECT RPAD (c.NAME || ':', 11)
|| RPAD (' current logons=' || (TO_NUMBER (b.sessions_current) - 1),
20)
|| 'cumulative logons='
|| RPAD (SUBSTR (a.VALUE, 1, 10), 10)
|| 'highwater mark='
|| b.sessions_highwater information
FROM v$sysstat a, v$license b, v$database c
WHERE a.NAME = 'logons cumulative' ;




---about number of users

SELECT COUNT(*) FROM dba_users;

---also session can see from here

select count(sid) from v$session

No comments: