enqueue_resources is obsolete in 10g2.How 10g2r control resource enqueue?
575433May 2 2007 — edited May 2 2007The enqueue_resources is used in 9i but it is obsolete in 10g2r.ENQUEUE_RESOURCES sets the number of resources that can be concurrently locked by the lock manager. An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with enqueues. For example, Oracle allows varying levels of sharing on tables: two processes can lock a table in share mode or in share update mode.
How does 10g2r controls resource enqueue?Is there a new parameter that is related with enqueue resources?