Install > SA Core post-installation tasks > Enabling the Oracle automatic optimizer statistics collection

Enabling the Oracle automatic optimizer statistics collection

SA relies on Oracle’s Automatic Optimizer statistics collection to collect schema statistics used to avoid database performance degradation. By default, Oracle’s Automatic optimizer statistics collection should be enabled.

To verify that the Oracle Automatic optimizer statistics collection is enabled, perform the following steps:

  1. Enter the following commands in SQL*Plus:

    # su - oracle

    # sqlplus "/ as sysdba"

     

    set line 200

    col status format a10

    SELECT status FROM dba_autotask_client where client_name='auto optimizer stats collection';

    The output from the above statement should be as follows:

    STATUS

    ----------

    ENABLED

  2. If the status is not ENABLED, execute the following statement to enable Oracle’s Automatic Optimizer statistics collection.

    EXEC DBMS_AUTO_TASK_ADMIN.ENABLE(client_name => 'auto optimizer stats collection',operation => NULL, window_name => NULL);