| Oracle processes [message #53143] |
Thu, 29 August 2002 04:21  |
Gautam
Messages: 24
Registered: February 2002
|
Junior Member |
|
|
Hi All,
When I give a bewlow command at unix prompt
i.e. ps -ef|grep orcle
I am seeing so many oracle processes. And the count is increasing gradually and making the system very slow.
The output of the above command is as below:
oracle 13120 1 1 17:22:02 ? 0:04 /u00/app/oracle/product/8.1.7/bin/tnslsnr LISTENER -inherit
oracle 14941 1 0 17:39:16 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 15171 1 0 17:40:37 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14943 1 0 17:39:17 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14837 1 0 17:38:33 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14732 1 0 17:37:26 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 15942 1 5 17:45:59 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14543 1 0 17:36:04 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14972 1 0 17:39:38 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14939 1 0 17:39:15 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14713 1 0 17:37:21 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14548 1 0 17:36:05 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14970 1 0 17:39:23 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14892 1 0 17:38:57 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 13976 1 0 17:30:08 ? 0:01 oracleORA817WL (LOCAL=NO)
oracle 14561 1 0 17:36:06 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 15167 1 0 17:40:36 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14579 1 0 17:36:09 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14890 1 0 17:38:56 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14459 1 0 17:34:21 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14761 1 0 17:37:34 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14538 1 0 17:36:03 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14390 1 0 17:33:42 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14404 1 0 17:33:48 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14396 1 0 17:33:46 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 15169 1 0 17:40:37 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14756 1 0 17:37:30 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 15383 1 0 17:42:46 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14688 1 0 17:36:43 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
oracle 14844 1 0 17:38:38 ? 0:00 oracleORA817WL (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
------------------------------------------------------
this is gradually increasing with the same stuff. Do any one help me in finding what it is and what the exact problem is. How do i resolve it.
thanks
Gautam
|
|
|
|
| Re: Oracle processes [message #53161 is a reply to message #53143] |
Thu, 29 August 2002 15:34  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
Q: What it is?
A: As you can see those are db connections using PROTOCOL BEQ (which means you are making local db connections on the db box). You are using dedicated connections, so each user connected makes new connection. There is a memory allocation for each connection to keep the session information, temp space, etc. As you know that will keep going until you ran out of memory and your box became SLOW!!!
Q: How do I resolve it?
A: Configure your database instance with MTS (Multi Threaded Server) so the connection can be kept in pool and then recycled. Also you can setup QUEUESIZE parameter a bit higher. It is explained How to do it Here).
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
