Blogs about: Oracle General
Featured Blog
Deleted Index Entries Part V (Trouble)
As discussed in Part IV, index blocks that contain nothing but deleted index entries are placed on the index freelist and can be recycled in subsequent index block split operations. This of course is … more →
Richard Foote's Oracle Blog
How to see Stored Procedure Code in Oracle & Sql Server
collecteddotnet wrote 3 months ago: Suppose we are writing some new query/script/SP and we want to see the code of preexisting SP in que … more →
Oracle Buys mValent
— 1 comment
Muhammad Habib wrote 9 months ago: Oracle has acquired mValent, a leading provider of application configuration management solutions. W … more →
Getting Cumulative Sum Using Oracle Analytical Functions
Muhammad Habib wrote 1 year ago: Great technique used to get cumulative sum http://www.oracle.com/technology/oramag/code/tips2005/062 … more →
Deleted Index Entries Part V (Trouble)
— 9 comments
Richard Foote wrote 1 year ago: As discussed in Part IV, index blocks that contain nothing but deleted index entries are placed on t … more →
Deleted Index Entries Part IV (Breaking Glass)
— 2 comments
Richard Foote wrote 1 year ago: Yet another method of cleaning out deleted space Oracle has up its sleeve is the recycling of index … more →
Deleted Index Entries Part III (Slip Away)
— 5 comments
Richard Foote wrote 1 year ago: Another little post while I look after some unwell munchkins … I’ve already looked at th … more →
Deleted Index Entries - Part I (Let It Be)
— 9 comments
Richard Foote wrote 1 year ago: Just before I hop on a plane to do some training in Europe, thought I might begin a little series on … more →
Primary Keys and Non-Unique Indexes (What's Really Happening ?)
— 16 comments
Richard Foote wrote 1 year ago: Based on this OTN thread, it appears there may still be folk out there that think Oracle uses Unique … more →
Extended SQL Tracing Presentation (Your Possible Pasts)
— 3 comments
Richard Foote wrote 1 year ago: I’ve recently dug up an old presentation I did for the local Oracle User Group a number of yea … more →
Indexes and Sorts (Chant Of The Ever Circling Skeletal Family)
— 7 comments
Richard Foote wrote 1 year ago: In my previous post regarding Reading 100% of Data via an Index, one of the examples I described was … more →
Read-Only Table Before 11g (A Day In The Life)
— 9 comments
Richard Foote wrote 1 year ago: An excellent question by fellow Aussie Chris Muir on this OTN Thread reminded me of a little trick I … more →
Index Scan or Full Table Scan: The "Magic" Number (Magic Dance)
— 25 comments
Richard Foote wrote 1 year ago: What seems like ages ago, I listed 8 things you may not have known about indexes. Although I’v … more →
Indexes In Their Own Tablespace: Recoverability Advantages (Get Back)
— 5 comments
Richard Foote wrote 1 year ago: Thought I might share some thoughts regarding recoverability issues with regard to having indexes se … more →
Indexes In Their Own Tablespace: Availabilty Advantages (Is There Anybody Out There?)
— 17 comments
Richard Foote wrote 1 year ago: I’ve already discussed here some reasons why performance is not particularly improved by simpl … more →
Separate Indexes From Tables, Some Thoughts Part 1.5 (Think For Yourself)
— 5 comments
Richard Foote wrote 1 year ago: Based on the discussions on whether there’s any performance benefit in storing indexes separat … more →
Separate Indexes From Tables, Some Thoughts Part II (There There)
— 9 comments
Richard Foote wrote 1 year ago: In Part I, I discussed how separating indexes from tables won’t likely improve performance as: … more →
Separate Indexes From Tables, Some Thoughts Part I (Everything In Its Right Place)
— 17 comments
Richard Foote wrote 1 year ago: Although by no means as common as it once was, there’s still some who believe separating index … more →
Top 5 Most Influencial DBAs In My Oracle Career ("Heroes")
— 17 comments
Richard Foote wrote 1 year ago: When I was at OpenWorld last year, I was asked by a couple of people a question that’s been as … more →
So When Does An Oracle B-Tree Index Increase In Height ? (Almost Grown)
— 49 comments
Richard Foote wrote 1 year ago: So when does an Oracle B-Tree index actually increase in height ? I’ve basically been asked th … more →
