Query to Check Installed component in the oracle database?

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.

_____________________________________________________________________________________________________________________

Website Stats