Joords Oracle DBA blog

Customers often ask to what extent they can trust performance measurements and timing results of the Oracle database within a virtual machine. To fully understand the performance of applications running in a virtual machine, we can give some general guidance.

Blogpost of Tom Kyte Thursday, April 28, 2011 An " AWR Formatter " written by a friend of mine, Tyler Muth. It's pretty cool - works as a Chrome plugin - and it makes an AWR report a little more 'friendly' to use. It creates hot links for many of the wait events (so you know what they mean) and it summarizes up a lot of stuff - making the AWR report a lot more "interactive". Check it out and give him feedback on it if you have time.  

DBMS_PROFILE The profiler provides us with a source code tuning for our PL/SQL applications. It is still a unknown feature for developers and DBA’s. In the past, you would tune your PL/SQL applications using SQL_TRACE and TKPROF or by using dbms_output. Well, you no longer have to do this. There is a DBMS_PROFILER package available as of oracle 8i version.