Quote Originally Posted by tamilselvan
Also, change SUBSTR(cbs.LOCATOR,1,6) to LOCATOR like '1.1026%'
Been there.

Is that column actually text, or is it a number?

Also, use this method for getting the explain plan ...

Code:
set autotrace off

explain plan for select ...
/

select * from table(dbms_xplan.display)
/
It may reveal column constraints that are also being applied as filters -- that can be responsible for high CPU usage and a poor execution plan due to poorly estimated statistics.