Look for short DML, try to reduce their commit frequency and, if possible, run your query on another time to avoid concurrency with these DML - or the opposite. Depending of the query (we don't know how it looks like), it may be rewritten to avoid fetch across commits.

Try to read this too:

http://asktom.oracle.com/pls/ask/f?p...:275215756923,