Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

enqueue_resources is obsolete in 10g2.How 10g2r control resource enqueue?

575433May 2 2007 — edited May 2 2007
The 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?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 30 2007
Added on May 2 2007
1 comment
1,058 views