Answer / monal

BLOCKING MEANS ONE PROCESS HAS LOCKS ON ONE OR MORE RECORDS
AND ANOTHER PROCESS TRIES TO ACQUIRE LOCK ON THE SAME SET OF
ROWS. SO BASICALLY SECOND PROCESS HAS TO WAIT TILL FIRST
PROCESS FINISH WORKING ON THE RECORDS AND THEN SECOND
PROCESS CAN TAKE OVER AND FINISH IT'S TASK. BLOCKING IS
DIFFERENT THEN DEADLOCK. BLOCKING CAN LAST LONGER AS IT IS
NOT AUTOMATICALLY STOPPED BY SQL SERVER LIKE DEADLOCK.

HERE'S GOOD SITE WHERE YOU CAN FIND INFO ABT BLOCKING.
http://www.builderau.com.au/program/sqlserver/soa/Find-blocking-processes-using-recursion-in-SQL-Server-2005/0,339028455,339286600,00.htm

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers  

---

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

How does Oracle guarantee data integrity of data changes?

1 Answers   SoftSol,

---

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

---

---

Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?

1 Answers  

---

How many packages we have in db

1 Answers   Tesco,

---

How will u copy the objects of one schema to another schema in datapump & export/import?

1 Answers  

---

Which environment variables are absolutely critical in order to run the OUI?

2 Answers  

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

0 Answers  

---

how can you find out if a table can be redefined?

0 Answers   Oracle,

---

What view would you use to look at the size of a data file?

3 Answers  

---