The following example changes a default transaction for an
    existing profile.

    SQL> ALTER PROFILE DECISION_SUPPORT
    cont>   DEFAULT TRANSACTION READ ONLY;