Dba-feature-usage-statistics shows usage for all including rac and aso. Sometimes you can infer one from the other. -----Original Message----- From: Deepak Sharma <sharmakdeep_oracle@xxxxxxxxx> Sent: Thursday, February 19, 2009 10:52 AM To: Freek.DHooge@xxxxxxxxx; Santhosh.Channa@xxxxxxxxxxxx <Santhosh.Channa@xxxxxxxxxxxx>; Chris.Taylor@xxxxxxxxxxxxxxx <Chris.Taylor@xxxxxxxxxxxxxxx>; oracle-l@xxxxxxxxxxxxx <oracle-l@xxxxxxxxxxxxx> Subject: Re: How to find Oracle Packs already installed 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 -- //www.freelists.org/webpage/oracle-l