title: Viewing pending changes that are set in the SPFILE
body: <p>How do I see what pending changes have been made to an SPFILE before I bounce the database?  I know I can see changes in alert log, but it may have been a few months when the change had been made.</p>
  
  <p>For example:</p>
  
  <pre><code>alter system set sga_max_size=1024M scope=spfile;
  </code></pre>
  
  <p>This doesn't become active until the next bounce.</p>