Thanks. Yes, it can see the listed ones in "v$option" ________________________________ From: "Channa, Santhosh" <Santhosh.Channa@xxxxxxxxxxxx> To: Chris.Taylor@xxxxxxxxxxxxxxx; sharmakdeep_oracle@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Sent: Thursday, February 19, 2009 9:26:58 AM Subject: RE: How to find Oracle Packs already installed Its sys.v_$option. Regards, Santhosh Channa -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Taylor, Chris David Sent: Thursday, February 19, 2009 10:22 AM To: sharmakdeep_oracle@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: RE: How to find Oracle Packs already installed I think its V$option if i'm not mistaken.. Sent from my phone -----Original Message----- From: "Deepak Sharma" <sharmakdeep_oracle@xxxxxxxxx> To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: 2/19/09 9:14 AM 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 -- //www.freelists.org/webpage/oracle-l