Presume I'm having two transactions. The first transaction locks a group of rows in a table. The second transaction wants to lock the same rows that is already locked by the first transaction. It is obvious that the second transaction has to be in the wait state.
I want to know the details about the following questions.
1) Is there any possibility to check out the status of a row/ group of rows whether its locked/unlocked? ( The first transaction locked a record. The second transaction should know the status of the record before raising the query).
2) Is there any way to abort the query that is raised by a particular transaction? ( In the above case the second transaction)
3) Is there any option available to specify the time slice for a particular query? ( If the query is not executed with in the stipulated period it has to be wiped out from the queue. In the above case the query raised by the second transaction should not wait for more than a time period and the second transaction should resume its process)