patchset vs patches
Hi all,
I am not a DBA and am a bit confused about patches and patchsets.
I have read about them and I would just like confirmation, please.
From what I understand:
Patches are individual fixes for the Oracle database, which you can install one by one.
Patchsets instead contain all fixes to bugs that have been found in the version of Oracle Database in question, and get released not as frequently as Patches, i.e. once a quarterly.
If this is the case, can I assume that patchset for Oracle 11.2.0.2 released in July 2011 would contain all the fixes of individual patches for Oracle 11.2.0.2 released up to July 2011?
i.e. would this patchset coniatn the fix for Patch 9824435: ORA-600: INTERNAL ERROR CODE, ARGUMENTS: [KOKEGPINLOB1] that was released on 23rd March 2011?
My assumption is yes.
How can I determine what patchset has been installed against a DB (the opatch seems to only return patches) and what was fixed within that patchset?
Thanks very much in advance.