How to view database parameters at SAP level ?

This article answers the following queries:

• How to view database active parameters at SAP level ?


• How to view SPFILE parameters at SAP level ?


• How to view database Parameters history at SAP level ?


• How to export the database parameters to an excel sheet ? 
  

  
  

  How to view database active parameters at SAP level ?
  
  

  Goto transaction DB02 and navigate to Additional Functions -> Database parameters as shown below  :

  
  

  Click on Active parameters tab to view active database parameters
  
  

  
  

  
  

  
  

  
  

  
  

  How to view SPFILE parameters at SAP level ?
  
  

  Click on SPFILE tab to view SPFILE parameters

  
  

  
  

  
  

  
  

  
  

  How to view database Parameters history at SAP level ?
  
  

  Click on parameters history tab to view the parameters that are changed in the recent past.

  
  

  
  

  
  

  
  

  
  

  
  

  
  

  In the above screen click on Show parameters history. It displays window as below

  
  

  
  

  
  

  Provide the date from which you would like to view the database parameter changes.

  
  

  And then click on tick mark to view the database parameter changes from the selected date.

  
  

  
  How to export the database parameters to an excel sheet ?
  
  

  
  

  Click on export button (highlighted below) and select table as the output as shown in below screen and the parameters can be exported to an excel or word as per the selection by you.