Vladimir M. Zakharychev wrote:
> "Michael McMahon" <mcmahonm_at_mindspring.com> wrote in message
> news:bbjdqj$vmb$1_at_slb5.atl.mindspring.net...
>
>>Is there any way to determine the actual patch level of a database server??
>>When querying the V$VERSION view it returns Oracle Enterprise Edition
>>Release 8.0.6.1.0 - Production, however I know that this server has been
>>patched to 8.0.6.1.2.
>>
>>Any ideas would be appreciated.
>>
>>Mike
>>
>
>
> Not up to fifth digit - readme's for minor patches usually state that not
> all components will display the patch version and will stay at major
> patchset version. On Windows, VS_VERSION_INFO resource in
> executables/dlls may show actual file version up to fifth digit, but not
> necessarily.
>
perhaps I'm wrong here but I can tell which servers I have applied
patches to (and to what patchset) by either looking at the version info
that shows when I log in from sqlplus or just looking at the db version
info in dba studio under instance-database
hth
Received on Wed Jun 04 2003 - 11:47:50 CDT
