Home » RDBMS Server » Server Administration » Impact of parameter changes in server
Impact of parameter changes in server [message #211128] Tue, 26 December 2006 11:27 Go to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hai ,


We need to change the db parameter of one of our database as follows.We are in solaris and oracle 8.1.6

Increase the Buffer Pool to 400MB,
Log Buffer Pool to 3 MB
Sort area size by 50%

currently it is as follows..

Log buffer is 1MB.
And sort_area_size is 1MB also db_block_buffers = 30000.

My doubt is changing these parameter means basically we are using the Physical memory or SWAP or whether increase in the parameter will affect RAM .

or shortly how memory is allocated in oracle for the log_buffer , db_block_buffer and sort_area_size physically or by swap means ..?

and one more thing what is the relation between sort_area_size and sort_retained_size ..?Whether it is having any relation like sort_retained_size = sort_area_size/3

Please throw light on this.

TJK











Re: Impact of parameter changes in server [message #211134 is a reply to message #211128] Tue, 26 December 2006 12:12 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
> We need to change the db parameter of one of our database as follows.We are in solaris and oracle 8.1.6
Ready, Fire, Aim!
Based upon what quantifiable benchmark(s) was the above conclusion reached?
If you are uncertain about how the proposed changes will impact the system & the DB's performance, then why are the changes even being considered?
Also V8.1.6 is WAY obsolete & a buggy version at best.
Re: Impact of parameter changes in server [message #211135 is a reply to message #211134] Tue, 26 December 2006 12:33 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Thanks for ur prompt response.

We find some disk sorts and some more issues when we go thru the statspack report.
SO this change was suggested by a dba.My doubt is simple...
when we increase a parameter like log_buffer, db_block_buffers,and sort_area_size, how the memory is allocated...?

My concern is how the memory space is allocated... like from RAM or phy mem or swap..how...?Please look in this view..

TJK

[Updated on: Tue, 26 December 2006 12:34]

Report message to a moderator

Re: Impact of parameter changes in server [message #211138 is a reply to message #211128] Tue, 26 December 2006 12:49 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
If the disk sorts are not resulting in complaints from users, then what is gained by eliminating them?
Is the goal to eliminate all/every disk sort?
How much time will be gained by eliminating the disk sorts?
Re: Impact of parameter changes in server [message #211140 is a reply to message #211138] Tue, 26 December 2006 13:01 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
we got complaint from the user that the site is slow.So took the statspack and send for analyzing. So DBA suggested the changes..

We want to avoid every disk sorts at the max.. 90%.


thanks..

[Updated on: Tue, 26 December 2006 13:02]

Report message to a moderator

Re: Impact of parameter changes in server [message #211142 is a reply to message #211128] Tue, 26 December 2006 13:27 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
I am willing to bet dollars to donuts that after the proposed changes, the application will still be slow.
Previous Topic: my instance is not starting up...
Next Topic: Migration issue
Goto Forum:
  


Current Time: Thu Dec 08 16:20:27 CST 2016

Total time taken to generate the page: 0.07071 seconds