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

how to find database is running on PFILE or SPFILE

Below script will tells us if the database is running on PFILE or SPFILE  SELECT DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM sys.v_$parameter WHERE name = 'spfile'; OR SQL> show parameter spfile; NAME TYPE VALUE —— —— ———————————————— spfile string /u01/apps/oracle/10g/dbs/spfileorclkhan.ora parameter will tell you the location where the SPFILE is present as well.
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