Database Server Alert Log

This is one of the technical infrastructure data gathering methodologies and performance recommendations for server machines. The full list is defined in the Server Environment Recommendations topic here.

The DB Toolbox includes options for many troubleshooting tools.

Show DB Alert Log

If the alert log feature is enabled in the database, the database alert log can be analyzed via DB ToolBox, as follows:

  1. On the application server, go to the DB ToolBox, which is typically saved in the '/opt/stibo/step/admin/app-server-toolbox/' folder.
  2. Start the ToolBox using one of these commands:
  • ./db-toolbox.pl
  • perl db-toolbox.pl
  1. Execute DB ToolBox number 36: 'Show DB alert-log'.

Show Tablespace Usage Report

Determine the size of the TEMP tablespace using the DB Toolbox as follows:

  1. On the application server, go to the DB ToolBox, which is typically saved in the '/opt/stibo/step/admin/app-server-toolbox/' folder.
  2. Start the ToolBox using one of these commands:
  • ./db-toolbox.pl
  • perl db-toolbox.pl
  1. Execute DB ToolBox number 1: 'Show tablespace usage report'.

Example

Use the DB ToolBox and run the 'Show DB alert log' on the database to show out-of-space errors for the TEMP tablespace.

07-OCT-2017 02:01:03 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
07-OCT-2017 02:07:05 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
07-OCT-2017 02:12:52 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
07-OCT-2017 02:18:21 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP
07-OCT-2017 02:24:35 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP

This mainly occurs every weekend, but has also happened several times during weekdays. These errors indicate that important STEP tasks are failing, and should therefore be avoided.

Running the 'Show tablespace usage report' shows the current size of TEMP tablespace is one file of 32 GB.

In this example, the recommendation is to add at least one extra file of 32 GB, so the total size of the TEMP tablespace will be increased to 64 GB.

Additionally, other database alter log errors may include, for instance:

  • ORA-00060 errors: deadlock detected
  • ORA-01555 errors: snapshot too old

The further recommendation would be to involve a Stibo Systems system architect to analyze, recommend, and execute on the database alert errors, as well as on generic infrastructure and system setup.