Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5887 Views
- I also Faced
- E-Mail Answers
Answer / sawant
Two processes wating to update the rows of a table which
are locked by the other process then deadlock arises.
In a database environment this will often happen because
of not issuing proper row lock commands. Poor design of
front-end application may cause this situation and the
performance of server will reduce drastically.
These locks will be released automatically when a
commit/rollback operation performed or any one of this
processes being killed externally.
| Is This Answer Correct ? | 11 Yes | 0 No |
How to loop through data rows in the implicit cursor?
What is Hash Index?
How to grant create session privilege to a user in oracle?
How do we represent comments in oracle?
How to define an anonymous procedure without variables?
How to execute the package in oracle?
In my table i have 4 columns with 100 records but in that 4 columns one column contains all NULL values so can i add NOT NULL CONSTRAINT on that column......... ok if it is not possible, can i add NOT NULL CONSTRAINT from 101 Record Onwards?
How are the index updates?
Do you know about aggregate functions? What is row num function? Can it be used all databases?
1 Answers Bravura Solutions, Cap Gemini,
How to retrieve data from an cursor to a record?
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
Explain alias?
Oracle General 
