Blogs about: Tablespace Management
Featured Blog
Why A Segment Really Has To Be At Least 2 Blocks In Size
I just couldn’t resist this one … In the latest Don Burleson news piece dated July 17, 2009 called “Tablespace size initial extent size” (although the referenced article itself… more →
Richard Foote's Oracle Blog
Why A Segment Really Has To Be At Least 2 Blocks In Size
— 17 comments
Richard Foote wrote 4 months ago: I just couldn’t resist this one … In the latest Don Burleson news piece dated July 17, 2 … 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 →
Larger Block Index Tablespace and Small Index Scans - Performance Improvement ? (Let Down)
— 10 comments
Richard Foote wrote 1 year ago: Thought it might be worth looking at the impact on the performance of Unique and small index range s … more →
Store Indexes In A Larger Block Tablespace: Height Reduction 1/2 Myth (Five Foot One)
— 14 comments
Richard Foote wrote 1 year ago: A common misconception with using a larger block tablespace specifically for indexes is that this wi … more →
Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth Part II (The Fly)
— 67 comments
Richard Foote wrote 1 year ago: Thought I might begin by mentioning a lovely little story by Billy Verreynne in this OTN Forum Threa … more →
Store Indexes In A Larger Block Tablespace: The Multiblock Read Myth (Karma Police)
— 6 comments
Richard Foote wrote 1 year ago: One of the great myths surrounding the use of differing block sizes is that storing indexes in large … more →
Store Indexes In a Larger Block Tablespace: Some Thoughts (Big Brother)
— 17 comments
Richard Foote wrote 1 year ago: A suggestion that seems to pop up on a routine basis on various forums and discussion boards is that … more →
