Ref cursors are more convenient for me because it is simpler to find what
procedure calls the query(sql_id) or which procedures/packages generate
most load
Best regards,
Sayan Malakshinov
Oracle ACE Associate, Oracle performance tuning expert
http://orasql.org