Reference Manual
   CHAPTER 16. System Views     

SYSOPTIONS system view

CREATE VIEW SYS.SYSOPTIONS ( user_name, "option", "setting" )
AS
SELECT ( SELECT user_name FROM SYS.SYSUSERPERM
         WHERE user_id = SYSOPTION.user_id ),
         "option", "setting"
FROM SYS.SYSOPTION

Presents option settings contained in the table SYSOPTION in a more readable format.