We have uploaded refreshed and new slide sets:
Upgrade and Migration to Oracle Database 11.2
Oracle Database 11.2 New Features Overview
Behaviour Changes between Oracle 8i and Oracle 11.2
Please note: This is not a 100% complete summary but it will give you a rough overview about parameter and dictionary changes from release to release plus a summary of documented behaviour changes. Sources were the release notes, the documentation, MOS notes and some others.
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...
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...
Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 184.108.40.206 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.
Example: Component Dependencies in Oracle Database 11.1
As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the …Continue reading...
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…
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:
TABLESPACE_NAME, EXTENT_MANAGEMENT from DBA_TABLESPACES;
The procedure to migrate to locally managed tablespace is:
And the whole migration procedure would look like this:
… Continue reading...
— do this for all tablespaces except SYSTEM, TEMP and SYSAUX
— necessary if there’s no “real” temp tablespace definded yet – see Note:160426.1
as you can see the blogs from blogs.oracle.com and the former SUN blogs got migrated last weekend. There was a content freeze the whole week before. And as you might already have found the design has changed a bit. But with the design change everything I did customize on the blog’s right column to download slides, access workshops dates or links to some other useful blogs has been erased completely. Even the “About” section hasn’t been migrated (which was a default template). I’d recommend that YOUR migration strategy is a bit more careful in your environments …Continue reading...
Ouch … just realized that it has been a while since I posted a new topic on the blog. But actually the past weeks I was busy doing workshops, working with customers – and finally (yes!!) participating on an Exadata training class. Sitting there for 3 days, listening the instructor, playing around with the cell simulator and all the exercises was quite a nice change from the daily business. And I believe I’ve learnt something useful 🙂
Well, daily business, this brings me back to a topic which hit my inbox today again for the 2nd time in a …Continue reading...
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 220.127.116.11 …Continue reading...
Oracle Database Patch Set 18.104.22.168 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 22.214.171.124 first, you can start right with 126.96.36.199
- You’ll get it just from support.oracle.com – no download from OTN or eDelivery as this is a patch set
- 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
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 188.8.131.52 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...