| http://www.w3.org/ns/prov#value | - Filling the cache with 50000 records at once and fetching them takes 16 seconds.So, there is a noticable benefit of using the cache.When I fill the cache with values before running the procedure:select tst_ch.nextval from dual;NEXTVAL ?????????- 11 rij is geselecteerd.1 declare l_id number(12); 2 begin 3 dbms_output.put_line( ???start cache op ???||to_char(systimestamp)); 4 for r in 1..49999 5 loo
|
