Tag: Oracle

Oracle clamps down on multicore licensing

I was reviewing Oracle’s Processor Core Factor Table, which lists the multiplier used to calculate the Oracle Enterprise Edition CPU license requirements, and noticed something interesting: the preferential 0.5 core multiplier that formerly applied to all Intel/AMD chips has now been restricted to…

Read More >

Adding Columns with Default Values and Not Null in Oracle 11g

Oracle 11g has a new performance enhancement when adding columns. In the pre-11g releases, adding a new not null column with a default value would have caused a massive update on the entire table, locking it for the operation and generating tons of undo and redo. I’ve seen this happening in production. Oracle 11g has improved this behaviour by storing the default value in the metadata and making the column addition instantaneous. Although this is a welcomed enhancement, there are some unexpected aspects beyond the basic operations. First, we know default values for new columns are stored in the metadata, but what happens when you change the default?

Read More >

Log Buffer #140: A Carnival of the Vanities for DBAs

This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

RAC Workload Management Whitepaper

I have been presenting about RAC Connection Management on a number of conferences and I have done a white paper that is focused on RAC Workload Management. It was available to the conference attendees and now is publicly available so read on.

Read More >

Sydney Oracle Meetup — The Very First

Gday everyone. This information would be most useful for the Oracle professionals in Sydney, Australia. I’m very excited to announce the Sydney Oracle Meetup (SOM). We will be meeting regularly starting on Tuesday, 31st of March 2009. For each event, I’m targeting to have one or two speakers — sometimes with a formal full blown presentation and other times with rather informal whiteboard style sessions. The target is to meet fortnightly if we can manage such pace.

Read More >

How To Access MySQL from Oracle With ODBC and SQL

The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won’t argue about its performance, limits, or relevance. It serves a few purposes; set it up and you’ll be able, for example, to create database links between Oracle and MySQL. This post is intended to share some tips related to the setup of the Oracle Gateway for ODBC with MySQL Connector ODBC on Linux.

Read More >

Log Buffer #139: A Carnival of the Vanities for DBAs

Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ‘sphere.

Read More >

Jserv JVM Issues with Many SSWA Users

If your configuration matches the following setup, then this blog could be helpful to you. Set up: OS: Redhat Enterprise Linux 3 or 4, JDK: Sun Java 1.3 or 1.4, Apps: 11.5.9 or 11.5.10, Users: many Oracle Self Service Web Applications Users e.g., iProc, iRec, Timecard, and HR self-service With this setup, you might have already faced issues like the Apps login page not responding, or browsers timing out in loading SSWA pages. You might have raised numerous long-running TARs with Oracle support on this and ended up uploading lot of Apache and Jserv debug logs, and you always end up recycling or bouncing the Apache service to fix the issue. Don’t worry—you are not alone here.

Read More >

Log Buffer #138: A Carnival of the Vanities for DBAs

Welcome to the 138th edition of Log Buffer, the weekly review of database blogs.

Read More >

RMAN Redundancy is not a Viable Retention Policy

I have always had a preternatural dislike for using REDUNDANCY as a retention policy for Oracle RMAN, greatly preferring RECOVERY WINDOW instead, simply because REDUNDANCY doesn’t really guarantee anything valuable to me, whereas RECOVERY WINDOW guarantees that I’ll be able to do a point-in-time recovery to anytime within the past x days. The two biggest points to take away are: Tape backup failures are still serious backup failures and should be treated as such, even if you backup to disk first; and, REDUNDANCY is not a viable retention policy. In my house, it is configuration non grata.

Read More >
Page 92 of 143« First Page...10...9091929394...100...Last Page »