Articles & Tutorial for OCA DBA 10g certification
All articles for OCA DBA 10g certification
Tips and How Tos for OCA DBA 10g certification
Architecture of Oracle Instance
in OCA DBA 10g
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
in OCA DBA 10g
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" »
Automatic Storage Management
in OCA DBA 10g
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
in OCA DBA 10g
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" »
How does an Oracle shared server differ from a dedicated server?
in OCA DBA 10g
In a dedicated server process, every user process on a client computer is connected to a separate virtual dedicated server process (shadow process) on the computer on which the Oracle server is installed. Each client's request is processed by a separate dedicated server. The server process...
continue reading "How does an Oracle shared server differ from a dedicated server?" »
How is an Oracle database opened?
in OCA DBA 10g
The STARTUP command is used to open an Oracle database. Only a database administrator can open an Oracle database. An Oracle database is opened in three stages. First, an Oracle instance is started. Then, the instance mounts the specified database. Finally, the database is opened.
When...
continue reading "How is an Oracle database opened?" »
How to check whether a database has used a PFILE or an SPFILE?
in OCA DBA 10g
A database user will run the following SQL query to check whether a PFILE or an SPFILE has been used by the database:
SELECT DECODE (value, NULL, 'PFILE', 'SPFILE') "Init File Type"
FROM sys.v_ WHERE name = 'spfile';
Alternatively, a database user can use the V view...
continue reading "How to check whether a database has used a PFILE or an SPFILE?" »
How to install Oracle 10g software?
in OCA DBA 10g
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?" »
OCA 1z0-042 Short Notes: Exam passing tips
in OCA DBA 10g
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" »
Role to export data
in OCA DBA 10g
In order to perform a full database export, a database user should have the EXP_FULL_DATABASE role.
continue reading "Role to export data" »
