yeah, you are right. Same is true for RAC (even though there could be other ways to find that out, but it's not listed in v$option). ________________________________ From: D'Hooge Freek <Freek.DHooge@xxxxxxxxx> To: "sharmakdeep_oracle@xxxxxxxxx" <sharmakdeep_oracle@xxxxxxxxx>; "Santhosh.Channa@xxxxxxxxxxxx" <Santhosh.Channa@xxxxxxxxxxxx>; "Chris.Taylor@xxxxxxxxxxxxxxx" <Chris.Taylor@xxxxxxxxxxxxxxx>; "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx> Sent: Thursday, February 19, 2009 9:47:08 AM Subject: RE: How to find Oracle Packs already installed Yes, but "advanced security" for instance is not listed in v$option, even if it is installed. Freek D'Hooge Uptime Oracle Database Administrator email: freek.dhooge@xxxxxxxxx tel +32(0)3 451 23 82 http://www.uptime.be disclaimer ________________________________________ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Deepak Sharma Sent: donderdag 19 februari 2009 16:37 To: Santhosh.Channa@xxxxxxxxxxxx; Chris.Taylor@xxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx Subject: Re: How to find Oracle Packs already installed Thanks. Yes, it can see the listed ones in "v$option" -- //www.freelists.org/webpage/oracle-l