| Modify ora.init parameters [message #61282] |
Mon, 12 April 2004 01:32  |
A. Rayes
Messages: 6
Registered: April 2004
|
Junior Member |
|
|
|
I want to edit my oracle parameters , which need to shutdown and startup the instant - can do this when the users are connect to oracle database ?
|
|
|
|
|
|
| Re: Modify ora.init parameters [message #61292 is a reply to message #61282] |
Tue, 13 April 2004 00:45  |
Venkat
Messages: 110
Registered: February 2001
|
Senior Member |
|
|
|
Hi please let me know what version of Oracle you are using. It is possible to modify most of the parameters dynamically if it is oracle 9i, but they wont reflect in pfile.
|
|
|
|
|
|
|
|
| Re: Modify ora.init parameters [message #61316 is a reply to message #61303] |
Tue, 13 April 2004 22:51 |
A. Rayes
Messages: 6
Registered: April 2004
|
Junior Member |
|
|
Thanks, Good info.
is their any risk - to change those parameters and restart my instance ? or what are the parameters I should take care if I want tuning my oracle instance ?
I know that db_block_size parameter should be not change after the oracle installation - are they others ?
|
|
|
|
| Re: Modify ora.init parameters [message #61320 is a reply to message #61316] |
Wed, 14 April 2004 05:40 |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Rayes,this is a generic question.There are a ton of parameters that can be tweaked depending on the environment(eg memory,OS,applications,networking,oracle version etc) & requirements.
Some of the key parameters ,that affect performance are
db_cache_size
sort_area_size
shared_pool_size
hash_area_size
pga_aggregate_target
log_buffer
large_pool_size
cursor_sharing
optimizer_mode
optimizer_features_enable
optimizer_index_caching
optimizer_index_cost_adj
db_file_multiblock_read_count
etc etc
For a complete list and description --> Initialization parameters
Again,you can post specific questions here...
-Thiru
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
