10:45:20 SYS@zkm(1)> select * from table(dbms_xplan.display_cursor(null,null,'allstats last')); PLAN_TABLE_OUTPUT --- SQL_ID aq3ptnvdvmnpq, child number 0 --- update t1 set (t1.owner, t1.object_name) = (select t2.
使用dbms_xplan.display_cursor function的时候发现如下错误。 SQL> select * from table(dbms_xplan.display_cursor); PLAN_TABLE_OUTPUT --- User has no SELECT privilege on V$SESSION SQL> 然后查看官网发现这么几句话: This package runs with the privileges of the calling user, not the package owner ...
Session altered. SQL>updatebsetb.object_name=(selecta.object_namefromawherea.object_id=b.object_id); 99rows updated. SQL>select*fromtable(dbms_xplan.display_cursor(null,null,'ALLSTATS LAST')); PLAN_TABLE_OUTPUT --- ---
CREATE TABLE "TEST6" ( "ID" VARCHAR2(30), "NAME" VARCHAR2(30), "AG...
我使用DBMS_XPLAN.DISPLAY_CURSOR（使用V $ SQL中的sql_id）检查查询计划。 我有一个半复杂的...
SQL> select * from table(dbms_xplan.display_cursor); PLAN_TABLE_OUTPUT --- User has no SELECT privilege on V$SESSION SQL> 然后查看官网发现这么几句话: This package runs with the privileges of the calling user, not the package owner (SYS). The table function...
CREATE TABLE "TEST6" ( "ID" VARCHAR2(30), "NAME" VARCHAR2(30), "AG...