
Richard Foote's Oracle Blog
1,367 FOLLOWERS
Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music.
Richard Foote's Oracle Blog
1y 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
Richard Foote's Oracle Blog
1y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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
Richard Foote's Oracle Blog
2y 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