Now that Oracle Database 11g Release 2 is out, more and more folks are considering upgrading to 11g. However, if you are currently on Oracle 9i then you will have to tackle both the upgrade to a new release and the migration from the Rule-Based Optimizer (RBO) to the Cost-based Optimizer (CBO). [...]
We promised in an earlier post to cover some of the questions from the Optimizer round table discussion at Oracle Open World. Here’s our first in a series of posts that will address these questions.
Q: When moving from 10g to 11g, should hints in existing SQL be removed?
A: I was glad to see this question [...]
The Word from the Web – 11/20/2009
We’re winding down our Around the World series for this year. Take a look at some of the latest nuggets from the 2009 show. If you’ve been part of a discussion that’s been going since the It’s a Wrap party, let us know about it in the comments.
What Should [...]
Last week the patchset 10.2.0.4 was released by Oracle.
This patchset not only contains bugfixes but also comes with a number of New Features.
One of the highlights is the possibilty to capture a workload in a 10.2.0.4 database and ship it to an 11g database for testing.
Only with this feature in …
Link to the original site
Leng Leng Tan announced in her presentation yesterday, that
patchset 10.2.0.4 which will be available very soon!!!
which will allow to mask sensitive data in a captured workload
so it is not possible to read the data in plain in the testing environment, but still run the workload for testing anyway. This will definitively make …
Link to the original site
I’ve been meaning to write up my thoughts from this years IOUG Collaborate event. Ian Abramson, the president of the IOUG, has a nice series of write ups on the event itself – starting with day 1 through day 3 and then a wrap-up post. He describes it as a three day event – but [...]
Task Flows are the primary mechanism in ADF 11g for organizing the workload in manageable chunks that can be developed in a decoupled fashion in relative isolation, then merged together in web pages that implement the desired functionality. Task Flows are also one of the key mechanisms for reuse – along with but for other [...]
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 [...]
Part two of a two-part blog series that describes the new features contained in Oracle10G. In this blog, we’ll review the following 10G new features: Automatic SGA Managment, Automatic Workload Repository, Automatic Database Diagnostic Monitor, SQL Access Advisor, Transportble Tablesace and Data Pump. Maybe 10G should have been named 10A [...]
Part two of a two-part blog series that describes the new features contained in Oracle10G. In this blog, we’ll review the following 10G new features: Automatic SGA Managment, Automatic Workload Repository, Automatic Database Diagnostic Monitor, SQL Access Advisor, Transportble Tablesace and Data Pump. Maybe 10G should have been named 10A [...]