-
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: April 2011
Slow SQL with bind variables involving Object Types
Summary of the problem: A simple insert inside PL/SQL procedure took 2-3 milliseconds consistently. The insert had no disk reads, a few tens of db block gets. For such a load the insert must have taken no more than 10s … Continue reading
Posted in Uncategorized
Leave a comment