RE: Database components

Hi George,

Here's a starting point. For more detail, you can always fire the lovely Installer and click on "Installed Products".

Lisa Koivu
Oracle Database Stressmonkey
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063
Office: 954-935-4117
Fax: 954-935-3639
Cell: 954-683-4459

(FACD-ELVIS)>select * from v$option;

PARAMETER                                                        VALUE
---------------------------------------------------------------- -----------------
Partitioning                                                     TRUE
Objects                                                          TRUE
Real Application Clusters                                        FALSE
Advanced replication                                             TRUE
Bit-mapped indexes                                               TRUE
Connection multiplexing                                          TRUE
Connection pooling                                               TRUE
Database queuing                                                 TRUE
Incremental backup and recovery                                  TRUE
Instead-of triggers                                              TRUE
Parallel backup and recovery                                     TRUE
Parallel execution                                               TRUE
Parallel load                                                    TRUE
Point-in-time tablespace recovery                                TRUE
Fine-grained access control                                      TRUE
Proxy authentication/authorization                               TRUE
Change Data Capture                                              TRUE
Plan Stability                                                   TRUE
Online Index Build                                               TRUE
Coalesce Index                                                   TRUE
Managed Standby                                                  TRUE
Materialized view rewrite                                        TRUE
Materialized view warehouse refresh                              TRUE
Database resource manager                                        TRUE
Spatial                                                          TRUE
Visual Information Retrieval                                     TRUE
Export transportable tablespaces                                 TRUE
Transparent Application Failover                                 TRUE
Fast-Start Fault Recovery                                        TRUE
Sample Scan                                                      TRUE
Duplexed backups                                                 TRUE
Java                                                             TRUE
OLAP Window Functions                                            TRUE
Block Media Recovery                                             TRUE
Fine-grained Auditing                                            TRUE
Application Role                                                 TRUE
Enterprise User Security                                         TRUE
Oracle Data Guard                                                TRUE
Oracle Label Security                                            FALSE
OLAP                                                             TRUE
Heap segment compression                                         TRUE
Join index                                                       TRUE
Trial Recovery                                                   TRUE
Oracle Data Mining                                               TRUE
Online Redefinition                                              TRUE
Streams                                                          TRUE
File Mapping                                                     TRUE

47 rows selected.

(FACD-ELVIS)>
-----Original Message-----
Sent: Thursday, June 12, 2003 2:25 PM
To: Multiple recipients of list ORACLE-L

Group,
Can someone please give me the steps to produce a listing of EE database components installed, ie. partitioning option, data mining, etc. ???

I need to compare what is installed on two machines. Both are 9i, one is Solaris and the other is HP.

THANKS, Al Rusnak
DBA - WEB Team
804-734-8371
Never take life seriously. Nobody gets out alive anyway

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Rusnak, George A. (SEC-Lee) CTR
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).