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
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Sunday, December 5, 2010
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
4096 Columns1 week ago
-
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment