Hi,
> set shmsys:shminfo_sshmseg=10
Are you mistyped here? I guess it shoud be like ..._shmseg
Furthermore, some semaphores parameters values depend on Oracle's PROCESSES
parameter.
So in some cases the default values are not appropriate.
--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
"Ray Teale" <ray_at_BLAHholly.com.au> wrote in message
news:v9su8.2072$c_3.272455_at_ozemail.com.au...
>
> They were set with a cut and paste from the documentation:
>
> set shmsys:shminfo_shmmax=4294967295
> set shmsys:shminfo_shmmin=1
> set shmsys:shminfo_shmmni=100
> set shmsys:shminfo_sshmseg=10
> set semsys:seminfo_semmni=100
> set semsys:seminfo_semmsl=100
> set semsys:seminfo_semmns=200
> set semsys:seminfo_semopm=100
> set semsys:seminfo_semvmx=32767
>
>
> Ray
>
> "Daniel Morgan" <damorgan_at_exesolutions.com> wrote in message
> news:3CBA2AE0.F87C9BB8_at_exesolutions.com...
> > I would go to /etc/system, open it in vi, and compare the values for
> semaphores
> > and shared memory with those recommended by Oracle in the installation
> files on
> > the CD and at technet.
> >
> > Daniel Morgan
> >
> >
> >
> > Ray Teale wrote:
> >
> > > Hi All,
> > >
> > > I posted this question a while ago but didn't get any replies that I
> could
> > > see.
> > > It is still a problem for me so I'm posting again in the hope somebody
> can
> > > help.
> > >
> > > I was trying to do a full database export (Version 8.1.6.0.0 on Sun
> Sparc)
> > > of a fairly small database but got the following error message:
> > >
> > > . exporting referential integrity constraints
> > > . exporting synonyms
> > > EXP-00008: ORACLE error 4031 encountered
> > > ORA-04031: unable to allocate 4032 bytes of shared memory ("shared
> > > pool","oracle/aurora/rdbms/DbmsJavaSYS","joxlod: in
> ehe","ioc_allocate_pal")
> > > EXP-00000: Export terminated unsuccessfully
> > >
> > > .. after all the database users and tables had been exported, just at
> the
> > > time the system was ". exporting synonyms."
> > >
> > > Well I thought this was a bit strange for such a small database but I
> > > doubled the shared_pool_size, bounced the database and tried again.
> Same
> > > problem - it failed at the same spot.
> > > So I tried again - this time the shared pool was 15 times the original
> size
> > > but still the export failed at the same spot.
> > >
> > > So I checked the synonyms and found there are nearly 10000, most owned
> by
> > > PUBLIC and pointing to tables in SYS, and none created by me for my
> > > application.
> > > Couple of questions:
> > > 1. What are synonyms in the following format for (examples chosen at
> random
> > > below) and do I need them (there are lots) :
> > >
> > > SYNONYM_NAME TABLE_NAME
> >
> ---------------- -----------------------------
> > > -
> > > /10076b23_OraCustomDatumClosur /10076b23_OraCustomDatumClosur
> > > /10322588_HandlerRegistryHelpe /10322588_HandlerRegistryHelpe
> > > /10739900_GenericURLDirContext /10739900_GenericURLDirContext
> > > /1079c94d_NumberConstantData /1079c94d_NumberConstantData
> > > java/security/KeyPairGenerator
> java/security/KeyPairGenerator
> > > java/security/MessageDigest
> java/security/MessageDigest
> > >
> > > 2. Would exporting synonyms really put that much of a strain on the
> shared
> > > pool? Why?
> > >
> > > OK .. so that was about four questions..
> > >
> > > Kindest Regards (and apologies for any formatting issues.)
> > >
> > > Ray Teale
> >
>
>
Received on Mon Apr 15 2002 - 02:50:15 CDT
