| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SqlNet is killing my box!
A copy of this was sent to sean_at_red.seas.upenn.edu (Sean Fernandes)
(if that email address didn't require changing)
On 26 Sep 1998 03:22:47 GMT, you wrote:
>We are having a strange problem with sql*net. It seems to be consuming
>most of the CPU time. We are seeing upto 97% of CPU usage by user
>processes and top hundred of them are SQL*NET processes.
>
>Here is sample line from ps, what I am calling as SQL*NET processes:
>oracle 28812 28197 6 Aug 30 ? 4044:41 oracle<SID>
>(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))
>
those are not sqlnet processes (there is only one sqlnet process and its called tnslsnr). they are the oracle dedicated servers you get when you connect to the machine. if you connected locally without sqlnet, you would get the same processes.
these processes do all of the work for end user queries. The read from the datafiles, they process the selects and do the sorts and all. they modify the database block buffers when you update/insert/delete. These guys do a lot of work -- most of the work in fact if you keep them logged in for really long times.
>Description of our set up is:
>We have about 100 copies of middleware(running on the same server as Oracle)
>each having its own Oracle session. CGI scripts use socket connections to
>connect to random middleware server and request data. Middleware
>performs the SQL and returns data to CGI script back. Since the middle
>ware server runs perpetually and there might be instances where there is
>no activity between a middleware server and database, the session time
>out on the SQL*NET side is set to a huge number.
>
>Question:
>Any suggestion as to where to start trouble shooting.
is your box sized for 100 concurrent connections? what is the box? You say 97% of the cpu time is consumed by these processes -- is anything else running on the server? if not, then the box is sized perfectly and you are maximizing resources. Are you seeing a performance problem or just proactively trying to find one?
Number of concurrent active sessions is some fraction of the 100 connections (say at any point in time, you have a maximum of N active sessions where N < 100) you could try using the MTS (multi-threaded server) to cut down on the number of dedicated servers you need. You could configure MTS to have N or so shared servers that the 100 connections would share. That way you cut down on the number of processes and RAM the system needs to manage. It may free up resources on the server machine (or not, it depends)...
>
>Would really appreciate the help :)
>
>Send mail to sfern_at_sapient.com
>
>Thanks a bunch
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Sat Sep 26 1998 - 08:55:31 CDT
 |
 |