Interested to Buy Any Domain ? << Click Here >> for more details...
What is blocking and how would you troubleshoot it?
- 1 Answers
- 6713 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
what do you understand by flashback feature of oracle?
What purpose does the model database server? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
Query processing is slow(eg select query)how will u solve that
How to start SQL Server in minimal configuration mode?
what functionality does oracle provide to secure sensitive information?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How would you extract DDL of a table without using a GUI tool?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
Explain materialized views and how they are used.
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
how to restore files with rman?
how can you enable flashback feature?
what is the role of dip user in our database?
