Skip to content

DBAzine.com

Sections
Personal tools
You are here: Home » Blogs » Chris Foot Blog » Chris Foot's Oracle10g Blog » Oracle10G Hidden Features Part I » SimpleBlogFullSearch
Seeking new owner for this high-traffic DBAzine.com site.
Tap into the potential of this DBA community to expand your business! Interested? Contact us today.
Who Are You?
I am a:
Mainframe True Believer
Distributed Fast-tracker

[ Results | Polls ]
Votes : 3605
 

Search results

Let’s take a look at an Oracle feature that I used quite regularly in 9i OEM to perform “what if” index scenarios during optimization testing. Although 10G Grid Control doesn’t provide the same graphical interface as 9i OEM, we can still utilize this hidden feature in 10G to simplify and accelerate the SQL tuning process
Thursday, May 31, 2007  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-05-31.6959101573/sbtrackback
This series covers a few of the features that you may often overlook when using 10G. There are so many features in each new release of Oracle's flagship database that the challenge is to leverage as many features as possible to make your day-to-day life easier.
Monday, April 30, 2007  |  Permalink |  Comments (1)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-04-28.5119185797/sbtrackback
I thought I would combine two different topics of conversation. We'll review of some of the 10G features that we take for granted or are easily overlooked. The discussion also continues its lighthearted review of day-to-day DBA life and provides a few helpful hints and tips to make that life easier. Weird combination but it may make for an interesting and informative read.
Monday, April 16, 2007  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-04-15.6658230898/sbtrackback
I review some of the 10G features that we take for granted or often overlook. The discussion, although somewhat whimsical at times, does provide some very useful information.
Monday, April 09, 2007  |  Permalink |  Comments (1)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-04-06.2643727574/sbtrackback
This blog contains a listing of my top 10G Tuning Tools. These are the tools that I most often turn to when I am faced with a “database performance challenge.” In upcoming blogs, we’ll discuss tools that are available in Oracle 9i as well as review some generic tuning utilities.
Monday, April 02, 2007  |  Permalink |  Comments (1)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-03-31.3616747160/sbtrackback
We combine all of the knowledge we learned in previous blogs of this series to begin our scientific analysis on Oracle optimization. We’ll review some of tools we can use to display access path information and look at some graphical displays that will assist us during the analysis process. I’ll also provide you with some examples to jump-start your testing.
Tuesday, March 20, 2007  |  Permalink |  Comments (2)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-03-17.4269055673/sbtrackback
We continue our series on Oracle access path scientific analysis. In this latest installment, we’ll do a quick review of some of the blogs that led us to this point. We’ll also learn how to select a set of SQL statements that we will use in our test cases.
Monday, March 12, 2007  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-03-11.8660796218/sbtrackback
Although I didn’t want to break the flow of our series on access path scientific analysis, it is important for us to review the upcoming DST changes one last time. We’ll return to our original discussion on access paths in my next blog.
Monday, March 05, 2007  |  Permalink |  Comments (2)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-03-04.1596857853/sbtrackback
Now that we have an understanding of how we can influence access paths using hints and session parameter changes, let’s continue our discussion by reviewing the various types of indexes as well as indexing strategies that affect Oracle access path selection. We’ll complete this series next week when we use all of the information we have learned to perform our own scientific analysis on Oracle optimization.
Monday, February 26, 2007  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-02-24.7493837565/sbtrackback
We continue to analyze the affects that initialization parameters, statistics and hints have on SQL statement access paths. In this blog, we'll take a look at the hints we will be using to influence the optimizer to select an access path that is different from the one it would normally choose. We'll also review a few of the tools that we will be using to monitor and compare SQL statement access paths and performance for our upcoming tests.
Monday, February 19, 2007  |  Permalink |  Comments (0)
trackback URL:   http://www.dbazine.com/blogs/blog-cf/chrisfoot/blogentry.2007-02-14.3900730733/sbtrackback
 

Powered by Plone