Don't use package DBMS_STATS to do that, using FND_STATS is a good command.
Also,don't use the ANALYZE command.
Eg.
Use the following command to gather schema statistics:
exec fnd_stats.gather_schema_statistics('PO')
exec fnd_stats.gather_schema_statistics('ALL')
Use the following command for gathering statistics on a temporary table
(ie: temporary tablename = temp1 in schema INV):
exec fnd_stats.gather_table_stats('INV','temp1');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/38542/viewspace-1043942/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
-
博文量235
-
访问量1707860
最新文章
- Two errors after cloning eBS
- An error from listener
- How to change the APPS db password in Oracle EBS
- Management on database link
- Three ways to quickly login into EBS 11i
- SMART Goal Setting
- A good template email on how to apply for training program
- 4C
- My understanding of AD configuration
- Taught Oracle database OCP training course
