Re: Can NOT startup database and got error ORA-27300, 27301 and 27302

  • From: David Ballester <ballester.david@xxxxxxxxx>
  • To: dba1 mcc <mccdba1@xxxxxxxxx>
  • Date: Thu, 23 Jul 2009 18:28:22 +0200

2009/7/23 dba1 mcc <mccdba1@xxxxxxxxx>

>
> ipcs -s
>
> %ipcs -s
>
> ------ Semaphore Arrays --------
> key        semid      owner      perms      nsems
> 0x963683ec 4751396    oracle    640        10
>
(...)
 0xd5f2a5c0 29720718   oracle    640        154

>
>
> can you tell me how to calculate how many semaphores already use on server?
>
> Thanks.



ipcs -s | awk '{sum +=$5} END {print sum}'

you can discriminate with a grep by owner value, for example

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 07-2009