Tag: Oracle

Sydney Oracle Meetup #2 — Performance Evening with Tanel Poder and Ric Van Dyke

I presented my session Under The Hood of Oracle Clusterware and it went quite well and even the demo worked so we didn’t get to the fun troubleshooting experience. I love when the audience is actively engaged and presentation is not “one-way” — lot’s of fun (and spare time to refill while someone else is talking). We had a nice break between two parts of the presentation and, instead of 10-15 minutes bio-break, it turned into 30 minutes of peers networking and, unfortunately, I had to interrupt it in order to continue. Note to myself, we should plan to have more free flowing discussions and also plan small meetups directly in a pub, maybe.

Read More >

Database Platform Migration — Webinar in Australia

I’m excited to announce that Paul Vallée, Pythian Founder and Executive Chairman, will be on-the-air online this week with a free webinar — Database Platform Migration: when is it strategically appropriate to migrate existing applications to an open-source platform? It’s based on our 10+ years experience supporting proprietary databases, such as Oracle and SQL Server, and open-source MySQL databases on the other hand and what we learned on the numerous migrations.

Read More >

Killing an Oracle Job Dead

If you ever thought it was easy to kill an oracle job, let me show you something that gave me a headache today. The steps are simple enough: remove/break all jobs in question, kill the jobs that are running, recompile the packages with new the version, and submit/un-break the jobs again. This time, however, things were not going as smoothly as I expected. Let’s have a look.

Read More >

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 >

New England Database Society Meeting

I am passing this along — I am not sure if most folks reading this can make it, as it is last-minute and in the Boston area, but I figured I’d let people know that the New England Database Society exists. It’s free, sponsored by Sun (and has been for years, long before Sun bought MySQL), and is hosted by my college database professor, Mitch Cherniack.

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