How To Maintain and Optimize the Oracle Database for DocuShare 6.5.x
Note: This solution applies to DocuShare 6.5.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.
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.”
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:
dbms_stats.gather_schema_stats(ownname => upper('&ownername'),
cascade => TRUE, options => 'GATHER');
Solution Updated: September