How to use DB20ORA - Update DB Statistics: Oracle

SAP Transaction Code - Details

• Transaction Code: DB20ORA

  Description: Update DB Statistics: Oracle

  Release: S/4HANA and ECC 6

• • Program: SAPMDB20

    Screen: 100

    Authorization Object: S_ADMI_FCD

  • Development Package: SDBO

    Package Description:

    Parent Package:

  • Module/Component:

    Description:

Smart SAP Assistant

• SAP Tcode: DB20ORA - Update DB Statistics: Oracle

  
  Overview:
  DB20ORA is an SAP transaction code used to update database statistics for Oracle databases. This code is used to ensure that the database is running optimally and that queries are running efficiently. 
  
  Functionality:
  This transaction code allows users to update the database statistics for Oracle databases. This ensures that the database is running optimally and that queries are running efficiently. The code also allows users to view the current database statistics and to compare them with the updated statistics. 
  
  Step-by-step How to Use:
  1. Enter DB20ORA in the SAP command field. 
  2. Select the “Update Database Statistics” option. 
  3. Select the “Oracle” option from the drop-down menu. 
  4. Select the “Update” button to update the database statistics. 
  5. Select the “View” button to view the current database statistics and compare them with the updated statistics. 
  6. Select the “Save” button to save any changes made to the database statistics. 
  7. Select the “Back” button to return to the main menu of DB20ORA. 
  
  Other Recommendations:
  It is recommended that users update their Oracle database statistics regularly in order to ensure optimal performance of their databases and queries. Additionally, users should be aware of any changes made to their database statistics and should save any changes made in order to ensure that they are not lost in case of a system failure or other issue.