Skip to Main Content
Forums

Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Need to tune DB

Prince_KaileenaJul 20 2013 — edited Jul 20 2013

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....

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 17 2013
Added on Jul 20 2013
#sql, #tuning
1 comment
267 views