Explain plan for long running query in oracle sql developer -

i have below select query long running , want view query execution plan understand why query long running , statement in sql query affecting query performance. using oracle sql developer , checked explain plan below query did not understood statement effecting query optimize query.

select * provisioning_log@fonic_retail pl  join provisioning_task@fonic_retail pt on pl.provisioning_task_id = pt.id join service@fonic_retail ser on pt.service_id = ser.id join temp_wf_def_all tt on ser.subscription_id = tt.subscription_id pt.code='migopt_pack' , pt.description '%cvb request' , pt.parameters '%operation=add%' , pl.response_type null , pl.request not null  , ((to_char(pt.start_date,'yyyymmddhh24mi') = to_char(tt.complete_date,'yyyymmddhh24mi'))  or (to_char(pt.start_date,'yyyymmddhh24mi') = to_char(tt.complete_date + 1/1440,'yyyymmddhh24mi'))) , pl.time_stamp < sysdate - numtodsinterval (  30,'minute' )  , pl.time_stamp > sysdate - numtodsinterval ( 4,'hour' )  , tt.start_date < sysdate - numtodsinterval (  30,'minute' ) , tt.start_date > sysdate - numtodsinterval ( 4,'hour' )  , tt.wf_name in  ('subscribe lidl community flat', 'ldlmonatsflatrate subscribe'); 

query execution plan above query:

as using mix of local tables , remote tables. if tables on remote database larger ones on local database might need use driving_site hint smaller of set of tables moved database issuing call.

driving_site