11g

Behaviour Changes Oracle 8i to 11.2 + New Features Oracle 11.2 + refreshed Upgrade and Migration Slides

We have uploaded refreshed and new slide sets:

Continue reading...

It’s always the Optimizer, isn’t it?! – Part 1

Wouldn’t you agree?

My colleagues from the Optimizer Development might forgive me but a lot of people would say: “Everything went fine after upgrade – except for those tiny 3 queries!”. And I know, you have tested a lot. I’d like to tell you about a few issues we’ve seen post upgrade with 11.2.0.2.

  1. You have captured your plans in Oracle 10.2 pre-upgrade.
  2. You have moved these plans from your SQL Tuning Set into the SQL Plan Baseline in Oracle 11.2.
  3. But the optimizer doesn’t pick them although you have:
    (a) ACCEPTED and
    (b) FIXED them.

Why?

It …

Continue reading...

Database Upgrade: Most important Support Notes Oracle 11.2.0.2/3

It’s been a while … sorry for not updating the Blog this frequently in the past weeks 😉

But now I’m back in business and today I’m updating our major slide set with some new stuff. And while I’m updating it I thought about what would be the most important MOS (My Oracle Support) Notes on Database Upgrades.

Actually I would say you should start here – and these Notes should guide you to the most important bits and pieces around upgrades. I won’t claim that this is THE final list so you might have a look into our comprehensive …

Continue reading...

Hands-on with the Latest Oracle Technology

There is a new set of FREE hands-on workshops available that will give you a chance to work with Advanced Compression, Transparent Data Encryption, Real Application Testing, and GoldenGate without having to spend the time and resources to set up a test environment of your own. If you have a laptop, this is a great opportunity to actually use these options and see how they work for yourself.

Titled Oracle Database 11g Upgrade Architecture Planning Workshops,  these events are being rolled out in cities across the country. The first four are in the western part of …

Continue reading...

Oracle Database Express Edition 11g Release 2 is now available!

Many customers have asked over the past year whether we would be producing a newer version of the Oracle Database Express Edition, because it makes such a terrific starter database for students, developers, and DBAs. Well, the answer is Yes!

As of today, Oracle Database Express Edition 11g Release 2 is available for download. As with the 10g release, this Express Edition is free of charge. To find more information about downloading the software and documentation, please visit the OTN page for Express Edition.

Remember, you can always upgrade your database to Standard or Enterprise Edition if you outgrow …

Continue reading...

11.2 Upgrade Companion has been updated!

The long-awaited update of the 11.2 Upgrade Companion is now available in My Oracle Support, in the usual location (MOS Note 785351.1).

This comprehensive update incorporates lessons learned from adoption of the 11.2.0.2 patchset release. We have also included many more links for customers in a RAC/ASM (Grid Infrastructure) environment, information about the GoldenGate 11g release, and more!

As always, the Upgrade Companion is available in PDF and HTML format in addition to the web-viewable java-based document.…

Continue reading...

Thanks to all attendees in Seattle and Toronto

Seattle - APEX 2011
Must be an Oracle sponsored number plate … 😉

Thanks to everybody who did attend to our Upgrade Workshops in Seattle and Toronto past week. Seattle had a quite unusual track setup with two parallel breakout sessions. We hope you’ve enjoyed it as well. And you’ll find the slides for the keynote “New Features” and the “Upgrade Workshop – The Whole Story” presentations below.

Toronto 1

Toronto was quite amazing as well – with so many (hope not too many) people in this slightly crowded room at the Interconti in Toronto. We’ve got a lot of interesting and sometimes challenging questions. …

Continue reading...

Upcoming Upgrade and Migration Workshops in EMEA

The registration for the upcoming Upgrade Workshops in EMEA is now open – see also always the “Workshops Corner” on the right side of this blog (scroll down a bit, please).

Continue reading...

Will gathering fixed object stats reduce recompilation time post upgrade?

Interesting question, isn’t it?
Will the time to recompile invalid objects post upgrade decreased once fixed object stats have been gathered?

First of all fixed object stats on X$-tables won’t be gathered by default [This will change with Oracle 12c where it is part of the Auto Stats Gathering job].
X$ structures are undocumented. V$ views are build on top of them and
should only be used even though it might be sometimes useful to access
X$ tables such as X$BH (buffer headers – contains information describing the current contents of a piece of the buffer cache

Continue reading...

Move to Locally Managed Tablespaces

As I’ve got asked during the workshop in Warsaw how to migrate Dictionary Managed to Locally Managed tablespaces here’s some additional information and an example.

To find out if a tablespace is dictionary or locally managed you’d use this query:

SQL> select
TABLESPACE_NAME, EXTENT_MANAGEMENT from DBA_TABLESPACES;

The procedure to migrate to locally managed tablespace is:

SQL> EXECUTE
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘tbs’);

And the whole migration procedure would look like this:

STARTUP RESTRICT
EXCLUSIVE;
EXEC
DBMS_SPACE_ADMIN.TABLESPACE_MIGRATE_TO_LOCAL(‘TBS’);
— do this for all tablespaces except SYSTEM, TEMP and SYSAUX
DROP TABLESPACE
TEMP;
— necessary if there’s no “real” temp tablespace definded yet – see Note:160426.1
CREATE

Continue reading...

New hidden parameters in Oracle 11.2

We really welcome every external review of our slides. And also recommendations from customers visiting our workshops.

So it happened to me more than a week ago that Marco Patzwahl, the owner of MuniqSoft GmbH, had a very lengthy train ride in Germany (as the engine drivers go on strike this week it could have become even worse) and nothing better to do than reviewing our slide set. And he had plenty of recommendations.

Besides that he pointed us to something at least I was not aware of and added it to the slides:

In patch set 11.2.0.2 …

Continue reading...

11.2.0.2 Bundled Patch 3 for Linux x86-64bit released


NOTE ADDED ON 25-MAY-2011


Please be aware that this entry has been published a long while ago. As of today (end of May 2011) Exadata BP10 (and not BP3) is the most recent Bundle Patch. And me and some colleagues have learned in the past months that applying Exadata BPs to a non-Exadata environment might cause some trouble once you request an one-off/interim patch on top of an Exadata BP.


Officially this Bundle Patch for Oracle Database 11.2.0.2 is titled “Exadata Database recommended patch” and got released yesterday. But I would recommend this one to all customers using 11.2.0.2 Grid …

Continue reading...

Patch Set 11.2.0.2 for Win32 and Win64 now available

2010_12_16_win.jpg

Oracle Database Patch Set 11.2.0.2 for Windows (Patch: 10098816) is now available for download from support.oracle.com:

Please keep in mind:

  • It’s a full install – you don’t have to download 11.2.0.1 first, you can start right with 11.2.0.2
  • Installation will be done by default into a separate %ORACLE_HOME% .- and this is our strong recommendation.
  • If you’d like to install into your existing
Continue reading...

Recap on Deinstall Routines

A few weeks ago I’Ve posted something about the deinstall utility as OUI doesn’t offer a “deinstall software” option anymore:
How to deinstall “old” SW after 11.2.0.2 has been applied?

And I’ve got some feedback (which is a good sign as it means that some of the content might be useful and will be read – and from the follow-up you see that we’ll read your comments and emails as well 🙂 ).

Anyway, the feedback was either CRS deinstall does not work the right way or deinstall cleans up too many things. So Roy did follow …

Continue reading...