-
Recent Posts
- OMON: analysis of one incident
- Bugs series: Skip using IGNORE_ROW_ON_DUPKEY_INDEX Hint in 11.2. Wait until 12c
- OMON – a browser based tool to browse AWR/PERFSTAT
- Excessive transaction tables consistent reads – undo records applied in 11.2.0.3 – Part II
- Excessive transaction tables consistent reads – undo records applied in 11.2.0.3
Recent Comments
Archives
Categories
Meta
Monthly Archives: March 2011
LOB’s and Flashback database performance
Summary of the problem: database hit high “Flashback buf free by RVWR” waits. The database had many nocached LOB’s columns in heavily accessed (transactional) tables. Database version: 10.2.0.4 with flashback database turned on. Metalink document 565535.1 recommends: “For optimal performance … Continue reading
Posted in Uncategorized
1 Comment