Chris Foot's Oracle10g Blog
The Importance of Soft Skills
I thought I would deviate from my usual discussion on 10G technical topics for one blog. I’d like to talk about non-technical skill sets and the important role they play in our careers.
It used to be that you could get by with a total lack of interpersonal skills in our profession. Well those days are long gone. If you want to succeed, you’ll need to learn how to communicate effectively and play well with others. This blog contains a few pearls of wisdom, and a story or two, to help you become a well-rounded technician that is on the fast track to a successful career.
It used to be that you could get by with a total lack of interpersonal skills in our profession. Well those days are long gone. If you want to succeed, you’ll need to learn how to communicate effectively and play well with others. This blog contains a few pearls of wisdom, and a story or two, to help you become a well-rounded technician that is on the fast track to a successful career.
Monday, June 19, 2006
|
Permalink |
Comments (4)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-06-16.6580435609/sbtrackback
Let’s finish this series on 10G Data Pump by investigating the Data Pump Import utility. In this blog, we'll learn how to execute 10G Data Pump Import and take advantage of some of its more popular features.
Monday, June 12, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-06-08.1893574515/sbtrackback
This is part three of a series on 10G Data Pump. In part one, we reviewed a few of the new features that make Data Pump Export and Import attractive alternatives to their ancestors, Export and Import. Part two focused on the 10G Data Pump architecture. We continue the discussion in this blog by learning how to use 10G Data Pump Export to "pump" data out of an Oracle database.
Monday, June 05, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-06-02.2786242018/sbtrackback
Now that we have a general understanding of some of the features that 10G Data Pump provides, let’s peel back a few of the layers and see how this utility works. In this blog, we’ll take an in-depth look at the Data Pump architecture.
_____tags:
Tuesday, May 30, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-05-26.3042156388/sbtrackback
Describing the Oracle Export and Import utilities as slow is like saying the Titanic sprung a small leak. Stories of Export and Import executions running for hours (and sometime days) are commonplace. Oracle 10G provides a new data movement utility, called Data Pump, to increase the performance of data transfers.
Now that I've used Data Pump, I found out that the improvements go far beyond mere performance enhancements. In part 1 of this multi-part series on the Data Pump toolsets, I'll cover some of the new features and functionalities the utility provides. In upcoming blogs, we'll take a look at the data pump architecture and compare the toolset to its ancestors Export and Import.
Now that I've used Data Pump, I found out that the improvements go far beyond mere performance enhancements. In part 1 of this multi-part series on the Data Pump toolsets, I'll cover some of the new features and functionalities the utility provides. In upcoming blogs, we'll take a look at the data pump architecture and compare the toolset to its ancestors Export and Import.
Monday, May 22, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-05-19.6918984141/sbtrackback
Correctly sizing online redo log files is critical if you want to achieve ‘maximus database performis’. 10G Grid Control provides a redo log file sizing advisor that provides administrators with an initial sizing recommendation. I’ll begin this blog by showing you how to use the automatic sizing advisor and continue our discussion by explaining the manual process of determining the size of your online redo logs.
Monday, May 15, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-05-12.4552485084/sbtrackback
Although I provided a quick demo on how to use 10G Grid Control’s SQL Access Advisor in an earlier blog, I think it may be beneficial for us to take a more in-depth look at this powerful utility. We’ll peel back the covers to find out what the SQL Access Advisor actually does when you activate it as well as the benefits it provides. I think you will find that the SQL Access Advisor is a strong analysis tool that deserves your consideration.
Monday, May 08, 2006
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-05-05.3335525140/sbtrackback
In a few of my previous blogs, I provided instructions on how to use 10G Grid Control to run the SQL Tuning Advisor and the SQL Access Advisor. In this next couple of blogs, we’ll peel back the layers and find out exactly what happens when these utilities are executed.
In part one of this multi-part blog on the advisors, we take a look at how the SQL Tuning Advisor uses the optimizer to generate its tuning recommendations. We’ll also cover the types of recommendations it provides and how it comes to those conclusions.
In part one of this multi-part blog on the advisors, we take a look at how the SQL Tuning Advisor uses the optimizer to generate its tuning recommendations. We’ll also cover the types of recommendations it provides and how it comes to those conclusions.
Monday, May 01, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-04-28.3742757902/sbtrackback
10G provides so many automatic features that it should have been called 10A for Automatic. Over the course of this blog, I have covered many of the automated features that were introduced in Oracle's latest and greatest release. There are a couple of automatic features that I haven't covered yet that warrant further investigation. We'll discuss automatic undo retention tuning, automatic checkpoint tuning and automatically tuned multi-block reads.
Monday, April 24, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-04-20.2949600305/sbtrackback
Temporary tablespaces are used to store transient data, which Oracle defines as data that is only available for the duration of the session. The two main types of transient data is data stored in temporary tables and data that is generated by sort operations. Oracle provides temporary tablespaces that are optimized for storage of transient data.
Oracle10G allows administrators to group multiple temporary tablespaces together and assign them to users as a single unit. We'll begin our discussion on temporary tablespace groups by reviewing sort operations and temporary tablespaces, then continue with a discussion on 10G temporary tablespace groups.
_____Oracle10G allows administrators to group multiple temporary tablespaces together and assign them to users as a single unit. We'll begin our discussion on temporary tablespace groups by reviewing sort operations and temporary tablespaces, then continue with a discussion on 10G temporary tablespace groups.
tags:
Monday, April 17, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-04-14.0082403220/sbtrackback
We all know that the desired result of any tuning exercise is to reduce the amount of time that users spend performing database activities. Good tuners understand that the tuning process starts with an understanding of the problem then continues with the DBA collecting statistical information. Information collection begins at a global level and then narrows in scope until the problem is pinpointed.
Experienced DBAs often start their tuning efforts by selecting data from the V$ dynamic performance tables to view system-wide performance indicators. Thanks to Oracle 10G, we have two new views to add to our tuning arsenal. We’ll take a look at these two time model views in this blog and learn how we can use them to determine where the user processes are spending their time.
Experienced DBAs often start their tuning efforts by selecting data from the V$ dynamic performance tables to view system-wide performance indicators. Thanks to Oracle 10G, we have two new views to add to our tuning arsenal. We’ll take a look at these two time model views in this blog and learn how we can use them to determine where the user processes are spending their time.
Monday, April 10, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-04-08.0966928498/sbtrackback
Readers of this blog know how important I think 10G Grid Control is to the future of Oracle database administration. DBAs must learn to leverage the intelligence built into the Grid Control product set to reduce the amount of time they spend administering, monitoring and troubleshooting Oracle databases.
That being said, there are times when you don't have access to a full blown, enterprise-wide Grid Control environment. Not to worry, Oracle also provides the 10G Database Control administration toolset. 10G Database Control can be used to effectively administer a single Oracle database. Although 10G Database Control might not have the enterprise-wide scope that Grid Control does, it does provide a very robust set of features and functions that are guaranteed to make database administrators more productive. This blog will provide you with a brief overview of the 10G Database Control product set. We'll also compare and contrast Database Control to its big brother, Grid Control.
That being said, there are times when you don't have access to a full blown, enterprise-wide Grid Control environment. Not to worry, Oracle also provides the 10G Database Control administration toolset. 10G Database Control can be used to effectively administer a single Oracle database. Although 10G Database Control might not have the enterprise-wide scope that Grid Control does, it does provide a very robust set of features and functions that are guaranteed to make database administrators more productive. This blog will provide you with a brief overview of the 10G Database Control product set. We'll also compare and contrast Database Control to its big brother, Grid Control.
Monday, April 03, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-03-29.0050872616/sbtrackback
I thought it might be interesting for those of us that don’t administer RAC environments on a daily basis to talk to someone that does. Scott Rupnik is one of our senior-level RAC administrators. Since we administer RAC implementations for many different customers, Scott has experience administering RAC ecosystems that use many different hardware, operating system and disk storage combinations.
This provides Scott with a unique skill set this is pretty rare in our profession. In addition, since Scott has a strong background in both database and operating system administration, he is able to provide us with insight on both of these two tightly coupled RAC components.
_____This provides Scott with a unique skill set this is pretty rare in our profession. In addition, since Scott has a strong background in both database and operating system administration, he is able to provide us with insight on both of these two tightly coupled RAC components.
tags:
Monday, March 27, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-03-25.7835630163/sbtrackback
One of the benefits of working for a remote database services provider is the caliber of people you get to work with. We have some very talented people here at Contemporary Technologies (CTi) and I fully intend to leverage their expertise to improve the quality of this blog.
In addition, I now have access to a wide range of technologies and Oracle features. Since we provide services to many different companies, I will be able to expand the scope of this blog to cover a much wider spectrum of topics.
I’ll provide you with a quick preview of what is coming in the future. In my next blog, I’ll interview Scott Rupnik. Scott is our resident 10G RAC expert. We’ll discuss the benefits of 10G RAC and Scott will provide some helpful hints and tips on 10G RAC installation and administration.
_____In addition, I now have access to a wide range of technologies and Oracle features. Since we provide services to many different companies, I will be able to expand the scope of this blog to cover a much wider spectrum of topics.
I’ll provide you with a quick preview of what is coming in the future. In my next blog, I’ll interview Scott Rupnik. Scott is our resident 10G RAC expert. We’ll discuss the benefits of 10G RAC and Scott will provide some helpful hints and tips on 10G RAC installation and administration.
tags:
Monday, March 20, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-03-18.8819580696/sbtrackback
Readers of this blog know that I rarely stray off topic. The intent of this blog to provide technical information to readers that is hopefully both informative and interesting.
That being said, I thought I would write one blog on my personal career path. A career path that will be different by the time my next blog is released. Rest assured that I intend to get back on topic as soon as ppssible.
That being said, I thought I would write one blog on my personal career path. A career path that will be different by the time my next blog is released. Rest assured that I intend to get back on topic as soon as ppssible.
Monday, March 13, 2006
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-03-12.7540418839/sbtrackback
I was going to show you how to schedule statistics gathering jobs manually in 10G Grid Control, but I just used a neat feature that I'd like to show you. 10G Grid Control R2 provides a Hang Analysis tool that helps administrators easily identify contention problems.
We recently used the Hang Analysis feature to quickly identify an application transaction that was blocking other transactions from successfully executing. I thought it might be beneficial for us to deviate from our intended topic of discussion to review 10G R2 Grid Control's Hang Analysis tool. This is one feature that I think you'll find to be VERY worthwhile!
_____We recently used the Hang Analysis feature to quickly identify an application transaction that was blocking other transactions from successfully executing. I thought it might be beneficial for us to deviate from our intended topic of discussion to review 10G R2 Grid Control's Hang Analysis tool. This is one feature that I think you'll find to be VERY worthwhile!
tags:
Monday, March 06, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-03-04.9606206243/sbtrackback
Now that we understand how to set up maintenance windows, let’s take a look at 10G Grid Control’s (Enterprise Manager), default statistics gathering options. It is important that we understand what the options are and how to configure them. Only then can we determine if the automatic and manually executed statistics gathering jobs are configured to meet the needs of our individual database applications.
Monday, February 27, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-02-26.6820456598/sbtrackback
Now that we have a general understanding of the important role that statistics play in query optimization, let's forge ahead with our discussion on statistics administration best practices. In this blog, we'll learn how to configure 10G Grid Control R2's maintenance windows to tailor them to meet our application's business processing requirements. In the next blog, we'll examine the optimizer statistics gathering default options page and discuss what some of the recommended settings should be.
In the last blog of this series, we’ll complete our discussion on 10G Grid Control R2 optimizer statistics administration by learning how to schedule optimizer statistics gathering jobs manually.
In the last blog of this series, we’ll complete our discussion on 10G Grid Control R2 optimizer statistics administration by learning how to schedule optimizer statistics gathering jobs manually.
Monday, February 20, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-02-18.8379309049/sbtrackback
10G Grid Control provides an optimizer statistics administration panel that allows administrators to gather, restore, delete, lock and unlock object statistics. Before we learn how to use 10G Grid Control R2’s object statistics administrations panels, let's take a quick look at object statistics and find out why they are so important to effective query optimization.
Part 1 of this three part series will provide a high-level overview of optimizer statistics. Part 2 will focus on maintenance windows that control when automatic statistics gathering jobs run. In part 3, we’ll learn how to use 10G Grid Control R2 to ensure that the optimizer has the correct statistical information it needs to generate optimal access paths.
_____Part 1 of this three part series will provide a high-level overview of optimizer statistics. Part 2 will focus on maintenance windows that control when automatic statistics gathering jobs run. In part 3, we’ll learn how to use 10G Grid Control R2 to ensure that the optimizer has the correct statistical information it needs to generate optimal access paths.
tags:
Monday, February 13, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-02-11.0939245208/sbtrackback
We are moving forward with our ASM evaluation. We recently held a facilitated brainstorming session that was led by Giant Eagle’s ace data administrator Jim McQuade. Jim has extensive training and experience in meeting management and did an excellent job leading the meeting. I thought I would spend a few minutes on effective meeting management and show you the rough draft of our high-level ASM test plan.
Wednesday, February 08, 2006
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2006-02-05.5499110760/sbtrackback
