-> To truncate the instance table locks i.e. when one user locked the object and the user wants to lock the same object then dead lock condition occurs. At that time to truncate the instance tables from the back end.
Syntax:
Truncate instance_table_locks;
Truncate Table Locks
Related Posts
Vi editor in Linux
Its a visual editor by default installed in every linux system. The next version of vi is vim. The vi editor tool is an interactive tool as it displays changes…
Monitoring in Postgresql
In normal PostgreSQL operation, tuples that are deleted or obsoleted by an update are not physically removed from their table. They remain present until a VACUUM is done. Therefore it’s necessary to do VACUUM periodically, especially…