Oracle Datenbank-Optionen

Sie möchten Datenbank-Optionen Ihrer Oracle-DB ermitteln? Das folgende Skript unterstützt dabei:

ORACLE Datenbanken: Optionen ermitteln
SET pages 3000
COL parameter FORMAT A60
COL value     FORMAT a10
 
SELECT * 
FROM  v$option
ORDER BY 1;

 

Die Ausgabe kann beispielsweise wie folgt aussehen: 

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