Important

   

This space contains documentation for TrueSight Server Automation 8.9.03 and the later service packs for 8.9. For earlier releases, see BMC Server Automation 8.9.

Troubleshooting smart group issues

The following topics apply to troubleshooting smart groups:

Server smart group performance degrades

Server smart group performance might degrade if you are using an Oracle database and you apply more than one set of membership conditions. For example, there might be a long delay opening a server smart group. The delay can increase exponentially as a function of the number of membership conditions imposed on the group.

To optimize performance, the database administrator should connect as DBAdmin to the TrueSight Server Automation database and execute the following commands in SQL Plus:
exec dbms_stats.gather_schema_stats(ownname=>'schema_to_analyze', cascade => TRUE, options =>'GATHER', estimate_percent => dbms_stats.auto_sample_size);
alter system flush buffer_cache;
alter system flush shared_pool

Executing the dbms_stats.gather_schema_stats procedure can take several minutes. This procedure should return a message of PL/SQL procedure successfully completed.

Was this page helpful? Yes No Submitting... Thank you

Comments