Sunday 22 February 2009

A Lesson in Giving

Active members of the Oracle Community have some common attributes, they are willing to share what they have learnt and are not afraid to ask questions.

These are not static attributes but actually a learning circle, let me give you two examples.

Tim Gorman shares scripts to help with performance management, lets look at one of these:

sp_delta_views.sql (ASCII text file – 47Kb) SQL*Plus script containing DDL to create views that automatically calculate the "delta" or difference between adjacent samples of data gathered by the STATSPACK package. Each of these views is named the same as the corresponding tables in the STATSPACK repository, except that the prefix of "STATS$" has been replaced by a prefix of "DELTA$". These views are extremely useful in using the STATSPACK repository like a data warehouse of Oracle performance tuning information.

Many people have used the scripts and have thanked Tim for sharing, but one reader has gone further. Tanel Poder, himself a very experienced and respected presenter uses the script and taken the output into excel. And Tanel gives Tim the credit in the worksheet.

There are many comments on Tanel's blog as to how helpful this tool has been, and last week I witnessed Tanel explain it in detail to Tim, who will be using the tool himself from now on.

I know some of the newer database tools go someway to helping you with this analysis but there are a lot of people not on the latest versions and they want this kind of help.

And as for asking questions, Dan Fink often throws out questions to get people to think and to use their responses for his own research. His latest question on when is a SQL script too long? is an interesting topic that would not be discussed by people interested in only their own reputation.

Active Oracle Community members, those who regularly present, members of the ACE community, Oak table Members, user Group Leaders all want to share their knowledge and push their own learning. Join in what are you waiting for?

No comments: