861100 wrote:my white car fails to go, but my blue car goes.
Hi support ,
we have an issue here , we have 2 nodes (medi01,medi02) when we try to execute query
on node 1 it's take more time and then there is no result but the same query on node 2 it running fast after killing first one ,
any query that access CALLING table on node 1 it failed but it is normal execution on node 2.
please tell me if you need more ...
select * from( select CALLINGPARTYNUMBER,CALLEDPARTYNUMBER,CALLSTARTTIME, CALLSTOPTIME,CALLDURATION,CALLCOST,BALANCEBEFORECALL, BONUSCOST,BONUSBALANCEBEFORE from med_view.VU_EPPC_CALLING_DATA where CALLINGPARTYNUMBER in ('07480601376','007480601376','0096407480601376','+96407481416396') order by CALLSTARTTIME desc) where rownum <= 50