_OPTIM_PEEK_USER_BINDS

 Hi All,

I need a help in improving a sqlplan. In my prod server, _OPTIM_PEEK_USER_BINDS is set to false. A select query is going for FTS in my prod server and taking more than 10 seconds. The same sql with the same amount of data in my test server is going for index scan and producing a good plan(less than 3 ms). In test server this parameter is set to the default value, TRUE. All the other optimizer parameters are same in Prod and test.

Setting this parameter back to default value is not an option, as it will affect the other queries. Also creating an logon trigger for this schema is not possible, because most of the sql queries are executed from this schema.