ACS and bind variable peeking does not kick in when using TOAD
GOOD NEWS is, It will kick in soon. Last week, when i was investigating a performance issue, i have observed that an identical query results in different execution plans in TOAD and sqlplus. According to the " Doc ID 1671642.1 How To Diagnose Why an Identical Query Has Different Plans (and Performance) in Different Environments ", there may be different factors in plan selection, Although not all, Some of them are as follows. Statistics * Base Object Statistics * System Statistics * Dynamic Statistics (OPTIMIZER_DYNAMIC_SAMPLING) * Statistics Feedback (_OPTIMIZER_USE_FEEDBACK) Physical Differences * Physical and Logical Layout of the Database * Different volume and distribution of data * Different block sizes (DB_BLOCK_SIZE) * Schema Changes Settings and Features * Parallelism * Baselines, Profiles and Stored Outlines * Bind Variables Optimizer and System Parameters * SPFILE/PFILE * PGA and SORT AREA