What action should be taken to prevent this problem in the future?

The following message is received: Lock table overflow – user id user32, session id 54.

What action should be taken to prevent this problem in the future?
A . Run onclean utility to clear the lock table.
B . Increase the LOCKS configuration parameter.
C . Turn on the AUTO_TUNE configuration parameter.
D . Change the DEF_TABLE_LOCKMODE configuration parameter from page to row.

View Answer

Answer: B