Home » RDBMS Server » Performance Tuning » performance tuning
icon5.gif  performance tuning [message #134857] Sun, 28 August 2005 05:26 Go to next message
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 Go to previous messageGo to next message
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
Re: performance tuning [message #134942 is a reply to message #134858] Mon, 29 August 2005 02:48 Go to previous messageGo to next message
girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)
Senior Member
This doc might help:

http://www.dbasupport.com/oracle/ora9i/spfile.shtml

http://forums.oracle.com/forums/message.jspa?messageID=1034249


regds
Girish
Re: performance tuning [message #135449 is a reply to message #134942] Wed, 31 August 2005 11:27 Go to previous messageGo to next message
dinakar5008
Messages: 19
Registered: August 2005
Location: india
Junior Member

thx a lot
Re: performance tuning [message #135489 is a reply to message #134942] Wed, 31 August 2005 16:15 Go to previous message
ChrisJr
Messages: 17
Registered: August 2005
Junior Member
You can also create pfile from spfile and viceversa.

create pfile from spfile;

create spfile from pfile;

Good luck.
Previous Topic: How to use index in date column
Next Topic: query tuning with NVL
Goto Forum:
  


Current Time: Tue Dec 06 21:21:07 CST 2022