Automatic Storage Management

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.......
continue reading "Automatic Storage Management" »

DATABASE LOCKS

When many users are performing transactions on the same database, database locks become inevitable. When a resource is locked, database users are put in a queue on a First In First Out (FIFO) basis for accessing that resource. In this article, a number of ways have been described to detect and......
continue reading "DATABASE LOCKS" »

OCA 1z0-042 Short Notes: Exam passing tips

Oracle architecture The size of the shared pool can be changed dynamically. The data dictionary cache of the shared pool holds the most recently accessed data dictionary information. The shared pool consists of a library cache and data dictionary cache. Control file, redo log file, and data......
continue reading "OCA 1z0-042 Short Notes: Exam passing tips" »

Skills required for Oracle test 1Z0-042

Oracle has specified eighty-five objectives under seventeen topics for Oracle 1Z0-042 (Oracle 10g: Administration I) test. Before taking the test, an individual should possess a good command over the following areas: Knowing about the architecture of Oracle 10g. Installing Oracle 10g.......
continue reading "Skills required for Oracle test 1Z0-042" »

THE FLASH RECOVERY AREA.

With the advancement in technology, there has been a drastic increase in the information that a database can hold. Big enterprises and organizations have to store billions of records to be always up-to-date with all the information required. In such a scenario, the risk of data loss also goes up.......
continue reading "THE FLASH RECOVERY AREA." »

THE ORACLE 10g ARCHITECTURE

With the advent of so many big enterprises, the need to create a more sophisticated DBMS has also increased. For appointment as a DBA, a high level of skill and expertise is required. The major tasks that should be performed by a DBA are as follows: Judging what server hardware will be......
continue reading "THE ORACLE 10g ARCHITECTURE" »

Things to practice for Oracle 10g administrative test 1Z0-042.

The certification test for Oracle 1Z0-042 requires sound knowledge of administrative tasks to manage the database. This test demands a thorough knowledge of various administrative tools available in Oracle 10g to manage a database in a very sophisticated manner. The candidate must have a solid......
continue reading "Things to practice for Oracle 10g administrative test 1Z0-042." »

Architecture of Oracle Instance

The Oracle architecture consists of a number of primary components: Orace server: Oracle instance Oracle database Oracle instance An oracle instance is the combination of various background processes and memory structures. The background processes consist of PMON, SMON, DBWR,......
continue reading " Architecture of Oracle Instance" »

TheDatabase Configuration Assistant (DBCA) FEATURE

The Database Configuration Assistant (DBCA) is Graphical User Interface (GUI) tool. DBCA is one of the three ways used to create a database. It provides a user-friendly, wizard based, and step-by-step process to create a database. It is java-based. The DBCA enables us to specify memory options,......
continue reading " TheDatabase Configuration Assistant (DBCA) FEATURE" »

How to install Oracle 10g software?

Take the following steps to install Oracle10g software: The Oracle Universal Installer (OUI) is used to install and configure the Oracle 10g software. Mount the CD in the server's CD-ROM. The Welcome window will be displayed as follows: Click the Next tab to proceed. The......
continue reading "How to install Oracle 10g software?" »