1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

What is a deadlock and what is a live lock? How will you go
about resolving deadlocks?

Question Posted / guest


What is a deadlock and what is a live lock? How will you go about resolving deadlocks?..

Answer / monal

Live Lock occurs when exclusive lock is denied continuously
by series of overlapping shared locks keep on interfering
each other and they keep changing status further preventing
them to complete the task.

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More DB Administration Interview Questions

how can you initialize log miner?

0 Answers   Oracle,

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

0 Answers  

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

What type of index should you use on a fact table?

1 Answers  

Hi This is request to DBA man Q. I have installed Oracle 10g Express edition in Linux fedora Core 6.When i have run the following script for ORACLE _HOME environment variable setting . script is ". /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/oracle_env.sh" variable is set but it is working only in current session. If i restart the system again i should run that script. So haw to set permanently ? even i have try with export command for that environment set it also does not work. Q. When i run sqlplus in shell prompt It is working but when i give user name and password the following error come out i.e # sqlplus SQL*Plus: Release 10.2.0.1.0 - Production on Fri Apr 2 19:45:40 2010 Copyright (c) 1982, 2005, Oracle. All rights reserved. Enter user-name: system Enter password: ERROR: ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory I have also proper partition of disk means swap memory are available. # fdisk -l Disk /dev/sda: 40.0 GB, 40060403712 bytes 255 heads, 63 sectors/track, 4870 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes Device Boot Start End Blocks Id System /dev/sda1 * 1 1275 10241406 7 HPFS/NTFS /dev/sda2 1276 4870 28876837+ f W95 Ext'd (LBA) /dev/sda5 1276 3187 15358108+ 7 HPFS/NTFS /dev/sda6 3188 4672 11928231 83 Linux /dev/sda7 4673 4863 1534176 82 Linux swap / Solaris

1 Answers  




what is logical system in sap basis

0 Answers  

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

What is the importance of a recovery model? : sql server DBA

0 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

what is a crs resource?

0 Answers   Oracle,

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

Explain materialized views and how they are used.

0 Answers  

For more DB Administration Interview Questions Click Here
Categories