| how to increase the performance of the server [message #51420] |
Wed, 22 May 2002 08:02  |
ksr
Messages: 112
Registered: January 2002
|
Senior Member |
|
|
Hi,
I have sun os 5.7 .
I have oracle 8.1.7.0 installed on it but i always see that the performance is very slow.
svrmgrl> show sga
Total System Global Area 577740960 bytes
Fixed Size 73888 bytes
Variable Size 53198848 bytes
Database Buffers 524288000 bytes
Redo Buffers 180224 bytes
os> top
last pid: 10810; load averages: 2.83, 3.10, 3.07
120 processes: 117 sleeping, 2 running, 2 on cpu
CPU states: 0.1% idle, 94.1% user, 5.8% kernel, 0.0% iowait,0.0% swap
Memory: 2048M real, 32M free, 341M swap in use, 685M swap free
Are any figures can be improved ..how to increase the performance of this server.
Any help is appreciated
|
|
|
|
| Re: how to increase the performance of the server [message #51422 is a reply to message #51420] |
Wed, 22 May 2002 09:31  |
oraboy
Messages: 97
Registered: October 2001
|
Member |
|
|
one thing is very obvious from the top command results is that the cpu is only .1% idle, i guess that is the problem, and also try to see the paging space, if the paging space is also 100% full, then u have to seriously think about klling some of the processes.
hope that helps...
|
|
|
|
| Re: how to increase the performance of the server [message #51424 is a reply to message #51420] |
Wed, 22 May 2002 10:09 |
Grant
Messages: 578
Registered: January 2002
|
Senior Member |
|
|
Your swap space is way too low. Oracle recommends 2x the actual memory so your swap should be 4G.
Once you have done that use statspack to determine where else you can improve performance.
Here is what I use to determine the follow for SGA as a start point:
####################### TUNE THE NEXT 3 PARAMETERS TOGETHER ##############################
# db_block_buffers should be 50% of total SGA [[ db_block_buffers = (SGA/2)/db_block_size ]]
# shared_pool_size should be 40% of total SGA
# shared_pool_reserved_size should be 10% of total SGA
So if I had a block size of 8K and wanted 600M SGA here is what it would look like. Note this is approximate because other items increase the SGA.
db_block_size = 8192
####################### TUNE THE NEXT 3 PARAMETERS TOGETHER ##############################
# db_block_buffers should be 50% of total SGA [[ db_block_buffers = (SGA/2)/db_block_size ]]
# shared_pool_size should be 40% of total SGA
# shared_pool_reserved_size should be 10% of total SGA
# db_block_buffers = 36621 # ((600000000/2)/8192) Approximately 600M
# shared_pool_size = 240000000 # (600M * .40) 240M
# shared_pool_reserved_size = 60000000 # (600M * .10) 60M
|
|
|
|
| Re: how to increase the performance of the server [message #51442 is a reply to message #51420] |
Thu, 23 May 2002 03:09 |
Alex Shenfield
Messages: 15
Registered: May 2002
|
Junior Member |
|
|
Hi,
The two points previously noted are good. The swap space is ok thu. The lack of real memory looks more of an issue. The top shows no swapping, but you will have paging due to the lack of real memory. The lack of CPU is a hint of this. Use iostat -xn to view you disk I/O. I suspect you will very high I/O on you swap disks (swap -l).
Your SGA is large and I bet you don't use all of it. I would reduce it and things will speed up!
|
|
|
|
| Re: how to increase the performance of the server [message #53194 is a reply to message #51442] |
Mon, 02 September 2002 06:56 |
sanil
Messages: 3
Registered: August 2002
|
Junior Member |
|
|
|
Assume my hard disk space is 12GB.My database is incresed to 10GB and it contain 3 yrs data.After pruning the data for 1 yrs ,the remaining space still shows as 2GB.The size of my database is not decresed here .Tell me how can I increase the free space for the 1 year data removed and also to get the maximum performance after pruning?.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
