Update taking time because of db file sequential read.

[paragp1981]

still i think what slimdave is saying is true ub query is getin executed 52128446 times so i have asked developer to change login probabily going for cursor or some thing with bulk collect

[tamilselvan]

Well size of these each tables is around 15-16 GB. So i cant really create
these temp table that will require huge space .
but if you run

(select sum(rated_volume)/60 from tnpostpaid.rtx_jul_aug
where r_p_contract_id=bm.co_id and
r_p_customer_id=bm.customer_id and
rtx_ent_date>=bm.act_date and
rtx_ent_date<=bm.end_date and
sncode=1 and call_type=1 and xfile_ind='H')

Then,

To speed up the subquery create an index on
sncode, call_type, xfile_ind, rtx_end_date, r_p_customer_id , r_p_contract_id, rated_volume.

Also, post the view definition.

Tamil