OraFAQ Forum: Server Administration » Identify semaphore id in oracle 10g

Home » RDBMS Server » Server Administration » Identify semaphore id in oracle 10g (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Identify semaphore id in oracle 10g [message #338155]

Mon, 04 August 2008 00:43

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

Report message to a moderator

Re: Identify semaphore id in oracle 10g [message #338163 is a reply to message #338155]

Mon, 04 August 2008 00:56

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: Identify semaphore id in oracle 10g [message #338167 is a reply to message #338155]

Mon, 04 August 2008 01:05

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

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Previous Topic:	maximum instances
Next Topic:	Creating TableSpace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Dec 01 22:27:52 CST 2024