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 BMC 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.