Top 60 Oracle Blogs

Recent comments

Jonathan Lewis's tweets

@oradiag Interesting: 72 isn't a "fixed bucket size". In 11.2 my FREE LISTS dump is FREE LISTS: Bucket 0 size=56… day 13 hours ago
@FranckPachot @Hibernate Warning - if you use "insert .... returning" in a jdbc framework then an upgrade to 18c ma… day 13 hours ago
Following on from yesterday - how 18c makes it easier to change a table from range partitioned to range/list partit… day 13 hours ago
@ThomasTeskeOrcl @ChandlerDBA BTW - I (re-)discovered this while looking at a trace file generated from exchange partition. — 1 day 18 hours ago
@ThomasTeskeOrcl @ChandlerDBA Exclusive would be a bit vicious - except, perhaps, to force a write-consistent batch… day 18 hours ago
Was there a time I knew this was possible - locking many tables simultaneously: SQL> select table_name from user_t… day 20 hours ago
Here's a little thing I use from time to time to look for threatening skew in the physical distribution of rows in… day 20 hours ago
@oradiag Correction - above a certain size the chunks in a bucket can be different sizes but will be between the bu… days 6 hours ago
@oradiag Each bucket is a linked list (maybe in address order) of chunks of one size, so finding a chunk is easy, a… days 6 hours ago
@oradiag Just done one on 12.2 - Free space bit looks like this: FREE LISTS: Bucket 0 size=56 Chunk 7f96d822… days 6 hours ago