oracle_清理数据库缓存

alter system flush shared_pool ;
alter system flush BUFFER_CACHE ;

 

 

create or replace procedure proc_test_cursor is
userRow newresult%rowtype;
cursor userRows is
select * from newresult;
begin
for userRow in userRows loop
update sys_edu_content edu set edu.time=userRow.time where edu.id=userRow.id;
end loop;
end proc_test_cursor;