Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What is mean by the Oracle error ORA-01986?

634151Apr 14 2009 — edited Jun 9 2009
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 7 2009
Added on Apr 14 2009
8 comments
2,053 views