parameter_name = parameter_value [, parameter_value ]...
  [ COMMENT 'text' ]
  [ DEFERRED ]
  [ SCOPE = { MEMORY | SPFILE | BOTH } ]
  [ SID = { 'sid' | * } ]