I am running following block in the sys schema and one of my user schemas and there is considerable difference in execution times.
declare
l number;
begin
for i in 1..500000
loop
select 1 into l from dual;
end loop;
end;
In sys schema this completes in 14 seconds whereas in the use schema it takes 24 seconds. The resource manager plan is default maintenance plan.
Thanks!