Chris Foot's Oracle10g Blog
10G Shrink Command
We were in the process of discussing 10G Grid Control’s Segment Analyzer before being interrupted by a one terabyte table that I discussed in the last blog. In this blog, I’ll get back on track by reviewing the different alternatives we can use to reclaim wasted space in Oracle10G.
Since the Segment Analyzer and online shrink command were introduced in Oracle10G, I’ll spend a few minutes discussing how you can identify and shrink objects in pre-10G releases.
Since the Segment Analyzer and online shrink command were introduced in Oracle10G, I’ll spend a few minutes discussing how you can identify and shrink objects in pre-10G releases.
Monday, September 12, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-09-10.8045550726/sbtrackback
Consider this to be yet another "Stop the Presses Blog". I originally intended to discuss the different toolsets that DBAs can use to reclaim unused space allocated to Oracle objects. This installment was to be the follow-up to my previous blog on the Segment Analyzer. But we have hit an important milestone here at Giant Eagle, so I thought I would deviate from my intended topic for one blog.
If you have been following this series, you'll know that my unit is responsible for administering several large data warehouses. The warehouse that we most recently converted to 10G has a single, partitoned table that has just grown to one terabyte in size. The entire database is multiple terabytes and rapidly growing at hundreds (and hundreds) of MEGs per month. We estimate that within 2 years, the database will be close to 10 terabytes in size. I thought it might be interesting to interview our "big data" DBA, Jim Dojonovic. Jim is responsible for administering our data warehouses.
If you have been following this series, you'll know that my unit is responsible for administering several large data warehouses. The warehouse that we most recently converted to 10G has a single, partitoned table that has just grown to one terabyte in size. The entire database is multiple terabytes and rapidly growing at hundreds (and hundreds) of MEGs per month. We estimate that within 2 years, the database will be close to 10 terabytes in size. I thought it might be interesting to interview our "big data" DBA, Jim Dojonovic. Jim is responsible for administering our data warehouses.
Tuesday, September 06, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-09-06.2918203481/sbtrackback
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.
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.
Monday, August 29, 2005
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-08-25.8847176467/sbtrackback
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.
Monday, August 22, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-08-19.0090015270/sbtrackback
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.
Monday, August 15, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-08-11.0227938704/sbtrackback
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.
Monday, August 08, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-08-02.1208871355/sbtrackback
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.
I'll get back on track in the next blog by discussing how to use 10G Enterprise Manager SQL Tuning Sets.
Monday, August 01, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-07-25.6154655837/sbtrackback
Oracle has recently announced that 10GR2 for Linux is available for download from their technical website. If you read my last blog, you will probably agree that this release has some pretty interesting and beneficial features. But there are a few more enhancements that we need to cover before we can call ourselves 10G R2 new features experts. So, let's forge ahead and continue our discussion on 10G Release 2.
Friday, July 22, 2005
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-07-21.4277544177/sbtrackback
OK, here comes another "Stop the Presses" blog. I intended to discuss the SQL Tuning Advisor, but Oracle 10G R2 intervened. Since Oracle is currently publicizing all of the features contained in the latest and greatest release of its flagship product, I thought it would be appropriate to spend a few blogs discussing them.
Rest assured, we will continue our discussion on the10G EM advisors once we have completed our review of 10G R2.
Rest assured, we will continue our discussion on the10G EM advisors once we have completed our review of 10G R2.
Saturday, July 16, 2005
|
Permalink |
Comments (5)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-07-16.1165649869/sbtrackback
OK, let's continue our review of 10G Enterprise Manager's Advisors. In this blog, we turn our attention to the SQL Access Advisor (not to be confused with the SQL Tuning Advisor which is a totally different tool). We'll begin by reviewing the benefits that the SQL Access Advisor provides and finish with a quick demo of the tool.
Thursday, July 07, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-07-06.5201081269/sbtrackback
OK, now that I’ve given you a “brief” overview of the 10G Grid Control advisor toolsets, let’s start our in-depth discussions of them by reviewing Oracle’s Automatic Database Diagnostic Monitor (affectionately known as ADDM).
Once I cover all of the advisors, we’ll review what we have learned and then apply our newfound knowledge by running through a couple of performance tuning scenarios.
Once I cover all of the advisors, we’ll review what we have learned and then apply our newfound knowledge by running through a couple of performance tuning scenarios.
Thursday, June 30, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-06-30.3614041361/sbtrackback
I’ve been writing this blog for a while now. I have received a fair number of questions about my background. So I thought I would spend a few minutes in one blog discussing my “body of work” to date. Rest assured I won’t make this a habit. Mainly because I’m not that interesting. We’ll then get back on topic and continue our discussion on the 10G EM advisors.
Monday, June 20, 2005
|
Permalink |
Comments (3)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-06-20.6982554476/sbtrackback
In my last blog, I presented a quick overview of 10G Enterprise Manager’s database performance monitoring capabilities. Oracle’s latest release also contains numerous enhancements to Enterprise Manager’s advisor utilities. This blog contains a high level overview of the various advisors available in 10G Grid Control. In subsequent blogs, we’ll take an in-depth look at each one of them to see exactly what benefits they offer.
Friday, June 10, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-06-10.8609363343/sbtrackback
Before we begin our discussion on the intelligent advisors contained in Oracle10G, it is important that we review the entire architecture from a higher level. I want to make sure that we all have a firm understanding of 10G's Common Manageability Infrastructure before we begin reviewing the individual advisors.
To ensure that we have this firm foundation, we must learn more about the Automatic Workload Repository and Active Session History which capture the data that many of the advisors use as input. Although, the Automatic Workload Repository and Active Session History may not be as exciting as the advice provided by the advisors and the automatic tuning recommendations provided by ADDM, it is important for us to understand the information used as input by these new components.
To ensure that we have this firm foundation, we must learn more about the Automatic Workload Repository and Active Session History which capture the data that many of the advisors use as input. Although, the Automatic Workload Repository and Active Session History may not be as exciting as the advice provided by the advisors and the automatic tuning recommendations provided by ADDM, it is important for us to understand the information used as input by these new components.
Thursday, June 02, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-06-02.0384701461/sbtrackback
Let's forge ahead with our discussion on 10G Grid Control's performance monitoring capablities by turning our attention to database performance. Like the blogs on 10G host performance, I’ll break this information up into two blogs. This first blog will provide you with a quick tour of EM's database performance monitoring component. In my next blog, I'll provide you with a brief overview on how to use the information it generates to monitor database performance.
We’ll then take a look at 10G Grid Control’s performance advisors that are grouped together in Advisor Central. Once we have a firm understanding of Enterprise Manager’s performance and tuning capabilities, we’ll put our newfound knowledge to use when we use EM to solve some real-world performance problems.
We’ll then take a look at 10G Grid Control’s performance advisors that are grouped together in Advisor Central. Once we have a firm understanding of Enterprise Manager’s performance and tuning capabilities, we’ll put our newfound knowledge to use when we use EM to solve some real-world performance problems.
Monday, May 23, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-05-22.3884573887/sbtrackback
Before we begin our discussion on 10G Grid Control's database monitoring and tuning features, I thought I would show you how to configure the 10G Grid Control environment to provide automatic notifications. Creating automatic notifications allows database administrators to identify (and correct) performance and availability issues before they negatively impact the database environment.
In many of my blogs, I have been promising to cover this topic. In addition, I'm getting a little tired of writing "We'll learn more about creating and modifying performance alerts in upcoming blogs." So consider this "the upcoming blog."
In many of my blogs, I have been promising to cover this topic. In addition, I'm getting a little tired of writing "We'll learn more about creating and modifying performance alerts in upcoming blogs." So consider this "the upcoming blog."
Saturday, May 14, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-05-14.9418191992/sbtrackback
We took a quick detour from 10G in my last blog. In this blog, we get back on topic by discussing 10G Enterprise Manager's host performance monitoring and tuning features. In the final installment of this two-part series, I'll show you how to use 10G Grid Control's drilldown capabilities to identify performance problems.
Wednesday, May 04, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-05-03.4782910010/sbtrackback
What? A 9I article in a 10G blog? What happened? And its not on host monitoring like you promised? Blashpemy! Well, I thought I'd deviate from 10G for one blog to show you something neat that we have been using to tune vendor queries that are not coded for "optimal performance".
So here's what I'll do to make up for it. Because Stored Outline administration has changed somehwat much from 9I to 10G, I'll make sure I cover how Stored Outlines are created and administered in a 10G environment in a future blog.
So here's what I'll do to make up for it. Because Stored Outline administration has changed somehwat much from 9I to 10G, I'll make sure I cover how Stored Outlines are created and administered in a 10G environment in a future blog.
Thursday, April 28, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-04-27.7298144282/sbtrackback
No matter how expertly you tune an Oracle database, if the server it runs on is overloaded, underpowered or configured incorrectly, you will never obtain "maximus database performis".
So, let's start our discussion on 10G Enterprise Manager's performance monitoring features by investigating the tool's new host monitoring capabilities. This first blog will provide you with a quick tour of EM's hot new host monitoring component. In my next blog, I'll show you how you use the information it generates to monitor operating system and hardware performance.
So, let's start our discussion on 10G Enterprise Manager's performance monitoring features by investigating the tool's new host monitoring capabilities. This first blog will provide you with a quick tour of EM's hot new host monitoring component. In my next blog, I'll show you how you use the information it generates to monitor operating system and hardware performance.
Wednesday, April 20, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2005-04-19.3743394432/sbtrackback
Ok, I just got notification that the administrators need to "freeze" this blogsite for a few days. The freeze starts on Wednesday (4/13/05) and may last until this coming Friday or Monday. We are converting to a new content management system called Plone. Plone is an open-source content management system that provides the capability for blogs, RSS feeds, and other fun stuff.
I wanted to try and squeeze a blog in that discusses 10G Grid Control's new host monitoring features. These new tools will allow us to monitor and tune the hardware and operating system environment that Oracle runs on. But it looks like I'm not going to make the deadline. I started to rush through the article (or blog or whatever you want to call it) and decided that I would prefer to postpone it until next week. There is just too much information to cover and rushing through it would be a disservice to you and to the host monitoring features that 10G Enterprise Manager provides. I want to cover each new feature as thoroughly as I can. I have numerous screen prints, hints and tips I want to include in this next blog.
So we'll switch topics for a minute and I'll provide you with a quick preview of what's to come in future blogs.
I wanted to try and squeeze a blog in that discusses 10G Grid Control's new host monitoring features. These new tools will allow us to monitor and tune the hardware and operating system environment that Oracle runs on. But it looks like I'm not going to make the deadline. I started to rush through the article (or blog or whatever you want to call it) and decided that I would prefer to postpone it until next week. There is just too much information to cover and rushing through it would be a disservice to you and to the host monitoring features that 10G Enterprise Manager provides. I want to cover each new feature as thoroughly as I can. I have numerous screen prints, hints and tips I want to include in this next blog.
So we'll switch topics for a minute and I'll provide you with a quick preview of what's to come in future blogs.
Tuesday, April 12, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/performancepreview/sbtrackback
