Blog Aggregator - Amardeep Sidhu

The 10G segment advisor identifies segments that have become fragmented as a result of update and delete operations. Oracle describes these objects as being sparsely populated. Not only do sparsely populated objects waste space but they can also contribute to SQL performance problems.

This blog will show you how to use the 10G segment advisor to identify sparsely populated segments. In my next blog, we’ll discuss the different alternatives we can use to reclaim the wasted space.

The memory advisors can only be activated when 10G’s automatic shared memory management feature is turned off. Since the memory advisors are pretty simple, I thought I would include a discussion on 10G’s automatic shared memory management feature. So consider this blog to be your first “two for one special” from your friendly ex-Oracle instructor.

SQL tuning can be a real pain. I have been doing it for 15 years and it is still one of the most challenging parts of my job. I have always described SQL tuning as more of an art than a science. Hopefully, as the SQL Tuning Advisor matures, it will help transform a once time-consuming and arduous burden into just one more line item on a DBA’s “TODO” list. This blog presents an overview of 10G Grid Control’s SQL Tuning Advisor.

SQL Tuning Sets are stored groupings of SQL statemtents that can be used as input to the SQL Access Advisor and the SQL Tuning Advisor (next blog). If you intend to use 10G Grid Control to tune SQL, you’ll be using SQL Tuning Sets. So, I’d like to spend a few minutes discussing them before we discuss the SQL Tuning Advisor.

We have reached the final blog on 10G R2 New Features. I think that after reading the last blog of this series, you’ll agree that 10G R2 (like all new Oracle releases) contains a LOT of interesting and beneficial enhancements.

I’ll get back on track in the next blog by discussing how to use 10G Enterprise Manager SQL Tuning Sets.