V$OPTION

Columns
   ___________________________
 
   PARAMETER
   VALUE

Related:

V$ACTIVE_INSTANCES 
V$COMPATIBILITY 
V$COMPATSEG 
V$DATABASE 
V$INSTANCE 
V$LICENSE 
V$TABLESPACE 
V$VERSION