Suppose that you have a buffer cache of 30Mo and you have a cursor (in a PL/SQL procedure)
which needs 40Mo (cursor Cr is select c1, c2, c3 from T1 order by c1, c2).
How Oracle will behave ?
(in the PL/SQL code, every cursor row will be used in many sql queries...).