Using MTS will help you conserve RAM, but at the expense of CPU.
Thomas Kyte wrote in message <360ef0d9.2643320_at_192.86.155.100>...
>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
>
>---------------------------------------------------------------------------
-
>Opinions are mine and do not necessarily reflect those of Oracle
Corporation
>
>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 Wed Sep 30 1998 - 09:35:35 CDT
