Blogs about: Oracle Opinion
Featured Blog
3 Steps To Performance Tuning (Working Class Hero)
Last night, I answered a question on the Database OTN forum regarding Database Re-Org and Performance Tuning. I thought it might be worthwhile sharing my response here as it’s something I feel q… more →
Richard Foote's Oracle Blog
3 Steps To Performance Tuning (Working Class Hero)
— 8 comments
Richard Foote wrote 1 year ago: Last night, I answered a question on the Database OTN forum regarding Database Re-Org and Performanc … 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 →
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 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 →
Most Influencial Person In My Career (I Am...I Said)
— 14 comments
Richard Foote wrote 1 year ago: I previously listed four of the people who have probably had the biggest impact on me as a DBA. Howe … 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 →
Buffer Cache Hit Ratios: Useful or Not ?
— 4 comments
Richard Foote wrote 1 year ago: The question of whether the Buffer Cache Hit Ratio (BCHR) is a useful metric or not is one of those … more →
Index Internals - Rebuilding The Truth
— 7 comments
Richard Foote wrote 1 year ago: The issue of when to rebuild indexes crops up again and again and again. Unfortunately, so do the sa … more →
