Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help with run-away process count

Status
Not open for further replies.
Tison

Tison

Programmer
Joined
May 12, 1999
Messages
216
Location
CH
Our Oracle 9i server has started runing out of resources. The reason is that the # processes keeps running up until obviuosly the server reaches the limit.
Has anyone experienced this type of error before or how can I find what is spawning all these processes ?
 
Sort by date Sort by votes
We saw this problem with an earlier version (somewhere around 8.0.5 or 8.1.6). If you had a task that kept repeatedly trying to connect to Oracle and failing (perhaps because of using a bad password or reaching the limit on the number of sessions or something), processes were created and never destroyed (one process per connect attempt). If the task itself was aborted, the extra Oracle processes would go away.
 
Upvote 0 Downvote
Found the problem to be NT Server Vantage agent.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

sqlPower
  • Locked
  • Question Question
Help with Integer to Char to Datetime stamp
Replies
2
Views
1K
SkipVought
S
TheLazyPig
  • Locked
  • Question Question
Merge Into with multiple execution
Replies
1
Views
1K
carp
carp
Andrzejek
  • Locked
  • Question Question
Get part of a string with SQL
Replies
2
Views
1K
Andrzejek
Andrzejek
Tsmtbo2011
  • Locked
  • Question Question
Help Needed!! Micros WS6 610
Replies
1
Views
428
carp
carp
TheLazyPig
  • Locked
  • Question Question
Change format name with comma
Replies
3
Views
463
TheLazyPig
TheLazyPig

Part and Inventory Search

Sponsor

Back
Top