Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to change parameters values

438439Sep 9 2009 — edited Sep 9 2009
dear gurus,

can someone guide how to change below values and apply and what steps should taken and changes do in files

* Shared_pool_size = 450M
* Db_cache_size = 750M
* Pga_aggregate_target = 125M
* Sort_area_size = 1M
* Open_cursors = 4000
* Processes = 300

regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2009
Added on Sep 9 2009
13 comments
1,148 views