Atlas Hub comes with some SQL scripts written specifically for use with your database. These scripts help you maintain and tune Atlas Hub databases. You run some SQL scripts after installation, some on a weekly basis for database performance maintenance, and some scripts are run for you automatically by Atlas Hub.
The SQL scripts for Oracle schema users that you may run are located in the Micro Focus\Hub\DBScripts\Oracle_Scripts folder.
The following table lists the SQL scripts that you are most likely to need. Some should be run manually on a regular basis. The table recommends the frequency for running these scripts. You may adjust the frequency depending on the Atlas Hub usage at your facility. Run scripts at times when the server is least used, such as overnight or on weekends.
In addition to running these scripts, you should also run a Purge option from the Server Administration tool to remove deleted views from the database. We recommend purging the database after you have deleted one or more views from a project. See the Server Administration Tool Help for information on the Purge option.
StarTeam Script Name | Run Frequency |
---|---|
starteam_oracle_compute_stats.sql | Weekly |
starteam_oracle_dropall.sql | Only if necessary |
starteam_oracle_rebuild_indexes.sql | Weekly |
To run a SQL script for Oracle schema users:
For example, to execute the starteam_oracle_compute_stats.sql script, type @starteam_oracle_compute_stats.sql and press Enter.