Search

Top 60 Oracle Blogs

Recent comments

June 2014

My SDU goes to 11 ^h^h I meant 2097152

One of the cool new things in 12.1 is that you can set the Session Data Unit to 2MB. This might not sound like a Big Deal, but getting this to work required me to dig deeper into the TNS layer than I intended…Then I somehow got stuck on the wrong track, thankfully the team at Enkitec helped out here with pointers.

This post is rather boring if you just look at it but it’s probably one of the best examples where a few sentences in writing are vastly different from the time it took to get to the bottom of it. The solution explained here works on our 12.1.0.1.3 Exadata lab system, which is an X2-2 but should likewise be applicable for other configurations.

The Server Setup

My SDU goes to 11 ^h^h I meant 2097152

One of the cool new things in 12.1 is that you can set the Session Data Unit to 2MB. This might not sound like a Big Deal, but getting this to work required me to dig deeper into the TNS layer than I intended…Then I somehow got stuck on the wrong track, thankfully the team at Enkitec helped out here with pointers.

This post is rather boring if you just look at it but it’s probably one of the best examples where a few sentences in writing are vastly different from the time it took to get to the bottom of it. The solution explained here works on our 12.1.0.1.3 Exadata lab system, which is an X2-2 but should likewise be applicable for other configurations.

The Server Setup

Our take on the Oracle Database 12c In-Memory Option

Enkitec folks have been beta testing the Oracle Database 12c In-Memory Option over the past months and recently the Oracle guys interviewed Kerry OsborneCary Millsap and me to get our opinions. In short, this thing rocks!

We can’t talk much about the technical details before Oracle 12.1.0.2 is officially out in July, but here’s the recorded interview that got published at Oracle website as part of the In-Memory launch today:

Alternatively go to Oracle webpage:

Red Hat Enterprise Linux (RHEL) 7 Released

It feels almost like heresy to discus something that isn’t Oracle-related on the day that Oracle announced the new In-Memory Database Option, but something else was also released today. Red Hat gave birth to Red Hat Enterprise Linux (RHEL) 7.

I’m a big fan of all things Linux. I’m typing this blog post on a Fedora 20 desktop at home. I’m a rabid fan of Oracle Linux for servers at home and at work. As a result, the birth of RHEL7 is a pretty big deal for me.

Version controlled databases and data

To drive revenue and growth, companies are constantly improving existing applications or creating new ones. This ongoing application development depends upon provisioning environments for developers and QA teams. Once they are up and running in these environments, code development calls for the efficient change management and later deployment of changes.  The slower and more costly provisioning and managing the development environments becomes, the more delays and bugs there will be in the applications, and the less revenue the business will generate.

 

Problem

Code management has become straightforward with the use of source control tools such as Git, SVN, and Perforce. Provisioning development environments has been made more efficient by Chef, Puppet, and Jenkins.

EM12c Rel. 4, the Security Console

Why is the Security Console an important new feature?  I was contacted by three people just this last week on how to secure an EM12c environment.  How many of you are still logging in to the EM12c console or CLI with the SYSMAN account?

Bad DBA, BAD!!  :)

12.1.0.4 Middleware Management Features

Probably the last area for me to touch on in this series of blog posts about the 12.1.0.4 Enterprise Manager release is the middleware management enhancements. That’s by no means because middleware management is the least important areas of enhancement, but rather simply a reflection of the fact it’s the area I know least about. […]

Financial close pressures and performance

How long does your financial close take? How long would you like it to take? How much access do your internal business analysts have to the the financial data?

We’ve worked with a number of companies and taken their financial close down from weeks to a couple of days by using data virtualization and the Delphix appliance.  Using Delphix and data virtualization we’ve also thrown the constraints off of limited access to financial data allowing business analysts 24×7 access even in the days ramping up to quarter ends.

Problems we see

Enterprise Manager Cloud Control 12c Release 4 (12cR4) Articles

I’ve started to play around with Enterprise Manager Cloud Control 12R4. The clean installations on Oracle Linux 5 and Oracle Linux 6 were really easy. You can see how I did them here.

I used 11.2.0.4 as the database repository. I’ll probably have a go with a 12c database in future, which is now supported, but my main focus this time was to check out something similar to what I have at work. Forgive my caution, but I’ll not be using 12c database for my EM repository for a while yet. Cloud Control is too important to risk…

FIRST_ROWS_n Optimizer Mode – What is Wrong with this Statement?

June 8, 2014 It has been nearly two years since I last wrote a review of an Oracle Database related book, although I have recently written reviews of two Microsoft Exchange Server 2013 books and a handful of security cameras in the last two years.  My copy of the second edition of the “Troubleshooting Oracle […]