how can I get the ssql plan wrapped in a pl/sql block

From: �� Qinliu <Ivyliu_99_at_hotmail.com>
Date: Sat, 11 Mar 2017 01:36:34 +0000
Message-ID: <SG2PR01MB06870E8682AC7DE5E3DD69E086230_at_SG2PR01MB0687.apcprd01.prod.exchangelabs.com>

I execute a pl/sql blcok as following:
begin
select count(*) from sys_base where part_num='11111'; end;
I want to view the execute the sql plan select count(*) from sys_base where part_num='11111'' . However, in the v$sql I just get 'begin select count(*) from sys_base where part_num='11111'' end;'

so I can't view th plan . How can I view the sqls wrapped in pl/sql procedure.

Is there any way I can get the sql plan from a procedure or funcation

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Mar 11 2017 - 02:36:34 CET