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?”
Mark your calendar for Tuesday, September 10th when we’ll be giving a live demo of the DevOps workflow with Delphix and Red Gate Schema Compare for Oracle. The presentation will be followed by a Q&A session with James Murtagh. Register here!