Archive for the ‘OCP DBA 10g’ category

Locking is a mechanism implemented either on an entire table or a row. Locking avoids the destruction done by the transactions accessing the same resource. The resource may be data in a table or rows in a data dictionary.

DBVERIFY is an Oracle external command-line utility that performs a physical data structure integrity check. This utility is used on backup files, online databases, and offline databases. The utility is executed by issuing the DBV command at the command prompt.

Enterprises are preferably switching from old existing Oracle versions, such as Oracle 8i and Oracle 9i, to Oracle 10g to have various additional profitable features. They often employ the Automatic Storage Management (ASM) option to enhance the manageability and consolidation of a database.

Oracle 10g

The n-tier architecture is the most advanced type of architecture for a network configuration. This architecture introduces middleware components, such as application servers and Web servers between clients and the database server.

An example of the n-tier architecture is the Internet. The n-tier architecture is the most preferred architecture for an enterprise network. This architecture reduces processing load on the server.

An implicit lock is a lock that a row or a table acquires automatically, depending on the database operations such as ALTER TABLE, UPDATE, SELECT etc.

A deadlock refers to a condition, in which, two or more processes simultaneously wait for each other to complete, as a result of which both, or all of them, as the case may be, hang. Deadlocks are generally encountered in multitasking, multiprocessing, and client-server environments.