Showing posts with label Tuning. Show all posts
Showing posts with label Tuning. Show all posts

Friday, October 21, 2011

Oracle performance and Time Measurements Within a Virtual Machine

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.

Monday, May 2, 2011

Use Chrome plugin to make Oracle AWR reports (formattter) friendly

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.
 

Friday, December 18, 2009

DBMS_PROFILE: Overview what can be done to tune the PL/SQL APPLICATIONS

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.