by Matt Hayward
One of the less obvious advantages of database virtualization is a reduction in the read I/O issued against the underlying physical storage (henceforth called “the SAN”) that ultimately stores the data for virtual databases.
See Press release at http://www.digitaljournal.com/pr/1475286
I’ll be in San Francisco next week, presenting about Hadoop and Big Data at the biggest conference. If you want to say “hi”,
you can attend one of my sessions:
King Training Resources celebrates our 25th year beginning this month. It’s gratifying to see that what began in 1988 is still going strong today. Thanks to all involved, especially to my wife Peggy without whom life would seem impossible.
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?)