(Lewis R Cunningham) I was recently thinking about Oracle and PHP. Actually I was thinking about Oracle and open source in general. Anyway, that got me to thinking about Non-Oracle open source Oracle software.

(Craig Shallahamer) At a basic level, forecasting Oracle performance is absolutely essential for every DBA to understand and perform. When performance begins to degrade, it’s the DBA who hears about it, and it’s the DBA who’s supposed to fix it. It’s the DBA who has the most intimate knowledge of th

(Lisa Vaas) Think you’re patched? Think you’ll get the thumb’s-up from the auditor when she comes knocking on your door to make sure you’re in compliance with HIPAA (Health Insurance Portability and Accountability Act), or GLBA, or Visa CISP and MasterCard PCI?

(James Koopmann) Wouldn’t it be nice if every piece of data were stored in one table? Well this is obviously never going to happen. The simple rules of normalization dictate that there will be more than one table in your database. As such, we have in our databases some tables that are not related an

(Aaron C. Newman) At its core, security is all about risk reduction. One of the most effective security practices, defense-in-depth, employs multiple layers of protection to reduce the risk of database intrusion. It’s analogous to the many defensive layers surrounding a medieval castle: drawbridge,

(Demir Barlas) Cash advance businesses are relatively new, dating from the 1990s, but a tough economic climate has allowed them to spread across the U.S. in a relatively short amount of time. Advance America, for example, has 2,600 customers in 37 states and is growing at the rate of four to five hu

Data warehousing poses its own set of challenges for security: enterprise data warehouses are often very large systems, serving many user communities with varying security needs, and while data warehouses require a flexible and powerful security infrastructure, the security capabilities must seamles

Oracle OpenWorld, PeopleSoft Connect, and Retek World conferences have merged into a single event—the biggest OpenWorld ever! Use this “underground” guide designed for developers and DBAs to navigate the show.

(Scott Stephens) The Oracle SQL*Plus product has introduced some new features that have long been missing from this utility program, and some to support the new features. Here’s a rundown of the new features in Oracle SQL*Plus.

This is a recipe to transport a self-contained tablespace without having to re-analyze tables and indexes. This of course assumes that optimizer statistics have already been collected. The example uses a schema called DEMO and a tablespace called TRANSTS.