Oracle Timed out error in uCMDB - SM sync

We are facing sql timed out error while pushing the data from uCMDB to SM where in it is happening fine for other tables.

But , it is causing the error for only one table that too the amount of data is less.

We are coming across this issue when we do delta synch not necessarily always.

I tried re-triggering for full synch for the same table then it worked fine without any timeout errors.

I tried chnaging the DB-query timeout in gloablsettings.xml of uCMDB still it didnt work.

Could you please let us know what might be wrong with this.

Also, kindly let us know which and all tables will get updated w.r.t integration point/job.

Thanks in advance