Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Semaphores and Oracle on Unix

Re: Semaphores and Oracle on Unix

From: Robert Young <rcyoung_at_groupz.net>
Date: 1997/10/12
Message-ID: <778B4B7579273523.3ECFB14EAA50307E.6D5A7A552635D0D8@library-proxy.airnews.net>#1/1

Try looking up the UNIX command 'ipcs'-or at least I think that is the right one. It will show you the seamphores being used. It's companion command ipcrm is also handy. If Oracle comes down 'unexpectedly', the semaphores may still be allocated to the 'down' process. It you try to restart Oracle, you get an error because Oracle uses a hash of the SID to 'name' the reserved semaphores...and the name already exists because the first set has not been released.

ipcrm lets you release those 'older' semaphores.

Donne You wrote in message <61o74s$cv3$1_at_newbabylon.rs.itd.umich.edu>...
>semaphore is the low level mechanism for process synchronization
>and protection of critical areas in the process's address space
>(such as oracle server process). for the purpose of protection
>of critical areas, semaphores are used to identify the ownership
>of critical data or memory structurs. they are passed around by
>the O/S in a certain way. the process that happens to have the
>semaphore is allowed to modify a certain segment, while others
>have to wait for their turns.
>
>latches and locks are Oracle concepts. it's likely that they
>are implemented using semaphores to protect memory sturcturs
>and physical objects such as rows and tables.
>
>
>
>In article <EHtqww.AH.0.debian_at_sirena.rinet.ru> Konstantin Kivi
 <konst_at_sirena.rinet.ru> writes:
>>arpege <arpege_at_imaginet.fr> wrote:
>>> I've read that each Oracle process needs a semaphore to be available to
>>> access the SGA. Is that right and if so why ?
>>> What is alto the difference between latch's and semaphores ?
 

>>> Best Regards
 

>>> Philippe (arpege_at_imaginet.fr)
>>
>>I am not sure what do you mean under latch, but semaphore is
>>a unix (posix) way to order access from different process
>>to different objects on the system (SGA in our case).
>>man ipc
>>man semget
>>man semop
>>man semctl
>>
>>Konstantin
>
>
Received on Sun Oct 12 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US