Skip to content

CERN

Optimizer Statistics Gathering – pending and history

By Franck Pachot . This was initially posted to CERN Database blog on Wednesday, 12 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Demo table I create a table for the demo. The CTAS gathers statistics (12c online statistics gathering) with one row and then I insert more rows: 10:33:56 SQL> create table… 

Efficiently query DBA_EXTENTS for FILE_ID / BLOCK_ID

By Franck Pachot . This was initially posted to CERN Database blog on Thursday, 27 September 2018 where it seems to be lost. Here is a copy thanks to web.archive.org Did you ever try to query DBA_EXTENTS on a very large database with LMT tablespaces? I had to, in the past, in order to find which segment a corrupt block… 

Oracle write consistency bug and multi-thread de-queuing

By Franck Pachot . This was initially posted on CERN Database blog where it seems to be lost. Here is a copy thanks to web.archive.org Additional notes: – I’ve tested and got the same behaviour in Oracle 21c – you will probably enjoy reading Hatem Mahmoud going further on Write consistency and DML restart Posted by Franck Pachot on Thursday,…