By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,919 Members | 1,074 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,919 IT Pros & Developers. It's quick & easy.

Oracle inactive connections

P: n/a
We have a couple of Oracle (8.x and 9.x) install on Sun Solaris
platforms. On most of the servers we have a very strange problem

1. When Oracle is started in the morning, memory usage is very low.
2. During the course of the day the memory the memory increases upto
3. When I check the active connections in Oracle (v$session table), I
find that out of 80-100 connections, only 5-10 are active whereas the
others are inactive.

I find it hard to believe that Oracle does not automatically close
these inactive connections. Do I have to do this manually or am I
missing something very elementary here ?

Please assist.
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.