I solved this by turning off flashback. I confirmed this was the issue by doing this: sqlplus sys as sysdba SQL shutdown immediate; SQL.
Hi,One of the applications we use keeps hanging , i.e it performs a data collection process from 20 feed back points and it stops after collecting from only few. no front end error msg, just stops. i was asked to see if this has got to do anything with the database. I checked the alert log and no errors in it. I also check the Trace folder and the latest trace file has teh following errros-- not quite sure what these errors are. This is a stand alone Oracle 11.2.0.1 database, no RAC. any suggestions will be appreciated! thanks!
--
[ default]ut_read_reg:2:ocr registry key SOFTWAREOracleolr cannot be opened. error 2
![Key software oracle olr cannot be opened.error 2017 Key software oracle olr cannot be opened.error 2017](http://www.hhutzler.de/blog/wp-content/uploads/2017/05/Install_MemberCluster_p41.jpg)