This can cause significant slowdown in the performance of the individual query.
The Oracle database administrator will always try changing the optimizer mode for queries as the very first step in Oracle tuning.