hint

_optimizer_ignore_hint

Sometimes application queries come with the specific hint, which may impact your database performance. And it is difficult to find and remove these hints from each query. Oracle provided an undocument...

ENABLE_PARALLEL_DML hint in oracle 12c

Till oracle 12c, For doing DML transactions in parallel, we need to enable PDML (parallel DML) at session level. I.e before any DML statement, we need to issue below statement. ALTER SESSION ENABLE PA...