Articles & Tutorial for OCP DBA 9i certification
All articles for OCP DBA 9i certification
Tips and How Tos for OCP DBA 9i certification
Skills required for Oracle test 1Z0-033.
in OCP DBA 9i
Oracle has specified around 70 objectives for this test under 15 topics. Following are the important areas in which an individual should possess good knowledge before taking the O1Z0-033 test:
PL/SQL programming language. Knowledge of database concepts. Knowledge of backup and recovery...
continue reading " Skills required for Oracle test 1Z0-033." »
How are archive destinations specified?
in OCP DBA 9i
When archiving redo logs, it must be decided whether to archive them to a single archive destination or multiplex them. When the archived redo logs are multiplexed, they are archived to more than one archive destination. The following two methods can be used to specify archive destinations:...
continue reading "How are archive destinations specified?" »
How are materialized views managed?
in OCP DBA 9i
Materialized views can be created either through the CREATE MATERIALIZED VIEW statement or the Oracle Enterprise Manager (OEM). The CREATE MATERIALIZED VIEW statement can also be used for populating the materialized views. A materialized view can be derived from an existing user-defined...
continue reading "How are materialized views managed?" »
How are the archived redo log files' names determined when automatic archiving is enabled?
in OCP DBA 9i
When a database is running in ARCHIVELOG mode, and automatic archiving is enabled, the archiver process (ARCn) automatically archives the filled online redo log files at specified archive destinations. ARCn automatically decides the names of the archived redo log files by looking at the...
continue reading "How are the archived redo log files' names determined when automatic archiving is enabled?" »
How does Database Resource Manager perform database resource management?
in OCP DBA 9i
The Database Resource Manager (DRM) is a tool, which handles the resource allocation issues in a more efficient way than can probably be done by the operating system itself. Such issues include equal distribution of resources by the operating system to every active process, inability of the...
continue reading "How does Database Resource Manager perform database resource management?" »
How does Instance Manager kill a session causing lock contention?
in OCP DBA 9i
The Instance Manager tool of the Oracle Enterprise Manager can be used for killing a user session that is causing lock contention. The user session can be killed in the following manner: By expanding the session branch on the left hand side of the Instance Management window. By clicking the...
continue reading "How does Instance Manager kill a session causing lock contention?" »
How is a checkpoint related to the cache recovery phase of a recovery process?
in OCP DBA 9i
At certain time intervals, the database writer (DBWn) writes all modified (dirty) buffers from the database buffer cache to the data files on disk. This event is called a checkpoint. Whenever a checkpoint occurs, the checkpoint process (CKPT) updates the headers of data files and control files...
continue reading "How is a checkpoint related to the cache recovery phase of a recovery process?" »
How is a client/server connection established in a dedicated server environment?
in OCP DBA 9i
In a dedicated server environment, a listener (the listener must be running on the same computer on which the server is running) starts a separate dedicated server process for each incoming client connection request. Based on the operating system and the transport protocol, the listener can use...
continue reading "How is a client/server connection established in a dedicated server environment?" »
How is a client/server connection established in a shared server environment?
in OCP DBA 9i
In a shared server configuration, a fixed number of shared server processes are automatically started when an Oracle instance starts. However, clients are not directly connected to shared server processes. They are connected to their corresponding dispatcher processes instead. The dispatcher...
continue reading "How is a client/server connection established in a shared server environment?" »
How is a listener configured?
in OCP DBA 9i
Oracle Universal Installer (the Oracle installation tool) launches Oracle Net Configuration Assistant during software installation. Oracle Net Configuration Assistant enables a user to configure the listening protocol addresses and service information for an Oracle database.
Oracle Net...
continue reading "How is a listener configured?" »
