Feed items
Using TKPROF for Analyzing 10046 Extended SQL Trace Files – What is Wrong with this Quote?
September 21, 2011 I have written a couple of blog articles on the topic of reading 10046 extended SQL trace files. Some of those blog articles are listed below: 10046 Extended SQL Trace Interpretation 10046 Extended SQL Trace Interpretation 2 10046 Extended SQL Trace Interpretation 3 Brain Teaser: 10046 Extended SQL Trace Shows “EXEC #435118472:c=15600,e=510″, How is that Possible? [...]
Inline Views – What is Wrong with this Quote?
September 18, 2011 I do not recall putting together any articles about inline views, so let’s start out with a couple of examples before taking a look at a quote. We need to create a table for this example, so I will reuse a slightly modified table creation script from another article, and also collect [...]
10046 Extended SQL Tracing for a Session – What is Wrong with this Quote?
September 16, 2011 While reading the Oracle 11g Performance Tuning Recipes book, I noticed that some of the recipes in chapter 10 seemed to have an odd familiarity, although as of yet I have not quite pinpointed where I had previously seen some of the concepts in chapter 10. Recipes 10-2, 10-11, and 10-16 seem to share a common ancestry with [...]
Brain Teaser: Why is this Query Performing a Full Table Scan
September 14, 2011 While taking a look at the OTN threads this morning, I found an interesting test case, where the OP was asking why a query used a full table scan and not an index range scan. The OP would like for the query to use the index without using a hint in the query. [...]
Book Review: Oracle Database 11g Performance Tuning Recipes
September 10, 2011 Hammering a Square Peg into a Round Hole: Fine Edges are Lost, Gaps in Detail http://www.amazon.com/Oracle-Database-Performance-Tuning-Recipes/dp/1430236620 (Forward to the Next Post in the Series) (Update September 14, 2011: It is a bit unfair to this book that my review only covered the first six chapters and portions of chapter 7 – roughly the first [...]
Unindexed Foreign Keys – What is Wrong with this Quote?
September 5, 2011 I often look for easier ways to accomplish time consuming tasks, and I suspect that is part of the reason why I buy so many computer books. In Recipe 2-5 (page 60) of the “Oracle Database 11g Performance Tuning Recipes” book there is a SQL statement to determine which database columns (owned [...]
Parse CPU to Parse Elapsd – What is Wrong with this Quote?
September 1, 2011 I located another interesting statement in the “Oracle Database 11g Performance Tuning Recipes“ book, so I thought that it was time for another blog article that takes a look at a statement from the book. Chapter 4 of the book is significantly better written (much more accurate) than chapter 3. To set the stage, [...]
KEEP Pool – What is Wrong with this Quote?
August 28, 2011 The book “Oracle Database 11g Performance Tuning Recipes” is out of the alpha stage – if you bought the alpha version from Apress, you should now be able to download the finished book. I am currently reviewing the book review notes that I started collecting when reading the alpha version, so that [...]
Book Review: Beginning Oracle SQL
August 23, 2011 The Ideal Guide for Beginning to Intermediate Oracle SQL: Providing the Logical Reasoning Behind the Approach to Understanding and Solving Data Access Challenges http://www.amazon.com/Beginning-Oracle-SQL-Experts-Voice/dp/1430271973/ The “Beginning Oracle SQL” book is an updated version of the book “Mastering Oracle SQL and SQL*Plus” which covered Oracle release versions through 10.1.0.2. The original version, while [...]
Aug 23, 2011 10:33am
Oracle Database Time Model Viewer in Excel 6
August 18, 2011 (Back to the Previous Post in the Series) It has been roughly five months since the last installment in this blog article series. Hopefully, several people have found this series helpful and have adapted the solution to better fit their specific needs. By the end of the last article the Excel based [...]
