Locks on oracle database & Oracle applications Processing.

Posted by Jiltin     Tags: , , 1 March, 2009    5,545 views    (0) Comment

In a single-user database, the user can modify data in the database without concern for other users modifying the same data at the same time. However, in a multiuser database, the statements within multiple simultaneous transactions can update the same data. Transactions executing at the same time need to produce meaningful and consistent results. Therefore, control of data concurrency and data consistency is vital in a multiuser database. * Data concurrency means that many users can Read Full Article (Click here)...

Categories : 11i DBA Scripts, 11i Scripts, Oracle Applications, Scripts Oracle Tags : , ,