My problem is as follows:
The client device has suffered a blockage in one of the tables.
We have seen in the file, olSynclog.txt:
"ERROR", POL-3264, "07/06/2011 10:03:05", "Timeout waiting for a lock When"
The problem is that after the blockage, have lost the reference to indices, we believe, because the queries of client data, take longer than normal.
How can we regain the respect of indexes?
Do we have to go back to recreate the indexes?
When we use the application msync, not have open sessions with connection to the database.
In addition, we have defined the following parameters in the file POLITE:
TEMP_DIR = \ FlashStorage \OraCE
TEMP_DB = \ FlashStorage \
AUTO_COMMIT_COUNT = 300
RESUME_CLIENT_TIMEOUT = 120000
TIMEOUT_MAX = 65
Why the database may lose the reference indexes?