| init.ora [message #37906] |
Tue, 05 March 2002 19:57  |
krishna
Messages: 141
Registered: October 1998
|
Senior Member |
|
|
|
Can u tell me what are the different parameters in the init.ora file and their meanings?
|
|
|
|
| Re: init.ora [message #37909 is a reply to message #37906] |
Tue, 05 March 2002 21:23  |
seng
Messages: 191
Registered: February 2002
|
Senior Member |
|
|
Here is sample only(you can find in Oracle Manual).
e.g
db_name = /your database name/
db_domain = /your database host name/
db_block_size = /Oracle block size - can't chance after create/
processes = /how many process, which is supported by database. based on session connected by users/
sessions = /number of connection by users/
db_files = /number data file is allowed to create/
rollback_segments = /rollback segment to set onlline when the database is started/
db_block_buffers =/data buffer for instance - db_block_buffers * db_block_size/
shared_pool_size = /shared buffer size for dictionary and library cache/
log_buffer = /size of log buffer/
sort_area_size = /sorting buffer for any sort in database/
Here are some of parameter. It should have hundre parameter in database. Hope this is helping
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
