The SCOPE clause has the same behavior as described for the alter_system_set_clause. SID Specify the SID clause to remove a previously specified setting of this parameter for your instance (that is, a previous ALTER SYSTEM SET ... SID = 'sid' statement). Your instance will assume the ...