The End Of Richard Foote’s Oracle Blog (“Rock ‘n’ Roll Suicide”)
Richard Foote's Oracle Blog
by Richard Foote
9M ago
  Of all my many Oracle blog posts, this particular post will remain with me the longest, for not only is it the last blog post I’ve done in a while, but it’s the last blog post I’ll ever do!!! (Yes, this statement is a complete ripoff of David Bowie’s famous 3rd July 1973 farewell ..read more
Visit website
The Fake Index Trap (“Nowhere Now”)
Richard Foote's Oracle Blog
by Richard Foote
11M ago
In a recent correspondence, I was alerted to an issue in relation to the use of Virtual/Fake/Nosegment Indexes that I wasn’t aware of previously. Having a play, it appears this issue is still present in at least Oracle Database 21c, so I thought it worth a mention in case anyone else happens to fall into ..read more
Visit website
Announcement: Oracle Database 23c Free Version Now Available to Developers
Richard Foote's Oracle Blog
by Richard Foote
1y ago
In rather exciting news in the world of Oracle databases, Oracle today announced the availability of Oracle Database 23c Free Developer Release. Oracle Database 23c Free Developer Release is available for download as a Docker Image, VirtualBox VM, or Linux RPM installation file, without requiring a user account or login. A Windows version is planned to ..read more
Visit website
CBO Costing Plans With Migrated Rows Part II (“New Killer Star”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
I’ve spent the past few months discussing Migrated Rows, in large part thanks to an excellent 15 minute video by Connor McDonald on how ROWIDs can now be updated on the fly in Oracle Autonomous databases. Well 14 such posts later, I have finally reached the end of this topic (for now at least). So, an ..read more
Visit website
CBO Costing Plans With Migrated Rows Part I (“Ignoreland”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
Whilst recently blogging about Migrated Rows and specifically changes to how ROWIDs are now maintained on the fly in Oracle Autonomous Databases, I made a discovery regarding how the Cost-Based Optimizer (CBO) costs such plans. This is one of the key reasons why I blog, not only to try and share odd titbits about how ..read more
Visit website
Migrated Rows In Oracle Data Warehouse Autonomous Databases (“Sit Down. Stand Up.”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
In all my recent discussions on how Oracle can now update ROWIDs on the fly when a row migrates, I’ve mentioned how this only occurs on tables in which the ENABLE ROW MOVEMENT clause has been set. So you have the option on whether you wish this new behaviour to occur by simply not setting ..read more
Visit website
Annoying Bug When Trying To Create Always Free TP Autonomous Database (“Supernaturally”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
I was having all sorts of problems with one of my Always Free Oracle Transaction Processing Autonomous Databases, mostly around space and configuration issues within its parent Container Database, that I just gave up, blew it away and just tried to create a fresh one. That’s the beauty of this great free capability, it’s so ..read more
Visit website
Possible Impact To Clustering Factor Now ROWIDs Are Updated When Rows Migrate Part III (“Dancing With The Big Boys”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
In my previous post, I discussed how you can best reorg a table that has a significant number of migrated rows impact the Clustering Factor of important indexes, when such tables have the ENABLED ROW MOVEMENT disabled. In this post I’ll discuss resolving similar issues, but when ROWIDs are updated on the fly when rows ..read more
Visit website
Possible Impact To Clustering Factor Now ROWIDs Are Updated When Rows Migrate Part II (“Dancing Out In Space”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
In my previous post, I discussed how the clustering of data can be impacted if rows migrate and how this in turn can have a detrimental impact on the efficiency of associated indexes. In this post, I’ll discuss what you can do (and not do) to remedy things in the relatively unlikely event that you ..read more
Visit website
Possible Impact To Clustering Factor Now ROWIDs Are Updated When Rows Migrate Part I (“Growin’ Up”)
Richard Foote's Oracle Blog
by Richard Foote
1y ago
In my previous post I discussed how an index can potentially be somewhat inflated in size after ROWIDs are updated on the fly after a substantial number of rows are migrated. However, there’s another key “factor” of an index that in some scenarios can be impacted by this new ROWID behaviour with regard migrated rows ..read more
Visit website

Follow Richard Foote's Oracle Blog on FeedSpot

Continue with Google
Continue with Apple
OR