 performance tuning [message #134857] |
Sun, 28 August 2005 05:26  |
dinakar5008
Messages: 19
Registered: August 2005
Location: india
|
Junior Member |
|
|
i have a oracle 9i enterprse edition rel 2 , previously i worked on oracle 8 /8i , there we have init.ora file to tune the performance like db_files,db_block_buffers,shared_pool_size,db_block_size ,open_cursors etc , but in oracle 9i i didnt find init.ora file , buthere spfileSID.ora file is avilable , but to do the above performance related tasks...
plz help me in this issue ..........
|
|
|
|
| Re: performance tuning [message #134858 is a reply to message #134857] |
Sun, 28 August 2005 06:37  |
tarundua
Messages: 1080
Registered: June 2005
Location: India
|
Senior Member |
|
|
Init file is also thr in 9i . U need to go through documentation related to 9i init file and spfile. Better to start from documentation.
anyways u can modify many parameters dynamically using spfile . for eg:
> Alter System set shared_pool_size=40M scope=both;
this wil make the changes in spfile & memory but not in pfile.
regards,
tarun
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
