We promised in an earlier post to cover some of the questions from the Optimizer round table discussion at Oracle Open World. Here’s our first in a series of posts that will address these questions.
Q: When moving from 10g to 11g, should hints in existing SQL be removed?
A: I was glad to see this question [...]
Yesterday in my course I ran into a strange BUG in Oracle Express (XE) on WIN32 and Linux 32 bit, in fact one of my students, Ralf Spiwoks, found it:
I have tried to run a top level anonymous block in which assigned a value to a BIND variable and got kicked …
Link to the original site
I’ve added example# 148 to illustrate a technique to declaratively initialize the bind variables of a view object at task flow startup time.
Link to the original site
Instrumentation
Cary Millsap has recently pointed to a couple of postings and quoted some people on the fine art of instrumentation. He quoted me (and got it pretty much 100% – dead on) a couple of times as well. I’ll add a quote/story to his list of quotes…
When Oracle 10g first was released – I was [...]
When you migrate your ADF 11.1.1 application to 11.1.1.1, if you happen to have attributes with names like Category, Reference, PropertyValue, Sequence, or several others, then you may notice that your application malfunctions where it references these attribute names in Groovy scripts/expressions. One situation where the problem occurred for me was in a bug tracking application [...]
In response to a question asked on the dBforums website, I created a little screencast to show the simple steps to go from a SQL query that you’ve got working in SQL Developer to a JSF page that display its results and allows the user to enter values for its bind variables.
Using a SQL Query [...]
Recently we received several questions regarding a usual situation where a SQL Statement has hundreds of child cursors. This is in fact the expected behavior when
CURSOR_SHARING is set to similar
Bind peeking is in use
And a histogram is present on the column used in the where clause predicate of query
You must now be [...]
In December 2007 we did a post on the new Oracle Database 11g feature Adaptive Cursor Sharing called Why are there more cursor in 11g for my queries containing binds. In this post we explained that in Oracle Database 11g it was possible to have multiple execution plans for a single statement that uses bind [...]
The answer to this question is yes, as Oracle Database 11g provides a new diagnostic tool called SQL Test Case Builder. In this article, we explain what SQL Test Case Builder is, and how to use it with examples.
Why SQL Test Case Builder?
For most SQL problems, the single most important factor for a speedy bug [...]
Oracle introduced a new feature, adaptive cursor sharing, in 11g, to improve the plans that are selected for queries containing bind variables. This feature can result in more cursors for the same query containing bind variables. We’ll explain why in this article. Before we get into the details, let’s review a little [...]