No relevant resource is found in the selected language.

This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read our privacy policy>Search


To have a better experience, please upgrade your IE browser.


eSight V300R009C00 Single-Node System Software Installation Guide (SUSE Linux) 09

Rate and give feedback:
Huawei uses machine translation combined with human proofreading to translate this document to different languages in order to help you better understand the content of this document. Note: Even the most advanced machine translation cannot match the quality of professional translators. Huawei shall not bear any responsibility for translation accuracy and it is recommended that you refer to the English document (a link for which has been provided).
Modifying Running Parameters of the Oracle Database

Modifying Running Parameters of the Oracle Database

You can execute the Oracle configuration script to optimize the database running memory and enable the scheduled task for clearing the database audit logs.



The Oracle logs are not deleted for a long time. As a result, the disk space usage is high or the partition is used up, and eSight is unavailable. You can manually execute the script in the eSight installation package to perform optimization as follows:

  • The Oracle running memory is set to one fourth of the total memory of the server.
  • Database audit logs are kept for one week.

    Deleted logs cannot be restored. Excise caution when executing the script.


  1. Log in to the server as the ossuser user.
  2. Switch to the root user.

    > su - root

  3. Copy the script from the eSight installation directory to the Oracle home directory. Here, the installation directory /opt/eSight is used as an example.

    # cp -rpf /opt/eSight/AppBase/uninstall/scripts/cleanScripts/oracle/ ~oracle

  4. Set the owner and group of the script.

    # cd ~oracle

    # chown oracle:dba

  5. Switch to the oracle user and execute the script.

    # su - oracle

    > sh ./

  6. Restart the database.

    > sqlplus / as sysdba

    SQL> shutdown immediate

    SQL> startup

    SQL> exit

  7. Check whether the database memory is set successfully.
    1. Run the following command to obtain the total memory of the server, in MB:
      free -m | grep Mem | sed 's/ /\n/g' |sed '/^[[:space:]]*$/d' |sed -n '2p'
    2. Log in to the database and query the maximum running memory of the database. In the query result, VALUE should be one fourth of the total memory of the server. (This is not an accurate value. The Oracle automatically adjusts the memory value slightly.)
      sqlplus / as sysdba
      SQL>show parameter
      NAME                                 TYPE                   VALUE
      ---------------------- ------------------------------
      memory_max_target                    big integer            3988M
  8. Check whether the log clearing task has been adjusted. In the query result, LAST_ARCHIVE_TS specifies a time one week before the script execution time, indicating that scripts of one week ago are all deleted.

    AUDIT_TRAIL                              RAC_INSTANCE
    ---------------------------------------- ------------
    OS AUDIT TRAIL                                      1 02-OCT-17 PM +08:00
    SQL> exit
Updated: 2019-05-17

Document ID: EDOC1100011860

Views: 93054

Downloads: 138

Average rating:
This Document Applies to these Products
Related Documents
Related Version
Previous Next