Search

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… https://t.co/AiDXupGS8A1 day 13 hours ago
@FranckPachot @Hibernate Warning - if you use "insert .... returning" in a jdbc framework then an upgrade to 18c ma… https://t.co/qHCft8qRoq1 day 13 hours ago
Following on from yesterday - how 18c makes it easier to change a table from range partitioned to range/list partit… https://t.co/JflD0XUXg11 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… https://t.co/8VHRLat7WE1 day 18 hours ago
Was there a time I knew this was possible - locking many tables simultaneously: SQL> select table_name from user_t… https://t.co/JgOmJxqItI1 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… https://t.co/mDsVJL3Mqh1 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… https://t.co/NAPCReTTrU2 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… https://t.co/xjbUQYYELR2 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… https://t.co/9DnsAU9H0o2 days 6 hours ago