Oracle Content Services uses Oracle Database Cost-Based Optimizer (CBO) to determine the most efficient way to run SQL statements. For the CBO to work properly, the Oracle Content Services analyze.sql script needs to be run as part of regular Oracle Content Services operations, especially after large volume changes to the data, such as after users have loaded a large number of files into the database instance. This script generates statistics about the distribution of data in Oracle Content Services so that the CBO can choose the most efficient way to execute SQL statements.
To run the script, enter the following at the command line:
$ cd ORACLE_HOME/content/admin/sql
$ sqlplus content_services_schema/password@connect_string @analyze.sql
content_services_schema
No comments:
Post a Comment