Rittman Mead - Delivered Intelligence

I’ve had a few questions through recently, and rather than answer them directly via email, I thought I’d publish them here. Going into the future, I’ll only be answering questions that get posted to the forum (http://www.rittman.net/forum), as it makes the answers available to everyone and other people can step in and answer if I’m [...]

At the risk of Tom Kyte telling me that I have given up thinking… Any ideas why this appeared as part of a WHERE predicate (or more to the point why write it!) … AND ( case when T.V_STATUS = ‘A’ then ‘Active’ when T.V_STATUS = ‘D’ then ‘Delisted’ else ‘Unknown Status’ end ) = [...]

If you read AskTom you will probably know that there is no such thing as a universal go-faster switch in Oracle. Everything is “maybe faster, maybe slower and your mileage may vary”. Over the past week or so we have been user-testing a revised parallelism setting on a 3 TB DW system. Originally, all of [...]

For a while we have used DBMS_STATS.GATHER_SCHEMA_STATS with the gather stale option to collect statistics on one of our Oracle 9.2 data warehouses. It was perhaps a little slower than our old approach but it did the job and was also code not written (and hence not maintained) by us; from posts past you know [...]

Just a couple of updates. If you found the article last week on Oracle OLAP memory management useful, Chris Chiappa sent an email through to me this evening with some clarifications and corrections. I’ve annotated the article with Chris’ comments and you can read the updated version here. Thanks very much Chris, much appreciated. If [...]