Karma – Oracle Database Monitoring

The karma project was a fun one.  I was putting some time into it way back in 2000 I think.  I should try to dig up some screenshots of it.  For the moment though it is no longer maintained. These days I do mostly work on MySQL, Postgres and RDS.  For those interested, there’s a …

APress – Cost-Based Oracle by Jonathan Lewis

The beauty of reading a book by a publisher not sanctioned by Oracle and by an author who doesn’t work for Oracle is that they can openly mention bugs. And there are oh-so-many! This book is a superb introduction to the Cost Based Optimizer, and is not afraid to discuss it’s many shortcomings. In so …

APress – Expert Oracle DB Arch by Tom Kyte

I have a confession to make. I haven’t read an Oracle book cover-to-cover in almost three years. Sure I skim through the latest titles for what I need and of course check out documentation of the latest releases. That’s what good docs provide, quick reference when you need to check syntax, or details of a …

Dummy's Guide to Linux firewalls

Security experts will probably tell you it’s not a good idea to be a dummy and also in charge of your own firewall. They’re probably right, but it’s a catchy title. In this article, I’ll quickly go over some common firewall rules for iptables under linux. First things first. If you don’t have the right …

Emergency Oracle Support

Encountering a problem with your Oracle systems? We’re available for emergency support services, and are conveniently located in Manhattan. We can arrange payment via Paypal, as a deposit for a quick start on an urgent matter. High Availability Issues RAC (9i/10g) Problems Failover to Standby Database (DataGuard Product) Tuning Web Application Performance Problems Troubleshooting Difficult …

Oracle 10g RAC Versus DataGuard For High Availability

Oracle has two very different technologies, each with it’s own strengths and weaknesses that implement high availability solutions. In choosing between the two technologies, it’s important to factor in the relevant risks, both small and large, to put the entire picture into perspective. Two Alternatives RAC or Real Application Clusters, is essentially an always-on solution. …