In this Document
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version: 5.0 and later [Release: 5.0 and later ]
***Checked for relevance on 30-Sept-2011***
GoalCost Based Optimzation (CBO) depends on correct statistics in a database to run queries efficiently. If the statistics are missing or stale, bad execution plans can be generated leading into slow execution of queries. Support may require a customer to send in their optimizer statistics to be analyzed if query performance is causing issues in the software.
To obtain an Oracle export / dump of the optimizer statistics of a Primavera database follow these steps (only necessary when sending in the statistics to Oracle|Primavera):
- In SQLPLUS execute the following query to create a table names STATS (if the table does not exist already):
exec dbms_stats.create_stat_table('ADMUSER', 'STATS');
- In SQLPLUS execute the following query to populate the STATS table with the optimzer statistics:
exec dbms_stats.export_schema_stats('ADMUSER', 'STATS');
- From a DOS command prompt on the Oracle Database Server or client run the following statement to export out the STATS table:
exp admuser/@ tables=stats file=\stats_dump.dmp
- Send the stats_dump.dmp to Oracle Customer Support.
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/38267/viewspace-730267/，如需转载，请注明出处，否则将追究法律责任。