(Kuassi Mensah) Beyond the out-of-the-box built-in RDBMS functionality, you often need to extend the capabilities of your database by developing your own database-resident functionality, or data logic.

Function Based Indexes are a feature virtually every DBA and programmer will be using immediately — the ability to index functions and use these indexes in query. In a nutshell, this capability allows you to have case insenstive searches or sorts, search on complex equations, and extend the SQL lan

(Rich Schwerin) PHP, the open source general-purpose scripting language often used for Web development, is a popular student on campus—especially corporate campuses. According to independent research firm Netcraft, PHP is used by more than 40 percent of the Web applications market, and more than 22

(Dave Chappelle) Oracle has announced the general availability of Oracle Secure Backup, intended to deliver high-performance network tape backup for Oracle databases and file systems on Linux, UNIX, and Windows platforms.

(Dratz) The System Global Area (SGA) is powerful set of memory components that help you make Oracle very performant and scalable.

(Vincent Chan) In part one of this series, we illustrated the procedures for setting up bi-directional data replication and conflict resolution between two databases using Oracle 10g Streams. In the second half of this series, we will provide the steps to add a new source site into our existing bi-d

(Anil Baheti) Ensuring appropriate information privacy is a pressing concern for many businesses today, given privacy legislation such as the United States’ HIPAA (Health Insurance Portability and Accountability Act), Gramm-Leach-Bliley Act, Sarbanes-Oxley Act, and the EU’s Safe Harbour Law. Other

(Diwaker Johar) This tip uses multiple partitions to give different data points based on a date field.

(Dratz) If we had to rely on pure disk I/O for everything we did in Oracle, not only would our hard disks stay very hot, but we wouldn’t be able to scale or perform as smoothly as we’d like to.

(Steve Callan) Probably the number one database administration headache in pre-9i versions of Oracle concerns the “ORA-01555 snapshot too old” error. Let’s move forward to Oracle 10g and configure a database to use automatic undo management (AUM). Your initialization file (pfile or spfile) has the a