On Oracle
Monday, November 10, 2014
reverse key index: the remedy is worse than the symptoms
›
In general, reverse key index mitigates data block contention (buffer busy waits) when inserting monotonically increasing key into right-mos...
Thursday, November 6, 2014
Low High Water Mark, High High Water Mark, and Parallel Query
›
Recently we saw a 4 hours running parallel SELECT: select /*+ parallel(t,2) parallel_index(t,2) dbms_stats cursor_sharing_exact use_w...
Friday, May 23, 2014
Oracle 11g AUTO_SAMPLE_SIZE performance on Small Tables
›
Oracle 11g enhanced DBMS_STATS.AUTO_SAMPLE_SIZE by a new algorithm in calculating NDV (see Blog: Improvement of AUTO sampling statistics ga...
Thursday, May 8, 2014
java stored procedure calls and latch: row cache objects, and performance
›
In the last Blog, we demonstrated java stored procedure calls and latch: row cache objects. Is "latch: row cache objects" a real...
‹
›
Home
View web version
