Log Miner Implementation Summary

"Log Miner is a powerful tool and all DBA's should know and master it."
- read more -

How manage database without spending a fortune

Very good article in Computerworld discussing how DBAs manage their systems.

New Oracle Linux Test (OLT) Kit

What is OLT?

Oracle Linux Tests are designed to verify Linux kernel functionality and stability essential for the Oracle Database. The Oracle Linux Test (OLT) kit, which is distributed as a set of rpms, provides an automated mechanism to define, execute and analyze tests. The kit contains tools such as DBT2 and DBT3 workloads against Oracle single instance or clustered databases, as well as specialized workload simulators. OLT can be used for running tests on Oracle Enterprise Linux, RHEL and SLES distributions and a variety of topologies ( storage attached network, network attached storage).
project site

Building pages with APEX using spatial data

All about using Oracle Spatial with Google Maps.

- The Official Guide to using Oracle Spatial with Google Maps
- HTML DB and MapViewer: A Perfect Match
- Integrating APEX with Oracle AS 10g
- Oracle APEX/Spatial How to's
- Integration of Google Maps, Oracle Maps, ... into APEX
- Oracle Application Server MapViewer Sample Code and Demonstrations

-(Great tutorial) Google Maps in APEX on XE with spatial data

MySQL vs MS SQL Server

Step by Step build RAC

Part 1 : Install VMWare and Linux
Part 2 : Install virtual disk and network card
Part 3 : Install Oracle Clusterware and Cluster Database

Oracle 10g RAC On Linux Using NFS
Oracle 10g RAC On Windows 2003 Using VMware Server

Oracle 10g RAC Series

Server Monitoring With munin And monit On Debian Etch

In this article Falko Timme describes how you can monitor your Debian Etch server with munin and monit. Munin produces nifty little graphics about nearly every aspect of your server (load average, memory usage, CPU usage, MySQL throughput, eth0 traffic, etc.) without much configuration, whereas monit checks the availability of services like Apache, MySQL, Postfix ...

Access migration to Application Express

The only requirement, is that you have SQL access to any Oracle database (9iR2+), because the workbench is driven using an underlying migration repository. You could use the Express Edition of Oracle for this purpose, which is totally free, if you didn't have SQL access to an existing Oracle database.
Full text

Custom APEX Authentication / Authorisation Schemes

Duncan Mein has created a nice How-to for setting up Custom Authentication (Part 1).