| High CPU load with 300~500 connections [message #57273] |
Mon, 02 June 2003 00:10  |
Julia
Messages: 30
Registered: December 1999
|
Member |
|
|
Oracle 8.1.7.0.0
Sun Enterprise 420R (4 X UltraSPARC-II 450MHz)
Memory size: 4096 Megabytes
CPU is changing constantly between 30%~90% during the rush hours when there are 300~500 connections from WebLogic servers where connection pools are used. The system was relatively quiet/fine before the application added a big chunk of data into the database. I/O wait is almost zero and about 5% for kernel. There is nothing much we can find from session_wait view either. We feel somehow the 300~500 connections, before was less around 150, are the bottle-neck here but we don't have any clue in terms why and how shall we deal this. May change some of the init parameters help, or we need to apply the 8i patch set, ie. bring to 8.1.7.4? This is a miss critical system and the application team now feel it is not stable at all.
SGA is about 1.5GB with database buffer size around 1.2GB. process = 500.
Thanks, any help will be greatly appreciated.
Julia.
|
|
|
|
| Re: High CPU load with 300~500 connections [message #57285 is a reply to message #57273] |
Mon, 02 June 2003 12:48  |
pwl
Messages: 22
Registered: May 2000
|
Junior Member |
|
|
Firstly : Patch your system
Second: are you using Multi-Threaded Server (MTS),
This will lighten your CPU load.
Third: Your SGA could grow to about 60% of memory -
say 2.4Gig by increasing data areas or sql area
(although this later can cause problems)
Fourthly: Look at you routines/procedures etc an pin
those packages that are often reloaded.
That will be a good start.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
