how to check oracle database patch level

[malay boy]

Hi guy's,
How to check what patch have been apply to oracle database?.

regards
mB

[Massimo Bianchi]

Hi,
for the latest patch set, simply do a

select version from v$instance;

it will tell you major and pathset level.

Or you can start the runInstaller, but it's much more lengthy..


Unfortunatly I do not know how to find out if specifyc bugs are applied.....


Massimo

[T G Manikandan]

select * from v$version should give you the result

if it is 8.1.7.4.0

here

8.1.7 -->Release level
4.0--->PSR(patch set release)

Thanks

[twang]

select * from v$version;

BANNER
--------------------------------------------------------------------------------------------------------------------------------
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
PL/SQL Release 8.1.7.4.0 - Production
CORE 8.1.7.0.0 Production
TNS for HPUX: Version 8.1.7.4.0 - Production
NLSRTL Version 3.4.1.0.0 - Production

5 rows selected.

[Indira Aramandla]

Hi,

You can select from the view v$version or from the table props$. The column NLS_RDBMS_VERSION in PROPS$ table will provide the version along with the patch set applied number.

[R. Allan Hicks · Accepted solution]

My personal favorite is rda. The script from metalink gives you html pages of just about anything you'd care to know about your system.

See doc id 139597.1 for info.