Last updated on SEPTEMBER 15, 2016
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.1 to 220.127.116.11 [Release 10.2 to 11.2]
Information in this document applies to any platform.
This problem can occur on any platform.
- A statement can be very slow on 10g compared to 9i after gathering system statistics using dbms_stats.set_system_stats
- 10053 trace shows that IOTFRSPEED is of very high after gathering system stats
- This high value deceives the CBO causing more I/Os (especially in FTS)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms