| Oracle connection problem [message #55390] |
Wed, 22 January 2003 09:29  |
elaine
Messages: 4
Registered: June 2002
|
Junior Member |
|
|
Hi,
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,
Elaine
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
