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