11gR2

Exadata Smart Flash Logging Explained

October 12, 2011
By

I’ve seen some posts on the blogosphere where people attempt to explain (or should I say guess) how Exadata Smart Flash Logging works and most of them are wrong. Hopefully this post will help clear up some the misconceptions out there. The following is an excerpt from the paper entitled “Exadata Smart Flash Cache...

Read more »

11.2.0.3 Patch Set For Oracle Database Server

September 23, 2011
By

Just a quick post that the 11.2.0.3 patch set for Oracle Database Server has been released for x86 and x86-64 platforms (other ports will soon follow). The patchset number is 10404530 and is available for download from My Oracle Support. Also be sure to check out the 11.2.0.3 New Features Guide.

Read more »

Reading Active SQL Monitor Reports Offline

August 28, 2011
By

Active SQL Monitor Reports require some files from the Internet to render the report in the browser. That’s no big deal if you have an Internet connection, but what if you do not? Generally if you load an Active SQL Monitor Report without an Internet connection, you will just see an empty page in...

Read more »

Creating Optimizer Trace Files

August 18, 2011
By

Many Oracle DBA’s are probably familiar with what Optimizer trace files are and likely know how to create them. When I say “Optimizer trace” more than likely you think of event 10053, right? SQL code like this probably is familiar then: In 11g, a new diagnostic events infrastructure was implemented and there are various...

Read more »

Crowdsourcing Active SQL Monitor Reports

August 9, 2011
By

As my loyal readers will know, I have been a big (maybe BIG) fan of the SQL Monitor Report since it’s introduction in 11g. It would not surprise me if I have looked at over 1000 SQL Monitor Reports in the past 4+ years — so I’m pretty familiar with these bad boys. Since...

Read more »

11.2.0.2 Patch Set For Oracle Database Server

September 10, 2010
By

Update: Mon Sep 13 16:02:36 PDT 2010 The 11.2.0.2 patch is now available for download (for real). If you downloaded it on Friday, there is no need to re-download it. It was mistakenly made public before it could be validated (test MD5 sums, etc.), but has since been validated. Enjoy! Just a quick post...

Read more »

Oracle Database 11g Release 2 for HP-UX Itanium and AIX (PPC64) Now Available

December 22, 2009
By

The HP-UX Itanium and AIX (PPC64) ports of Oracle Database 11g Release 2 can now be downloaded from OTN. Happy Holidays!!!

Read more »

Oracle Database 11g Release 2 for Solaris x86-64 Now Available

November 25, 2009
By

The Solaris x86-64 port of Oracle Database 11g Release 2 can now be downloaded from OTN. Get it while it’s hot!

Read more »

Oracle 11gR2 Database Flash Cache Patch For Oracle Enterprise Linux

November 24, 2009
By

Just a quick note that there is now a patch for the 11.2 Oracle Enterprise Linux (OEL) database ports to enable the database flash cache (not to be confused with the Exadata flash cache). Go to the My Oracle Support site and search for patch 8974084 – META BUG FOR FLASH CACHE 11.2PL...

Read more »

Top 10 Oracle 11gR2 New Features

September 9, 2009
By

In catching up on blog posts I see that Jonathan Lewis, Christian Antognini and Nuno Souto picked up on the deferred segment creation new feature in Oracle 11gR2. In keeping with the theme, I thought I’d put together the top 10 new features in Oracle Database 11g Release 2 (11.2) that I consider significant....

Read more »

Oracle Database 11g Release 2 Is Now Generally Available

September 1, 2009
By

Just a quick post to spread the news that Oracle Database 11g Release 2 is now generally available. Download it for Linux today. See the press release for the usual details. Here is an interesting tidbit of info from a PC World article: The new release is the product of some 1,500 developers and...

Read more »