Re: PL/SQL ref cursors vs. plain SQL
From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Wed, 16 Sep 2015 22:28:32 +0300
Message-ID: <CAOVevU6K84VmRYzU4XBYFKrKZG1foc5qD3aFfN7a9iNfqqptVw_at_mail.gmail.com>
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
Date: Wed, 16 Sep 2015 22:28:32 +0300
Message-ID: <CAOVevU6K84VmRYzU4XBYFKrKZG1foc5qD3aFfN7a9iNfqqptVw_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Sep 16 2015 - 21:28:32 CEST