What are the disadvantages of PAGE level lock?

High resource utilization if large updates are to be done

What is lock escalation?

Promoting a PAGE lock-size to table or tablespace lock-size when a transaction has acquired more locks than specified in NUMLKTS. Locks should be taken on objects in single tablespace for escalation to occur.


What are the various locks available?


Can I use LOCK TABLE on a view?

No. To lock a view, take lock on the underlying tables.

What is ALTER ?