SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
  (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS;

SQL> select sid , username, status from v$session where username='STRMADMIN';

       SID USERNAME                       STATUS
---------- ------------------------------ --------
       288 STRMADMIN                      ACTIVE
       302 STRMADMIN                      INACTIVE

SQL> select sid from v$lock where sid in (288,302);

       SID
----------
       302


SQL>  select sid,wait_time,state,lockwait,seconds_in_wait from v$session where username='STRMADMIN';

       SID  WAIT_TIME STATE               LOCKWAIT         SECONDS_IN_WAIT
---------- ---------- ------------------- ---------------- ---------------
       288         -1 WAITED SHORT TIME                                  0
       302          0 WAITING                                          930

SQL>  select sid, request,block,type from v$lock where sid=302;

       SID    REQUEST      BLOCK TY
---------- ---------- ---------- --
       302          0          0 TX

SQL>  select * from v$session_wait where sid=302;

       SID       SEQ# EVENT                                                            P1TEXT                                                                   P1 P1RAW            P2TEXT                                                                   P2 P2RAW            P3TEXT                                                                   P3 P3RAW            WAIT_CLASS_ID WAIT_CLASS# WAIT_CLASS                                                        WAIT_TIME SECONDS_IN_WAIT STATE
---------- ---------- ---------------------------------------------------------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ---------------------------------------------------------------- ---------- ---------------- ------------- ----------- ---------------------------------------------------------------- ---------- --------------- -------------------
       302        184 SQL*Net message from client                                      driver id                                                        1650815232 0000000062657100 #bytes                                                                    1 0000000000000001                                                                           0 00                  2723168908           6 Idle             

SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, SUPPLEMENTAL_LOG_DATA_PK from v$database;

SUP SUP SUP
--- --- ---
NO  NO  NO

SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, SUPPLEMENTAL_LOG_DATA_PK from v$database;
SUP SUP SUP
--- --- ---
NO  NO  NO

1 row selected.

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
  2    (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS;

Database altered.

SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI, SUPPLEMENTAL_LOG_DATA_PK from v$database;
SUP SUP SUP
--- --- ---
YES YES YES

1 row selected.

SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
  2  (PRIMARY KEY, UNIQUE, FOREIGN KEY) COLUMNS;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux

System altered.

SQL> ALTER DATABASE DROP SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS;
ALTER DATABASE DROP SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux


SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS;
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY, UNIQUE) COLUMNS
*
ERROR at line 1:
ORA-32593: database supplemental logging attributes in flux