So this tip requires you upgrade to version 4.0.3 of Oracle SQL Developer – more on that in a second.
Version 4.0.3 is 95% bug fixes.
One of those bugs was submitted by my fellow product manager, Maria Colgan. Perhaps you know her on Twitter as…
Anyways, she is going to be using our favorite tool to help teach you how to use the new 126.96.36.199 database feature known as ‘In-Memory.’
What if you could get answers instantaneously—in seconds, not in hours or days?
Pretty amazing stuff. But, you probably want to see how it’s working, or even IF it’s working. Autotrace and a new optimizer hint makes that pretty easy.
You can turn it on and off between SQL statements for a table or whatever. If you capture these executions with AutoTrace and do a compare, you can see something like this:
- Autotrace query
- Pin results
- Autotrace 2nd query
- Pin Results
- Right-click on Autotrace results panel 1, and say ‘Compare…with 2’
You could of course do this in earlier versions of the tool, but the compare feature didn’t take into account the zero-level stats. They were removed before doing the compare…anyways the Autotrace compare works much better now.
And about that In-Memory Stuff
Maria holding MULTIPLE Hands-On Labs the week of Open World 2014. You’ll want to go into your schedule builder and sign up quickly before they’re all sold out!