SAP Note 1017970 - DBMS_ADVISOR may result in deadlock

Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/1017970 (SAP Service marketplace login required)

Key words :
prerequisites oracle 10g r2, run sql statement analyses, set parameter   query_rewrite_enabled = truesince, symptom work processes encounter, dbms_advisor pl/sql package, terms row cache lock, row cache deadlock, processes immediately encounter, require constant updating, alter system command

Related Notes :

619188FAQ: Oracle wait events