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!

Session vs. Connection; which is which?

661118Oct 8 2008 — edited Oct 9 2008
The question is...is a connection (dedicated, not shared) the same as a session? We're looking at totals derived from the follow sql stmt which I found online:
select s.username as username,
(case
      when grouping(s.machine) = 1 then
      '**** All Machines ****'
      else
       s.machine
end) AS machine,
count(*) as session_count
from v\$session s,
       v\$process p
where s.paddr   = p.addr
   and s.username is not null
group by rollup (s.username, s.machine)
 order by s.username, s.machine ;
We're seeing counts go up to about 1800+ right before the host gets into a bad state; swaps, unresponsive, etc. Can a session (dedicated) correlate one to one as a connection? We've bumped the processes param up to 5000, but now we're seeing issues with +ASM instance running into its ceiling of processes. We don't want to bump that up.

We believe the application is flawed in its ability to manage/throttle connections - we're trying to address this from the database side...are we looking at the right metrics?

Thanks in advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 6 2008
Added on Oct 8 2008
2 comments
800 views