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