Search

Top 60 Oracle Blogs

Recent comments

Home » Monthly archive

March 2013

asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time

Submitted by tanelpoder on Sun, 2013-03-17 14:23

I don’t have much time for a thorough blog post, so I’ll just paste in an example output of my asqlmon.sql script, which uses ASH sql_plan_line columns for displaying where inside your execution plan response time has been spent. Why not just use Oracle’s own SQL Monitoring reports? Well, SQL monitoring is meant for “long running” queries, which are not executed very frequently. In other words, you can’t use SQL Monitoring for drilling down into your frequently executed OLTP-style SQL.

asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time

Submitted by tanelpoder on Sun, 2013-03-17 14:23

I don’t have much time for a thorough blog post, so I’ll just paste in an example output of my asqlmon.sql script, which uses ASH sql_plan_line columns for displaying where inside your execution plan response time has been spent. Why not just use Oracle’s own SQL Monitoring reports? Well, SQL monitoring is meant for “long running” queries, which are not executed very frequently. In other words, you can’t use SQL Monitoring for drilling down into your frequently executed OLTP-style SQL.

asqlmon.sql: SQL Monitoring-like execution plan line level drilldown into SQL response time

Submitted by tanelpoder on Sun, 2013-03-17 14:23

I don’t have much time for a thorough blog post, so I’ll just paste in an example output of my asqlmon.sql script, which uses ASH sql_plan_line columns for displaying where inside your execution plan response time has been spent. Why not just use Oracle’s own SQL Monitoring reports? Well, SQL monitoring is meant for “long running” queries, which are not executed very frequently. In other words, you can’t use SQL Monitoring for drilling down into your frequently executed OLTP-style SQL. I am copying my recent post to Oracle-L mailing list here too:

The main performance impact of the old GATHER_PLAN_STATISTICS / statistics_level = ALL instrumentation came from the fact that expensive timing (gettimeofday()) system calls were used for getting A-Times of row sources.

STDDEV: Standing Sentinel on Your Data

Submitted by JonathanGennick on Sun, 2013-03-17 04:00

Oracle Database implements a family of STDDEV functions for computing the
standard deviation from the mean. If you think of the mean as beginning to
paint a picture of the underlying data, then...



Read the full post at www.gennick.com/database.

STDDEV: Standing Sentinel on Your Data

Submitted by JonathanGennick on Sun, 2013-03-17 04:00

Oracle Database implements a family of STDDEV functions for computing the
standard deviation from the mean. If you think of the mean as beginning to
paint a picture of the underlying data, then...



Read the full post at www.gennick.com/database.

AMIS Masterclass – Two Day Masterclass with Oracle ACE Director James Morle

Submitted by marco on Sat, 2013-03-16 08:16

AMIS is spending a lot of effort keeping our people up-to-date with the latest knowledge needed to help our customers the best way we can. Traditionally we also always try to share our knowledge with customers and others, via social media or conferences, and while abroad learning from others at the same time. It is …

Continue reading »

VirtualBox 4.2.10…

Submitted by oraclebase on Fri, 2013-03-15 19:50

Were you thinking, “I’ve got nothing better to do this weekend than to download the latest version of VirtualBox and update the guest additions on all my VMs”? Well your luck is in!

Oracle have just released VirtualBox 4.2.10. The downloads and changelog are in the usual places.

Happy upgrading!

Cheers

Tim…

Premature Optimization

Submitted by Chris Antognini on Thu, 2013-03-14 23:30

Premature optimization, (probably) because of Donald Knuth’s famous line “premature optimization is the root of all evil,” (see Structured Programming with go to Statements) is, at the very least, a controversial topic. The misconception based on that particular quote is that a programmer, while writing code, should ignore optimization altogether. In my opinion this is wrong. To put the quote in context, let’s have a look to at the text that precedes and follows it:

The problem with free and RSS…

Submitted by oraclebase on Thu, 2013-03-14 20:47

The internet has been awash with people bemoaning the decision by Google to close Google Reader. Probably the next biggest talking point has been people asking what they can use to replace it when it’s gone. I’m planning on giving TheOldReader.com a test-drive, once I can get my feeds imported. :)

The problem with free

UltraEdit v19 for Windows

Submitted by oraclebase on Thu, 2013-03-14 15:00

For all those folks who are forced to use Windows, you might be interested to know UltraEdit v19 has just been released.

You can check out the new features here.

The latest version for Mac/Linux is still 3.3, so maybe we are due a new version there too?

Cheers

Tim…