How to Gather Optimizer Statistics on 12c (Doc ID 1445302.1)
来源:互联网 发布:怎么给mac照片分类 编辑:程序博客网 时间:2024/05/22 01:27
In this Document
APPLIES TO:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database - Standard Edition - Version 12.1.0.1 and later
Oracle Database - Personal Edition - Version 12.1.0.1 and later
Information in this document applies to any platform.
GOAL
This Document outline the recommended method to gather a standard set of optimizer statistics for use by the Cost Based Optimizer under Oracle 12c. For other versions see:
Document 1226841.1 How To: Gather Statistics for the Cost Based Optimizer
NOTE: There is a presentation entitled "Best Practices for Managing Optimizer Statistics" available in :
Which also addresses and provides specific tips on this subject.
Document:1380043.1 Selected Performance Related Seminars from Oracle Openworld
Which also addresses and provides specific tips on this subject.
SOLUTION
Currently,the recommendations for gathering statistics for 12c are the same as for 11g. Please refer to the following 11g document for gathering recommendations:
Document 749227.1 How to Gather Optimizer Statistics on 11g
As soon as there are any new 12c specific changes are required, we will update this 12c specific article with those.
REFERENCES
NOTE:465787.1 - How to: Manage CBO Statistics During an Upgrade from 10g or 9i into 11gNOTE:470316.1 - Using Actual System Statistics (Collected CPU and IO information)
NOTE:743507.1 - How to Benefit from Automatic Maintenance Tasks Following the Removal of the GATHER_STATS_JOB in 11g?
NOTE:756734.1 - 11g: Scheduler Maintenance Tasks or Autotasks
NOTE:44961.1 - Statistics Gathering: Frequency and Strategy Guidelines
NOTE:452011.1 - Restoring Table Statistics
NOTE:1226841.1 - How To: Gather Statistics for the Cost Based Optimizer
NOTE:1380043.1 - Selected Performance Related Seminars from Oracle Openworld (OOW)
NOTE:149560.1 - How to Collect and Display System Statistics (CPU and IO) for CBO use
NOTE:457926.1 - How to Gather Statistics on SYS Objects and 'Fixed' Objects?
NOTE:236935.1 - Global statistics - An Explanation
NOTE:237901.1 - Gathering Schema or Database Statistics Automatically in 8i and 9i - Examples
0 0
- How to Gather Optimizer Statistics on 12c (Doc ID 1445302.1)
- How to Gather Optimizer Statistics on 9i (Doc ID 388474.1)
- How to Gather Optimizer Statistics on 10g (Doc ID 605439.1)
- How to Gather Optimizer Statistics on 11g (Doc ID 749227.1)
- How To: Gather Statistics for the Cost Based Optimizer (Doc ID 1226841.1)
- How to Setup Active DataGuard on Exadata (Doc ID 1580796.1)
- How to Collect and Display System Statistics (CPU and IO) for CBO use (Doc ID 149560.1)
- How to change hostname for E-Business Suite Release 12 on single node (Doc ID 1277556.1)
- How to add Oracle OLAP to a 12c Database? (Doc ID 1936550.1)
- Gathering Statistics for the Cost Based Optimizer (Pre 10g) (Doc ID 114671.1)
- Gathering Statistics on a Logical Standby (Doc ID 376406.1)
- 【翻译自mos文章】How to Set or Switch Oracle Homes on Windows (Doc ID 969581.1)
- How to deinstall OCM (Doc ID 761313.1)
- How to Configure A Second Listener on a Separate Network in 11.2 Grid Infrastructure (Doc ID 1063571
- How To Setup Password Security? (Doc ID 564125.1)
- How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1)
- How Cost Collector Transfers Cost To Projects (Doc ID 412562.1)
- How to Relocate and Rename SYSTEM datafiles (Doc ID 191540.1)
- How to Gather Optimizer Statistics on 11g (Doc ID 749227.1)
- 有些事,看透,别说透
- 备份U盘分区表,未雨绸缪
- hdu1556 Color the ball(线段树区间更新)
- 一些用过的小命令
- How to Gather Optimizer Statistics on 12c (Doc ID 1445302.1)
- Echarts 与 Extjs4 集成
- Win32网络操作
- How To: Gather Statistics for the Cost Based Optimizer (Doc ID 1226841.1)
- 『ANDROID』Java中的访问控制与修饰符
- Android 通过Jni调用Native
- 郝斌数据结构之快排
- Access中标题章节号排序
- 一些疑问