The clip explains how Buffer Busy Waits are being caused and how they can be reduced with Hash Partitioned Indexes. A text version is here: https://uhesse.com/2016/12/02/how-to-reduce-buffer-busy-waits-with-hash-partitioned-indexes-in-oracle/
Views: 1315 Uwe Hesse about Database Technology
The clip demonstrates how to change FLASHBACK DATABASE without having to restart the instance. A text version is here: https://uhesse.com/2010/06/25/turning-flashback-database-on-off-with-instance-in-status-open/ The demo is done with 12c but the shown can be done with 11gR2 as well.
Views: 892 Uwe Hesse about Database Technology
The clip demonstrates how to move (compressing) Partitions ONLINE and how to make them READ ONLY. Both are 12c New Features. Text version is here: https://uhesse.com/2017/01/05/how-to-move-partitions-online-and-make-them-read-only-in-oracle-12c/
Views: 393 Uwe Hesse about Database Technology