Note:  This solution applies to DocuShare 6.x

The busier the Server, usage related to add, delete, modify data / objects, the more likely the Database Indexes will become stale at a higher frequency.  Therefore, the busier the Site the more often Indexes need to be updated to ensure they are in optimal condition.

It is recommended to run the segment advisor at least once a month to make sure that indexes are in good condition. The Segment advisor can be very useful in recommending objects that need “shrinking” and “compacting.”

You can optimize your Oracle database by keeping database statistics current. Run dbms_stats.gather_schema_stats to gather database statistics for the DocuShare schema. 

Run the following script:

Exec dbms_stats.gather_schema_stats(ownname => upper('&ownername'), estimate_percent =>

dbms_stats.auto_sample_size, cascade => TRUE, options => 'GATHER');

Solution Published: September 12, 2018

Solution 591