We have a customer reported that they are having connection problem with Oracle server while using our application. The problem was 'too many dead connections'.
A few questions:
1. How many is too many? Is there a limit being preset or set by us on the number of active/dead connection on an Oracle server?

2. How to view the number of active/dead connections on an Oracle server? Is there a tool we can use?

3. I am thinking to resolve their problem in this way:
a) add resource_limit = true to init.ora file on the server
b) create a profile with idle_time set inside.
c) assign the profile to the db user.

is this approach sounds fine to you?

Thanks a lot,