How to verify/validate the components installed on Oracle Database
In Oracle 9i, 10g, 11g, if you want to find out what are the components and features that have been installed on the particular instance, you can use the following query.