from
   FacialFinReestr ffr
   left join RecordParams rp on (ffr.id = rp.id)
   left join FacialFinCaption ffc on (ffc.Reestr_ref = ffr.id)
   left join PAYDOCEXCHANGE pde on (pde.PAYDOCREF=ffc.id and (pde.TypeInf BETWEEN 0 and 10))

SQL> show parameter result;
 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
client_result_cache_lag              big integer 3000
client_result_cache_size             big integer 0
result_cache_max_result              integer     5
result_cache_max_size                big integer 155328K
result_cache_mode                    string      AUTO
result_cache_remote_expiration       integer     0
 

begin
  DBMS_RESULT_CACHE.Flush;
end;