Explain how to lock and unlock a user account in
Oracle - April 10, 2009 at 11:00
Explain how to lock and unlock a user
account in Oracle.
SQL> ALTER USER user_name ACCOUNT LOCK;
SQL> ALTER USER user_name ACCOUNT UNLOCK;
Latches are used to protect Oracle data structures to be modified
or run by more than one process. They are more restrictive than
locks. Locking has a similar concept...............
Software area code: - It is a protected location that is used to
store oracle code that is supposed to be run. The location is
different from users' programs. The software area code is read only
and can be shared or nonshared...............
Locking protect table when several users are accessing the same
table. Locking is a concurrency control technique in oracle. It
helps in data integrity while allowing maximum..........
READ COMMITTED: If row locks are obtained by a certain
transaction, then any other transaction that contains DML needs to
wait until the row locks have been released by that particular transaction..............