I have a long-running transaction that runs concurrently from multiple sessions. Each transaction needs to update a randomly selected row from a table of 100 rows. It needs to do this without waiting for the other transactions to release their update locks. In other words, it needs to randomly select for update any of the rows which is not locked for update by another transaction. If all the rows are locked, it's ok to fail with a resource busy error, however, if any row is not locked, then I want to select one of them for update (don't care which one).
As it stands now, the application does a "Select random_row for update NOWAIT", but the incidence of resource busy errors has become unacceptable. I can remove the NOWAIT, but then the delay waiting for resources to free up is unacceptable.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Configuring and using Oracle Database Gateway for ODBC
First, a brief summary of what a Database Gateway is. A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
This video shows how to copy a database user from one database to another user DBMS_METADATA. It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.