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?

SHARE, EXCLUSIVE, UPDATE

Can I use LOCK TABLE on a view?

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

What is ALTER ?

 

Advertisements