select name, value from v$option;

PARAMETER                                                        VALUE                                                           
---------------------------------------------------------------- -------------------------
Partitioning                                                     TRUE                                                            
Objects                                                          TRUE                                                            
Parallel Server                                                  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                                                            
N-Tier authentication/authorization                              TRUE                                                            
Function-based indexes                                           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