Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock ? Explain .
- 1 Answers
- 5998 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 |
What are the oracle differences between nvl and coalesce
17. Display the order number and average item cost for each order.
What is meant by recursive hints in oracle?
What is the difference between PFILE and SPFILE in Oracle?
What are a query and state the different types of queries and their uses?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Can we create trigger on materialized view in oracle?
What does `(+)` do in a where clause?
How to assign a tablespace to a users in oracle?
How to drop a stored function?
How to declare a local variable?
What does ROLLBACK do ?
Oracle General 
