transaction timeout error

we are using oracle 10g, About the transaction timeout, I got the except from some document, looks like it is able to tuning the timeout parameter, do you know where I can find it? Thanks. i need to have a control over the timeout so when there is record lock over certain time, i will get the sql exception error.

Data Access Failures Due to Locks
When you issue a SQL statement, the database attempts to lock the resources needed to successfully execute the statement. If the requested data is currently held by statements of other uncommitted transactions, however, and remains locked for a long time, a timeout occurs.

Consider the following scenarios involving data access failure:

· Transaction Timeouts

· Locks from In-Doubt Transactions

Transaction Timeouts
A DML statement that requires locks on a remote database can be blocked if another transaction own locks on the requested data. If these locks continue to block the requesting SQL statement, then the following sequence of events occurs:

1. A timeout occurs.
2. The database rolls back the statement.
3. The database returns this error message to the user:
4. ORA-02049: time-out: distributed transaction waiting for lock 5. Because the transaction did not modify data, no actions are necessary as a result of the timeout. Applications should proceed as if a deadlock has been encountered. The user who executed the statement can try to reexecute the statement later. If the lock persists, then the user should contact an administrator to report the problem.