Barbara, there is an undocumented parameter that prevents the optimizer from being a peeping Tom. The parameter is: _optim_peek_user_binds=FALSE -- Mladen Gogala Ext. 121 -----Original Message----- From: Barbara Baker [mailto:barb.baker@xxxxxxxxx] Sent: Friday, December 10, 2004 11:45 AM To: Oracle-L@xxxxxxxxxxxxx Subject: xplan row source 9i Did version 9i do some "bind variable peeking" that 8i did not do? If so, is there a hint to turn it off? -- //www.freelists.org/webpage/oracle-l