parameter_name
  [ SCOPE = { MEMORY | SPFILE | BOTH } ]
  [ SID = 'sid' ]