关于oracle中hint语法错误导致视图一直处于查询状态
乖乖福 2018-02-01 10:20:05 -------------------------------------第一段----------------------------------------
SQL> select SQL_TEXT
2 from v$sqltext where SQL_ID='&sql_id' order by piece;
Enter value for sql_id: 01grdaq0u7gkg
old 2: from v$sqltext where SQL_ID='&sql_id' order by piece
new 2: from v$sqltext where SQL_ID='01grdaq0u7gkg' order by piece
SQL_TEXT
----------------------------------------------------------------
SELECT /*+ FULL(P) +*/ * FROM "V_JF_KUANXIANG" P
SQL>
--------------------------------------第二段-----------------------------------------
SQL> select SQL_TEXT
2 from v$sqltext where SQL_ID='&sql_id' order by piece;
Enter value for sql_id: bzr6zhk94ashb
old 2: from v$sqltext where SQL_ID='&sql_id' order by piece
new 2: from v$sqltext where SQL_ID='bzr6zhk94ashb' order by piece
SQL_TEXT
----------------------------------------------------------------
SELECT /*+ FULL(P) +*/ * FROM "V_JF_ERROR" P
SQL>
-----------------------------------以下是运维分析出来的------------------------------------
这个hint语法错误。
应该是
SELECT /*+ FULL(P) */ * FROM "V_JF_KUANXIANG" P
没有后面那个+号。
SELECT /*+ FULL(P) */ * FROM "V_JF_ERROR" P 这个是正确的写法。
请定位应用程序相关代码,修改SQL语句。