|
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
how to stop a transaction
Hi,
i am using AQ, however, the dequeued message is waiting a transaction to be completed, and the message hanging there. So, i would like to find a way to stop the transaction: 1) How to know the active transaction in the database? 2) What is the command to stop the transaction? 3) Where can i find the transaction log file? Many many thanks! |
|
#2
|
||||
|
||||
|
Read this
__________________
My blog Tutorials about OSS databases, DBMonster ... Contribute to OSS Development, fill bug reports! Developer Shed eSupport Commented my.ini/my.cnf (ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins Random data (with a bias) |
![]() |
| Viewing: Dev Shed Forums > Databases > Oracle Development > how to stop a transaction |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|