Pages

▼

Tuesday, 21 June 2011

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.





at

5 comments:

  1. Unknown12 October 2012 at 12:25

    how to check howmany users running on instance at os level

    ReplyDelete
    Replies
    1. Unknown11 December 2013 at 11:36

      SM 04 we check instance vise, AL08 we check total instances only Dialog users. ST06 --LAN tab--> check there how mnay users are login the system wide here we check system names and ip address also.

      Delete
    2. Anonymous2 July 2020 at 22:48

      Hi,

      You can use "w" command to see user session at os level.

      Regards
      Ashish

      Delete
  2. Edward12 September 2013 at 16:43

    how can we basis people change the database parameters ?

    ReplyDelete
    Replies
    1. Unknown11 December 2013 at 11:40

      OS level we set parametrs
      AIX , Oracle DB..
      go to /oracle/SID/112_64/dbs/initora.sap
      here we copy file initora.sap to offline_ora.sap or online_ora.sap
      then inside we modify the parametrs...
      next we login db13 then we given profile parameter as per our backup set profile parameter.

      Delete

Please provide your valuable feedback: