RE: Different execution plans for same query with same cost

Nope, no RLS. But as I've replied to others, cursor_sharing=force.

mvg/regards

Jo

"Powell, Mark D" <mark.powell_at_eds.com>
Sent by: oracle-l-bounce_at_freelists.org
03/03/2005 18:22
Please respond to mark.powell  

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        RE: Different execution plans for same query with same cost

Depending on exactly what you mean by the same query since you give no details on the query itself could the results you are seeing be the results
of bind variable peeking? Is RLS in use on this DB?

HTH -- Mark D Powell --

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 03 2005 - 13:07:01 CST