oracle explain planITeye - AG环亚娱乐

oracle explain planITeye

2019-01-11 00:26:36 | 作者: 觅云 | 标签: 方法,敞开,提示 | 浏览: 1258

explain plan for select count(*) from emp;

select * from table(dbms_xplan.display);

 

 

二、AUTOTRACE方法:

敞开set autotrace on 后,提示:

Unable to gather statistics please unsure user has correct access.
The statistic feature requires that the user is granted select on v_$sesstat, v_$statname and v_$session.

 按要求对三个视图grant select后,仍是报错,还需对v_$mystat也grant select

版权声明
本文来源于网络,版权归原作者所有,其内容与观点不代表AG环亚娱乐立场。转载文章仅为传播更有价值的信息,如采编人员采编有误或者版权原因,请与我们联系,我们核实后立即修改或删除。

猜您喜欢的文章