May 13, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers. Today’s quiz is on the topic of the optimizer mode and tuning goals, inspired by a recent thread that I found [...]
May 12, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers. Today’s quiz is on the topic of the hash joins, inspired by a recent thread that I found in a discussion [...]
May 11, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers, if the answers to those questions depend on the source of the information found through Internet searches. Today’s quiz is [...]
May 9, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers, if the answers to those questions depend on the source of the information found through Internet searches. Today’s quiz is on the topic [...]
May 6, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) While reading one of the OTN threads that asked whether Data Pump import will automatically rebuild indexes, I notice that someone posted an interesting response that appeared to be quoted from another source. I searched the Internet and found [...]
April 21, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) Time for another true or false pop quiz. Based on the number of views the previous true or false quizzes have experienced, this is a popular series. However, the questions might be a little too hard to [...]
April 19, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) An earlier blog article provided a couple of links that I found to be helpful when encountering buffer busy waits. There are certainly other helpful web pages within reach of the nearest search engine. I thought for [...]
April 8, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) I recently encountered a discussion thread (dbaforums.org/oracle/index.php?showtopic=19435) that asked about how to determine whether or not a SQL statement executed in a program uses indexes or full table scans – the database in question is an unspecified release version of Oracle [...]
March 31, 2010 (Back to the Previous Post in the Series) (Forward to the Next Post in the Series) A continuation of the series of true or false quizzes for the week – maybe this one is too easy. Today’s quiz is on the topic of wait events. Assuming that the questions apply to a release of Oracle that has [...]
March 30, 2010
(Back to the Previous Post in the Series) (Forward to the Next Post in the Series)
A continuation of the concept of yesterday’s true or false quiz – this one is a little easier, with new reading material. Today’s quiz is on the topic of improving performance of SQL statements. The reading material:
Article 1
Article 2
Article 3
Article [...]
Recent comments
1 week 12 hours ago
1 week 18 hours ago
4 weeks 36 min ago
11 weeks 6 days ago
14 weeks 6 days ago
19 weeks 3 days ago
19 weeks 3 days ago
19 weeks 5 days ago