I’m off to Oracle Open World next week where I’ll be talking about new features in the Oracle 12c Database for developers and Oracle ADF. You can join me as ODTUG and the ADF EMG team up for a series of great sessions during User Group Sunday.
Here’s my Oracle Open World 2013 Speaking Schedule:
Sorry, it’s been a while since I posted to this blog. Thanks for coming back!
A lot has happened in the last year including new versions of Oracle’s database, ADF, JDeveloper, and SQL Developer. I now have many new features to explore and will share interesting tidbits as I discover them.
I was pleasantly surprised at Kscope 13 in New Orleans when Vikki Lira from Oracle Technology Network informed me that I had been accepted as an Ace Director; many thanks to all who were involved. Once Tim Gorman and Tim Tow taught me the “secret handshake” I was ready to go.
Given a description of gas dynamics and the atmosphere, you would be hard to pressed forecast tornadoes. The term emergence denotes the phenomena of surprising behaviors arising in complex systems. Modern storage systems are complex, and full of emergent behavior that make forecasting application I/O performance fiendishly difficult.
Analytic Functions [UGF7455]
Analytics have been with us since Oracle8i Database Release 2 (8.1.6), but they are still dramatically underused by application developers. This session looks at the syntax and usage of analytic functions and how they can supercharge your SQL skill set.
SQL Tuning 101 [CON7457]
It’s the age-old problem: the SQL statement that needs to run in 5 seconds unfortunately runs in 10 seconds or 10 minutes, or 10 hours. A SQL statement is e-mailed to you with the simple subject line "Make it faster!". This presentation starts from this point in the process and looks at what you can do to tackle this common issue.
Optimizer Statistics: A Fresh Approach [CON7442]
What tools do you use? What are your favorites and why? As someone who has been working Oracle performance tools for the last 15 years, I’m always interested in what the best tools are.
For the past 4 blog posts I’ve reviewed some tools I like such as Method-R tools, Confio, Lab128 and EMlite.
There are other tools that I especially like and are totally free such as Tanel Poder’s Moats and snapper which are two important tools for a DBA to know about.
Here is my list of tools that I’m aware of (what other tools are out there?)
EMlight might not be as important now with Oracle 12c coming out and with Oracle’s EM Express, but EMlight is still pretty cool. I tried it about year ago, and was impressed. EMlight is a light weight re-write of Enterprise Manager that is dependable and improved. How is it improved? Let’s look at my favorite part, the “Top Activity” screen. The “Top Activity” screen has added a section on I/O latencies which is sorely missing from OEM’s performance page and Top Activity page. The OEM light version also includes a list of the top events (as I did in DB Optimizer). Very cool.
How is EMlight more dependable? With EMlight you just connect to the database and voila it works. It doesn’t require any of the brittle configuration files that OEM depends on nor the agents and processes that OEM depends on.
I’ve mentioned lab 128 before but I have to mentioned it again. Every DBA should know about this tool. It’s the fastest way to connect to an Oracle database and get some hard core performance information nicely visualized graphically.
Lab 128 starts up in seconds, like 1 or 2 seconds. Its super fast and light weight but powerful. My older version only took 10M of RAM. The newest version is about 47M but still as fast as ever.
Tom Kyte’s latest magazine article talks about the new FETCH FIRST syntax in 12c. You can read about that at:
There’s a (quite valid) comment at the end of the article:
"Note that in real life, you would use bind variables instead of hard-coded literals, so instead of using the number 5 as I did, you would have bound in the number 5."
But Michael Rosenblum’s blog first drew my attention to the problem you might encounter when you do start using bind variables (http://wonderingmisha.blogspot.com.au/2013/08/oracle-12c-offsetfetch-bug.html), which I’ll reproduce here, together with a workaround that will still let you use bind variables.
People have been asking me recently, “what is the best enterprise database monitoring software?”