Anyway your sql statement doesn't use temp space or sort_are_size since you are not using order by in your SQL . You got to increase shared pool size to avoid your problem.