Tag: Oracle

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

Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.

Read More >

VMware Fusion on MAC — Shared Storage for Oracle RAC

This is not a complete guide on the Oracle RAC install with VMware Fusion but just the hints on setting up shared storage for Oracle RAC using Mac as host for VMWare Fusion virtual machines (VM’s). The reader is assumed to understand how to setup Oracle RAC and has general understanding of VMware itself. There are plenty of guides on the Internet on how to setup Oracle RAC including VMware but they usually refer to VMware Server on Linux or Windows. Please note that I’m writing it largely by memory so if you hit any issue — please leave a comment.

Read More >

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 >
Page 92 of 144« First Page...10...9091929394...100...Last Page »