Search

OakieTags

Who's online

There are currently 0 users and 12 guests online.

Recent comments

Affiliations

Faulty Quotes

True or False – Optimizer Mode and Tuning Goals

 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 [...]

True or False – Hash Joins

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 [...]

True or False – NVL

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 [...]

True or False – Undo

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 [...]

True or False – Data Dump Import and Indexes

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 [...]

True or False – Direct Path Reads

 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 [...]

True or False – Buffer Busy Waits

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 [...]

True or False – Autotrace

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 [...]

True or False – Wait Events

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 [...]

True or False – Improving Performance of SQL Statements

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 [...]