Is ORA-02049 is only limited to transactions that traverse to multiple databases
Hi,
I'm having an index concurrency on may database (base on index root split) and the transactions are concurrently waiting for it until they timedout.
the clients received error below:
ORA-02049: time-out: distributed transaction waiting for lock
my understanding for this distributed is that this call must involve at least 2 databases, one is local and one is remote.
But these client transactions did is to insert on the local history_table and not any remote table.
Planning to visit the parameter distributed_lock_timeout (=60) and increase it, but would this help if the transaction is local only and not distributed to a remote database.