What is mean by the Oracle error ORA-01986?
634151Apr 14 2009 — edited Jun 9 2009Hi,
I got the Trace output in Oracle apps by use of FND_CTL.FND_SESS_CTL package. When i see my TK prof output some of the queries are giving ORA-01986: OPTIMIZER_GOAL is obsolete error message. See my snapshot below. Can anyone tell what is this?
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.00 0.00 0 4 3 0
Fetch 1 0.00 0.00 0 0 0 1
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 3 0.00 0.00 0 4 3 1
Misses in library cache during parse: 0
Optimizer goal: ALL_ROWS
Parsing user id: 173 (APPS)
Rows Row Source Operation
------- ---------------------------------------------------
1 FOR UPDATE (cr=4 pr=0 pw=0 time=157 us)
1 TABLE ACCESS BY INDEX ROWID FND_CONCURRENT_REQUESTS (cr=4 pr=0 pw=0 time=26 us)
1 INDEX UNIQUE SCAN FND_CONCURRENT_REQUESTS_U1 (cr=3 pr=0 pw=0 time=18 us)(object id 34547)
unable to set optimizer goal
ORA-01986: OPTIMIZER_GOAL is obsolete
parse error offset: 33
Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: ALL_ROWS
1 FOR UPDATE
1 TABLE ACCESS GOAL: ANALYZED (BY INDEX ROWID) OF
'FND_CONCURRENT_REQUESTS' (TABLE)
1 INDEX GOAL: ANALYZED (UNIQUE SCAN) OF
'FND_CONCURRENT_REQUESTS_U1' (INDEX (UNIQUE))
Elapsed times include waiting on following events:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
********************************************************************************
Thanks