Monday, June 27, 2011

Hotsos Updates

As many of you know, I am a Senior Performance Consultant at Hotsos. I just wanted to take a moment to point out some recent company related activity. There are a lot of exciting things happening with Hotsos right now.

Symposium 2012 is open for registration and for presentation submissions.  The symposium will be held March 4-8, 2012 at the Omni Mandalay Hotel in Irving, TX. This will be the Tenth Symposium, so I know there are some cool things planned. If you haven't attended before, this is the year to attend. If you have any good ideas for a topic to discuss, the deadline for submitting a presentation is September 30.

Also, HAWCS 4.1 is ready for customers. HAWCS is a tool that helps to monitor E-Business Suite installations. It will assist with identifying the heaviest consumers on the system and other areas needing some performance tuning. If you use EBS, consider purchasing this tool. If you already have the tool, consider upgrading to latest version.

To keep up with the latest Hotsos news, follow this blog:
http://hotsoseducation.blogspot.com/

Thursday, June 16, 2011

Applied Analytics Part 2

The analytic Pivot feature can be used to present useful information in an easy to read format. This is the case when you have information in multiple rows that you would rather display in multiple columns.

For example, recently I wanted to view information about the busiest database objects. When doing performance tuning, this information can be valuable. Oracle provides the v$segment_statistics view to contain performance metrics for each object.

Since I only wanted to review certain metrics and wanted to see all metrics from each object, the following pivot query was created. This query could be ordered by any column to show the top objects for that column's metric. Being able to see the other metrics for each object on the same line made the output more useful.

Example query:
With pivot_stats as (
select owner,object_name,statistic_name,value from v$segment_statistics
)
select * from pivot_stats
PIVOT
(sum(value) for statistic_name in ('logical reads', 'physical writes' ,'row lock waits' ))