Home » RDBMS Server » Server Administration » Identify semaphore id in oracle 10g (Oracle 10g)
Identify semaphore id in oracle 10g [message #338155] Mon, 04 August 2008 00:43 Go to next message
rtjk
Messages: 33
Registered: February 2005
Member
Hi All,

I have 2 question related to patch and semaphore management in oracle 10g

1.How to find the semaphore and shm id in oracle 10g?

2.What is the difference between patch and patchset in oracle?

Thanks in advance

Jayakumar

Re: Identify semaphore id in oracle 10g [message #338163 is a reply to message #338155] Mon, 04 August 2008 00:56 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1. ipcs
2. patchset = set of patches.
patchsets fix many problems
patches fix one problem
patchsets are tested against regression, one-off patches are not.

Regards
Michel
Re: Identify semaphore id in oracle 10g [message #338167 is a reply to message #338155] Mon, 04 August 2008 01:05 Go to previous messageGo to next message
rtjk
Messages: 33
Registered: February 2005
Member
Thanks Michel.

Say if i have 3 databases running in single unix box,in that case how to match the semaphore id for an instance.(specifically in 10g).I am aware that in 9i and 8i we can use oradebug to find out.

by
Jayakumar

[Updated on: Mon, 04 August 2008 01:06]

Report message to a moderator

Re: Identify semaphore id in oracle 10g [message #338183 is a reply to message #338167] Mon, 04 August 2008 02:29 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no change in 10g with oradebug, as far as I know but I didn't check it.

You can also use $ORACLE_HOME/bin/sysresv

Regards
Michel
Previous Topic: maximum instances
Next Topic: Creating TableSpace
Goto Forum:
  


Current Time: Thu Dec 08 22:19:34 CST 2016

Total time taken to generate the page: 0.09298 seconds