Certification Completion

I have completed my OCA 10g Certification. Working on OCP now....

Comments

Post a Comment

Welcome to the Oracle DBA Blog.

Stay Hungry Stay Foolish

Popular posts from this blog

Oracle RAC Interview Question and Answers 10G and 11G/ 12c

Image
1. What is the major difference between 10g and 11g RAC? Well, there is not much difference between 10g and 11gR (1) RAC. But there is a significant difference in 11gR2. Prior to 11gR1(10g) RAC, the following were managed by Oracle CRS Databases Instances Applications Node Monitoring Event Services High Availability From 11gR2(onwards) its completed HA stack managing and providing the following resources as like the other cluster software like VCS etc. Databases Instances Applications Cluster Management Node Management Event Services High Availability Network Management (provides DNS/GNS/MDNSD services on behalf of other traditional services) and SCAN – Single Access Client Naming method, HAIP Storage Management (with help of ASM and other new ACFS filesystem) Time synchronization (rather depending upon traditional NTP) Removed OS dependent hang checker etc, manages with own additional monitor process 2.  What are Or...
Read more

Oracle 11g Architecture

Image
What is an Oracle Database? A database is a collection of data. An Oracle database holds its data in a coordinated set of files stored on disk, including following types:     Parameter Files - The Oracle Parameter File (PFILE or SPFILE) holds initialization parameters which indicate where the control files are, how memory is allocated, how logging is performed, and other characteristics of the Oracle instance.     Control Files - The Control File stores information needed to verify that the database is consistent, including a list of all database files making up the instance and other important data.     Redo Log Files - The Redo Log files store a sequence of entries describing all actions taken against the database. This data is used to recover a database in the event of instance failure.     Data Files - The Data Files contain blocks of data which store database objects (e.g., tables, indexes, materialized views, etc....
Read more

Oracle Lock

Oracle Locks User must request a resource (i.e row,table,index etc) before using it and must release that resource after using it. Without following above approach there would be collision among user requests which result data to be in inconsistent.To avoid data inconsistency a lock mechanisim adopted within different database,Every database has its own locking mechanism. Oracle uses two modes in a multiuser database either its on table or row Exclusive lock mode Exclusive lock mode never allowed the associates resource from being shared.This lock mode is obtained to modify data.Only one exclusive lock can be placed on a resource (such as a row or a table). i.e From one session i acquire the exclusive lock on resource (emp table) Session a SQL> lock table emp in exclusive mode nowait   2   / Table(s) Locked. Note : The optional keyword NOWAIT tells Oracle not to wait for a table if it has been locked by another user. From another session i tr...
Read more