Tài liệu Sybex OCA Oracle 10g Administration I Study Guide phần 8

The uncommitted transactions from the overnight batch jobs may lock tables that need to be
updated by clerical staff during the business day, causing a lock conflict.
Another typical cause of lock conflicts is using unnecessarily high locking levels. In the sidebar
“Packaged Applications and Locking” earlier in this chapter, we described a third-party
application that routinely locked resources at the table level instead of at the row level to be
compatible with every SQL-based database on the market. Developers may unnecessarily code
updates to tables with higher locking levels than required by Oracle 10g.