8.7.2 Using Database Statistics Management

The system calls each script as part of nightly processing at the appropriate time and with the appropriate parameters:

  • MANTAS Schema: analyze_mantas.sh [TABLE_NAME] <analysis_type>
  • BUSINESS Schema: analyze_business.sh [TABLE_NAME] <analysis_type>
  • MARKET Schema: analyze_market.sh [TABLE_NAME] <analysis_type>

The <analysis_type> parameter can have one of the following values:

  • DLY_POST_LOAD: Use this value to update statistics on tables that the system just loaded (for BUSINESS and MARKET schemas).
  • ALL: Use this once per week on all schemas.
  • DLY_POST_HDC: Use this value to update statistics of the alert-related archived data (in _ARC tables) in the BUSINESS and MARKET schema tables that the Behavior Detection UI uses to dis- play alerts.
  • DLY_PRE_HDC: Use this value to update statistics of the Mantas schema tables that contain the alert-related information.

    Tip:

    Oracle recommends that you do not modify the tables for DLY_POST_HDC and DLY_PRE_HDC. The Behavior Detection Historical Data Copy procedures use these tables to archive alert- related data.
  • DLY_POST_LINK: Use this value to update statistics of the Mantas schema tables that contain network analysis information. Run this option at the conclusion of the network analysis batch process.

The [TABLE_NAME] parameter optionally enables you to analyze one table at a time. This allows scheduling of the batch at a more granular level, analyzing each table as processing completes instead of waiting for all tables to complete before running the analysis process.

The metadata in the KDD_ANALYZE_PARAM table drive these processes. For each table in the three schemas, this table provides information about the method of updating the statistics that you should use for each analysis type. Valid methods include:

  • EST_STATS: Performs a standard statistics estimate on the table.
  • EST_PART_STATS: Estimates statistics on only the newest partition in the table.

    Note:

    For the EST_STATS and EST_PART_STATS parameters, the default sample size that the analyze procedure uses is 5% of the table under analysis. To change the sample percentage, update the SAMPLE_PT column of the desired record in the KDD_ANALYZE_PARAM table.
  • IMP_STATS: Imports statistics that were previously calculated. When running an ALL analysis, the system exports statistics for the tables for later use.

    Caution:

    Failure to run the statistics estimates can result in significant database performance degradation.

These scripts connect to the database using the user that the utils.database.username property specifies, in the <INSTALL_DIR>/ database/db_tools/mantas_cfg/install.cfg file. The install.cfg file also contains the following properties:

  • schema.mantas.owner
  • schema.market.owner
  • schema.business.owner

The system derives schema names from these properties.