Oracle CPU history

I have ran the following queries:

Select * From sys.registry$history

Select * From v$version

The first query seems to be in date order and the last entry back in 2012 as "APPLY""

Likewise the version of v$version shows in PL/SQL release

My question is, is there anywhere to see a build history for r11 of Oracle database? I.e. a list of database versions per CPU to see how far behind in terms of security it is? for example version seems to relate to the CPU in October 2011?
Who is Participating?
slightwv (䄆 Netminder) Commented:
>>And do you have to install them all...

You will need to read the fine print.  Most patchsets are inclusive of all previous patches.  Not sure about CPUs specifically but I think most are.

>>Is it not as simple as seeing your build version and being able to see how many cpus are missing?

Not that I'm aware of.  Many patches do not change the version number.  This is where the lsinventory of OPatch posted above is important.

Some one-off patches are simple file copies so not even OPatch will record them.
sys.registry$history  gives you the Patch level applied to the DB - at the condition catpatch.sql or catbundle.sql have been run onto your DB.

v$version only gives you the global version of you Oracle DB Engine - without patchset

The most precise way to get your engine version is to use the OS level command opatch - you'll find it in your $ORACLE_HOME/OPatch directory.
For example :
./opatch lsinventory
pma111Author Commented:
Thanks... but not sure if some confusion... What I was asking - is there any website or similar to show what the current CPU patchset version is for r11? And ideally a version history showing each version and how it correlates to each CPU. Too see how far behind we are?
Network Scalability - Handle Complex Environments

Monitor your entire network from a single platform. Free 30 Day Trial Now!

slightwv (䄆 Netminder) Commented:
pma111Author Commented:
Kind of slightwv, but I was hoping the cpu might tie up with a version, i.e similar to this for vmware:

I have no idea how up to date or behind we are with the informaiton returned from the query - can you advise?
slightwv (䄆 Netminder) Commented:
The CPUs are typically for ALL currently supported versions.

If you want to see release dates based on your current version you will likely have to log into Oracle Support and do a patchset search for your specific version.
pma111Author Commented:
Is it not as simple as seeing your build version and being able to see how many cpus are missing?
pma111Author Commented:
And do you have to install them all... or will just applying the last cpu make you up to date? Or is the previous cpu and pre req for the latest cpu?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.