Therefore, we would like to continue checking the status of this sever provided that you do the following:\n1.\tCheck for any session that is potentially hugging your memory resources if there?s any.\n2.\tUsermod the concerned tables on the payrefno query.\n3.\tIngstop the instance\n4.\tRecalculate parameters \na.\tOpen CBF\nb.\tClick on Locking System > Configure > Derived\nc.\tSelect lock_limit\nd.\tIf protected column states ?yes?, select protect to unprotect it\ne.\tSelect recalculate\nf.\tDo steps c,d,e for resource_limit parameter\ng.\tSave changes\nh.\tExit CBF\n5.\tIngstart the instance\n6.\tCheck if you have sufficient memory (Take note of this before step #7)\n7.\tRun the payrefno query (On an isolated environment, no users)\n8.\tCheck if the memory status (Take note of this)\n9.\tCheck if this SQL still hugs memory resources\n10.\tIncrease memory, redo steps #s 3-5.\n\n