1.用SYSDBA创建CLEAR_PLAN_CACHE存储过程
create PROCEDURE CLEAR_PLAN_CACHE(plan_id bigint) as BEGIN
SP_CLEAR_PLAN_CACHE(plan_id);
end;

2.给普通用户授权
grant exec on CLEAR_PLAN_CACHE to TEST;

3.普通用户登录后执行CLEAR_PLAN_CACHE
CALL SYSDBA.CLEAR_PLAN_CACHE(123);