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

what do you understand by fine-grained auditing?

0 Answers   Oracle,

---

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

---

what are the types of connection load-balancing?

0 Answers   Oracle,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

Explain the difference between a data block, an extent and a segment.

2 Answers  

---

What happens on checkpoint? : sql server DBA

0 Answers  

---

What is the difference between online backup & offline backup?

3 Answers   CSC,

---

how can you connect from 10g user to 11g user??

0 Answers   HP,

---

Name two files used for network connection to a database.

5 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

1 Answers  

---