You could try to use: opatch lsinventory -detail In the output you will get a list of installed products. It is not a 1 to 1 mapping, but should provide the needed information. Regards, Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Deepak Sharma Sent: donderdag 19 februari 2009 16:15 To: oracle-l@xxxxxxxxxxxxx Subject: How to find Oracle Packs already installed What is a quick way to find (thru SQL or otherwise) all the packs (partitioning, diagnostic etc.) that are installed in a database on a given server? -Thanks -- //www.freelists.org/webpage/oracle-l