Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is difference between the "concurrent connections" and "concurrent ses

sivaparaFeb 3 2007 — edited Feb 5 2007
See below. "From the book"
What is difference between the "concurrent connections" and "concurrent sessions".
thanks
siva

From the book:
==============
SQL> select maximum_connections "MAX CONN",maximum_sessions "MAX SESS",
servers_started "STARTED" from v$shared_server_monitor;

MAX CONN MAX SESS STARTED
-------- --------- --------
115 120 10

This example shows that we have reached a maximum of 115 concurrent connections since the instance was started. It also shows that the highest number of concurrent sessions since instance startup is 120.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 5 2007
Added on Feb 3 2007
2 comments
664 views