Oracle Error ORA-10979: trace flags for join index implementation

Oracle Error Message

ORA-10979: trace flags for join index implementation

Reason for the Error

This is an informational message.

Solution

Values are as follows: LEVEL ACTION ————————————————————————— > 1 Dump refresh expressions (SQL) to trace file. > 999 If a complete refresh is invoked, it will not be performed but the system will assume that a complete refresh was done, causing the view to be VALID and updating timestamps. This should be used only under Oracle Support supervision.