advertisements
_____________________________________________________________________________________________________________________
Here are the two queries to find out the installed components in the oracle database.
set pages 1000 lines 120
col comp_name for a40
1. select comp_name, version, status , modified from dba_registry;
2. select parameter from v$option where value = 'TRUE' order by parameter;
Examples
SELECT comp_name, version, status , modified from dba_registry; COMP_NAME VERSION STATUS MODIFIED ---------------------------------------- ------------------------------ -------------------------------------------- ----------------------------- Oracle Database Catalog Views 19.0.0.0.0 VALID 25-MAY-2021 09:27:27 Oracle Database Packages and Types 19.0.0.0.0 VALID 25-MAY-2021 09:27:28 Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF 17-APR-2019 02:03:49 JServer JAVA Virtual Machine 19.0.0.0.0 VALID 25-MAY-2021 09:27:41 Oracle XDK 19.0.0.0.0 VALID 25-MAY-2021 09:27:42 Oracle Database Java Packages 19.0.0.0.0 VALID 25-MAY-2021 09:27:42 OLAP Analytic Workspace 19.0.0.0.0 VALID 25-MAY-2021 09:27:44 Oracle XML Database 19.0.0.0.0 VALID 25-MAY-2021 09:27:31 Oracle Workspace Manager 19.0.0.0.0 VALID 25-MAY-2021 09:27:41 Oracle Text 19.0.0.0.0 VALID 25-MAY-2021 09:27:43 Oracle Multimedia 19.0.0.0.0 VALID 25-MAY-2021 09:27:43 Spatial 19.0.0.0.0 VALID 25-MAY-2021 09:27:47 Oracle OLAP API 19.0.0.0.0 VALID 25-MAY-2021 09:27:47 Oracle Label Security 19.0.0.0.0 VALID 25-MAY-2021 09:27:49 Oracle Database Vault 19.0.0.0.0 VALID 25-MAY-2021 09:27:49 15 rows selected.
advertisements
SQL> select parameter from v$option where value = 'TRUE' order by parameter; PARAMETER ---------------------------------------------------------------- Active Data Guard Adaptive Execution Plans Advanced Analytics Advanced Compression Advanced Index Compression Advanced replication Application Role Automatic Data Optimization Backup Encryption Basic Compression Bit-mapped indexes Block Change Tracking Block Media Recovery Cache Fusion Lock Accelerator Centrally Managed User Change Data Capture Coalesce Index Connection multiplexing Connection pooling Cross Transportable Backups DICOM Data Mining Data Redaction Database queuing Database resource manager Deferred Segment Creation Duplexed backups Enterprise User Security Exadata Discovery Export transportable tablespaces Fast-Start Fault Recovery File Mapping Fine-grained Auditing Fine-grained access control Flashback Data Archive Flashback Database Flashback Table Global Data Services Heat Map In-Memory Aggregation In-Memory Column Store Incremental backup and recovery Instead-of triggers Java Join index Managed Standby Materialized view rewrite OLAP OLAP Window Functions Objects Online Index Build Online Redefinition Oracle Data Guard Parallel backup and recovery Parallel execution Parallel load Partitioning Plan Stability Point-in-time tablespace recovery Privilege Analysis Proxy authentication/authorization Real Application Security Real Application Testing Result Cache SQL Plan Management Sample Scan SecureFiles Encryption Server Flash Cache Snapshot time recovery Spatial Streams Capture Table Clustering Transparent Application Failover Transparent Data Encryption Transparent Sensitive Data Protection Trial Recovery Unused Block Compression XStream Zone Maps 79 rows selected.
_____________________________________________________________________________________________________________________
0 comments:
Post a Comment