Re: Changing init(instance).ora ?

Dave wrote:
>
> Oracle 7.3.3/Solaris 2.5.1
>
> Is it OK to be changing the init(instance).ora file
> once an Oracle system is up and running.
> I have a large table of 43,000,000 rows and
> am having trouble running out of shared memory
> and stuff. I have changed the /etc/system to
> higher shared memory values but my init(instance).ora
> is set to SMALL. I notice values can be changed to
> medium and large. Can I shutdown the database, change
> these value and bring it back up with no problems?
>
> Any help appreciated.
> Dave

Hi

Assumming you have enough shared memory to bring up the new instance you can do this.

BTW I always put the /etc/system params to the max for an Oracle server so I never have to touch them again....

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=1024
set shmsys:shminfo_shmseg=1024
set semsys:seminfo_semmap=1002
set semsys:seminfo_semmni=500
set semsys:seminfo_semmns=400
set semsys:seminfo_semmnu=500
set semsys:seminfo_semmsl=500
set semsys:seminfo_semopm=100
set semsys:seminfo_semume=100
set semsys:seminfo_semusz=256
set semsys:seminfo_semvmx=32767
set semsys:seminfo_semaem=16384

Also setting the params to small/medium etc is just a very rough quide. you need to tune these properly - see the Oracle tuning manual.

Martin Received on Mon Nov 29 1999 - 04:46:13 CST