Tag: Oracle

What Exactly is Swappiness?

This is an issue that keeps rearing its ugly head over and over again, and since it greatly affects performance, it is most important that DBAs of any DMBS running on Linux come to grips with it. So I decided to do some research and try different settings on my notebook. Here are my findings.

Read More >

Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard & Snow Leopard

I was very surprised that Oracle released Oracle Database for Mac OSX, especially, version 10g now that 11g has been out for almost 2 years. There is no quick install guide for OS X but only a standard Oracle® Database Installation Guide 10g Release 2 (10.2) for Apple Mac OS X (Intel). It’s fine but if you want to install Oracle on your MacBook and not for production use then you might take some shortcuts and follow a quick instructions so I gathered my notes while installing just released Oracle Database 10.2.0.4 on my MacBook, here they are.

Read More >

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

Welcome to the 142nd edition of Log Buffer, the weekly review of database blogs.

Read More >

OraQuiz #1: Quote a job name in lowercase to drop it with DBMS_SCHEDULER

I have enjoyed reading Sheeri’s nice MySQL “Pop Quiz” series, and, knowing that practise greatly increases the retention time of information in our minds, I thought I would start a series of quizzes of my own, only to do with Oracle. Here’s a an easy one to begin with. How do you drop a job with job_name in lower case using DBMS_SCHEDULER on Oracle 10g?

Read More >

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 >

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 >
Page 91 of 143« First Page...10...8990919293...100...Last Page »