Chris Foot's Oracle10g Blog
10G OEM Grid Control Performance Overview
Consider this to be the first of many blogs on the art of performance monitoring and tuning using 10G Enterprise Manager. I'll start the series by discussing how the latest release of Oracle's SGT (Sissy GUI Tool) will force us to change the way administer, monitor and tune Oracle databases.
In upcoming blogs, I'll break 10G Grid Control's monitoring infrastructure into individual components and discuss each one in-depth. By the time I'm done, we'll all be 10G Enterprise Manager experts.
In upcoming blogs, I'll break 10G Grid Control's monitoring infrastructure into individual components and discuss each one in-depth. By the time I'm done, we'll all be 10G Enterprise Manager experts.
Monday, April 04, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/performanceoverview/sbtrackback
In my last blog, I discussed the various testing strategies we implemented at Giant Eagle to make sure we had a trouble-free migration to Oracle's latest and greatest release. In this blog, I'll discuss some general techniques you can use to make any database upgrade easier and less error-prone.
In upcoming blogs, I'll cover how we have configured 10G Enterprise Manager to monitor and administer our 10G test and production databases. In addition, I'll also describe how we use the tool to perform performance monitoring and tuning. Performance monitoring and tuning using 10G EM is so drastically different than 9I OEM, that it is definitely worthwhile for me to spend some time telling you how we use it. With SQL joining billion row tables on a regular basis, we quickly become experts on all new tools we use here.
In upcoming blogs, I'll cover how we have configured 10G Enterprise Manager to monitor and administer our 10G test and production databases. In addition, I'll also describe how we use the tool to perform performance monitoring and tuning. Performance monitoring and tuning using 10G EM is so drastically different than 9I OEM, that it is definitely worthwhile for me to spend some time telling you how we use it. With SQL joining billion row tables on a regular basis, we quickly become experts on all new tools we use here.
Thursday, March 31, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10gupgradetips/sbtrackback
It has been a long process, but we have successfully converted our first production warehouse to Oracle10G. The database has been running for over a week now with no problems and is performing better than we thought it would. In this first post-turnover blog, I'll cover some of the testing strategies we used to ensure a successful migration to Oracle10G. In part 2, I'll provide you with a laundry list of helpful tips and techniques you can use to make any database upgrade easier and less error-prone.
Friday, March 25, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/productionturnover/sbtrackback
Consider this to be my first "stop the presses" blog. We ran into an issue with RMAN that I think everyone needs to know about. Although the problem's impact was significant enough to stop our 10G conversions, we have identified an easily implemented preventative measure, a fix and an explanation.
If you intend to upgrade any 9I databases to 10G and use RMAN to back them up, it would be worthwhile for you to spend a few minutes reading this blog. If you don't, you may be recreating all of your database's controlfiles to fix a problem that is EASILY prevented.
If you intend to upgrade any 9I databases to 10G and use RMAN to back them up, it would be worthwhile for you to spend a few minutes reading this blog. If you don't, you may be recreating all of your database's controlfiles to fix a problem that is EASILY prevented.
Wednesday, March 16, 2005
|
Permalink |
Comments (3)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/rmanregproblem/sbtrackback
Giant Eagle's warehouse development team has also been busy putting Oracle10G through its paces. We have spent a lot of time learning how to administer Oracle's latest and greatest release, so let's now turn our attention to what Giant Eagle's application developers have been up to. In this blog, we'll review the results of our application testing and compare some batch and on-line execution times from our 9I data warehouse to its 10G counterpart.
Wednesday, March 09, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/applicationperformance/sbtrackback
I'll begin part 2 of my series on RMAN by discussing a few of the 10G enhancements that we are interested in. I'll finish this series with our 10G RMAN test plan. Considering that we will be using this new release of RMAN to back up and recover our multiple terabyte data warehouses, I won't rest easy until I know I have tested every command that we use here at Giant Eagle.
Call me paranoid but I will never, ever, ever trust any tool with my career. The test plan included in this blog may seem like overkill to you, but if it reduces my personal anxiety and lowers my (and my unit's) stress during our next recovery, the time spent testing RMAN will be well worth it. The more stressed you are during a recovery, the greater the chance you will have of making mistakes. Recoveries are stressful enough. I don't want to be wondering if the tool is going to work.
Call me paranoid but I will never, ever, ever trust any tool with my career. The test plan included in this blog may seem like overkill to you, but if it reduces my personal anxiety and lowers my (and my unit's) stress during our next recovery, the time spent testing RMAN will be well worth it. The more stressed you are during a recovery, the greater the chance you will have of making mistakes. Recoveries are stressful enough. I don't want to be wondering if the tool is going to work.
Friday, March 04, 2005
|
Permalink |
Comments (3)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10grmanpart2/sbtrackback
Recovering an Oracle database is a wonderfully complex task. Data files, log files, control files, full
backups, hot backups and point-in-time recoveries all combine to make many administrators lie awake
nights wondering if their databases can be easily recovered. Oracle10G contains numerous
enhancments to the RMAN backup utility. As a result, a thorough testing of 10G RMAN is warranted.
In part 1 of this 2 part series, I'll provide you with a few backup and recovery tips, tricks and techniques that I think will help both beginners and experts alike. Since we are RMAN aficionados here at Giant Eagle, I'll finish the blog with an introduction to RMAN. In part 2, I'll highlight a few of the 10G RMAN new features we are interested in and provide you with Giant Eagle's detailed 10G RMAN test plan.
In part 1 of this 2 part series, I'll provide you with a few backup and recovery tips, tricks and techniques that I think will help both beginners and experts alike. Since we are RMAN aficionados here at Giant Eagle, I'll finish the blog with an introduction to RMAN. In part 2, I'll highlight a few of the 10G RMAN new features we are interested in and provide you with Giant Eagle's detailed 10G RMAN test plan.
Monday, February 28, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10grmanpart1/sbtrackback
After spending 20 hours testing Enterprise Manager, I'm happy to report that everything works as advertised. The tool is rock-solid. I thought for sure the product would have at least a few problems that I could report on. So instead of a bug discussion, this blog contains some of the tips and tricks I learned during the execution of my Enterprise Manager test plan.
Thursday, February 17, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oemtestresults2/sbtrackback
This is the first release of Oracle that has forced me to spend more time learning how to use the tool to administer the database than I have spent testing the new features the database provides. Now that our 10G OEM testing is finally complete, I'll provide you with two blogs in quick succession. In this first blog, I'll provide you with a high-level over of what we found during our installation and in-depth testing. In the second I'll finish my discussion on OEM with a bulleted list of notes that I compiled during my 20 hours of putting 10G OEM through its paces.
Sunday, February 13, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oemtestresults1/sbtrackback
We have been testing Oracle10G for some time now. So, I thought I'd spend 5 minutes giving you a quick update on a few new features we are interested in.
Thursday, February 03, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10gfeaturesilike/sbtrackback
We now have several 10G analysis projects underway. I thought I’d give you a quick update on our accomplishments (or lack thereof) on one of them. This will hopefully prevent others from experiencing the same issues that we just have.
Tuesday, February 01, 2005
|
Permalink |
Comments (1)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10goemlessons/sbtrackback
Even with all of the high-tech bells and whistles that 10G offers, the database is useless to us if we can't administer it effectively. For years now, Oracle Enterprise Manager (OEM) has been the sissy GUI administrative tool of choice for Oracle databases. Oracle10G's OEM is radically different than previous versions. In this blog, I'll provide you with a high level overview of Oracle10G OEM and Giant Eagle's OEM testing plan.
Friday, January 28, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10goemtesting/sbtrackback
Let's take a quick look at our first 10G data warehouse database. Well begin by reviewing some basic reports that describe the general database environment and database structures. As a gift from your friendly ex-Oracle instructor, I'll also provide you with the scripts that generated them. I'll finish the blog with an overview of our Oracle10G testing strategies.
Saturday, January 22, 2005
|
Permalink |
Comments (2)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/teststrategydboverview/sbtrackback
In Part 2 of our series on upgrading databases to 10G, we review the different upgrade mechanisms available to us: Export/Import, manual upgrade, data copy and the Database Upgrade Assistant (DBUA). I'll finish by providing you with some hints and tips that will help you choose the most appropriate upgrade method for your environment.
Saturday, January 15, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10gconversionparttwo/sbtrackback
Oracle10G, like all previous releases, allows administrators to choose their conversion toolsets. Let's take a couple of minutes to investigate, compare and contrast the primary Oracle10g upgrade mechanisms that are available. I'll start our discussion by providing you with some upgrade hints and tips that will help you create a successful Oracle10G upgrade strategy.
Monday, January 10, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10gconversionpartone/sbtrackback
Before we continue with our discussion on Oracle 10G, I'd like to take a quick literary detour into the world of 10G on Linux. One of our warehouse developers, Jason Heese, has been testing and benchmarking Oracle10G on Linux for some time now. Since I respect Jason's opinion, I thought I'd reserve this blog for Jason's thoughts on the Oracle10G/Linux combination.
Tuesday, January 04, 2005
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oracleonlinux/sbtrackback
In my last blog, I reviewed some of of the Oracle10G parameter changes uncovered by our resident 10G researcher, Jim Dojonovic. In this next installment of our epic 10G testing saga, Jim reviews the CREATE DATABASE DDL statement, double checks the operating system environment to ensure the statement will run successfully and finally executes the DDL to create our data warehouse test database.
Tuesday, December 28, 2004
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oracle10gdbcreate/sbtrackback
Before creating their first data warehouse test database, the DBAs at Giant Eagle review the parameter changes contained in Oracle's latest release.
Tuesday, December 14, 2004
|
Permalink |
Comments (4)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oracle10parameters/sbtrackback
Our intrepid DBAs at Giant Eagle continue their exploration of Oracle10G by installing the database binaries on HP, IBM and LINUX.
Wednesday, December 08, 2004
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/10gbinaryinstallation/sbtrackback
Now that we have a pretty firm understanding of Oracle10G's new features, lets continue our discussion on 10G by laying the groundwork for our first production conversion. In this blog, we'll talk about how to obtain the Oracle10G product set, Oracle10G's documentation and the Oracle10G media.
Sunday, December 05, 2004
|
Permalink |
Comments (0)
trackback URL:
http://www.dbazine.com/blogs/blog-cf/chrisfoot/oracle10ginstall1/sbtrackback
