Home » RDBMS Server » Server Administration » Oracle patch information
Oracle patch information [message #231716] Wed, 18 April 2007 04:14 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi
How to find the latest patch applied on oracle DB?Is there any V$ or DBA views that says the patch information?
V$version's banner only shows the oracle version with upgradation patch number. (i.e. 9.2.0.8.0).

-Raaj

Report message to a moderator

Re: Oracle patch information [message #231718 is a reply to message #231716] Wed, 18 April 2007 04:23 Go to previous message
Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
query dba_registry to get version per component or use opatch lsinventory at OS level.

Regards
Michel

Report message to a moderator

Previous Topic: Finding forms user name/form name
Next Topic: Lock held by a session not found in v$session
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 10:22:36 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.