1 Reply Latest reply on Jul 20, 2013 1:26 PM by Srini Chavali-Oracle

    Need to tune DB


      Hi Folks,


      I am having 7 lacs records in one table.

      Table having id,name,address,pincode,etc etc.

      I have 17 indexes on the table.

      While fetching data from table like:

      ex:select empname from employee where empname like 'AB%' order by employee name;

      Result:Session time out error!!!(We set session of 180 sec)

      We do not want to increase session time.

      Please suggest ur inputs....