Data Warehousing & Integration
	Linux, RAC and Grid
	Manageability
	Performance & Availability
	Security
	SQL
	Content Management

Data Warehousing & Integration

A Refreshing Move [01-June-2009]
by Arup Nanda
Encrypt, compress, mask, and deliver information with Oracle Data Pump.

Intelligence and Identity [01-Jan-2008]
by Mark Rittman and Joel Crisp
Integrating Oracle Business Intelligence and Oracle Identity Management.

Reporting with the Familiar [21-June-2007]
by Mark Rittman
Create reports with familiar desktop tools and Oracle enterprise datasources.

Building a Hybrid Data Warehouse Model [9-Apr-2007]
by James Madison
As suggested by this reference implementation, in some cases blending the relational and dimensional models may be the right approach to data warehouse design.

Managing Data Quality [26-Oct-2006]
by Ron Hardman
Oracle Warehouse Builder 10g handles the truth.

Back to Top

Linux, RAC and Grid

Open Source Contributions [01-June-2009]
by Rich Schwerin
Oracle investments in Linux yield substantial returns.

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites [March 2009]
by Porus Havewala
Need to guarantee high scalability for Enterprise Manager Grid Control? This architecture, described by Oracle ACE Director Porus Homi Havewala based on real-world experiences, may be for you.

Guide to Advanced Linux Command Mastery, Part 3: Resource Management [January 2009]
by Arup Nanda
In this installment, learn advanced Linux commands for monitoring physical components.

Build Your Own Oracle Extended RAC Cluster on Oracle VM and Oracle Enterprise Linux [28-Oct-2008]
by Jakub Wartak
Learn how to create a cheap but fully functional Oracle Extended RAC implementation in a virtualized environment. For educational purposes only, not validated or supported by Oracle!

Guide to Linux Find Command Mastery [29-July-2008]
by Sheryl Calish
A quick introduction to the most powerful—as well as confusing—aspects of this ubiquitous command.

More Support for the Kernel [23-June-2008]
by Rich Schwerin
Oracle developers continue their contributions to the Linux kernel.

Build Your Own Oracle RAC 11g Cluster on Linux and iSCSI [03-Dec-2007]
by Jeff Hunter
Learn how to set up and configure an Oracle RAC 11g Release 1 development cluster on Oracle Enterprise Linux for less than US$2,700 (an update to Jeff Hunter's popular guide).

Build Your Own Oracle RAC Cluster on Oracle Enterprise Linux and iSCSI [29-June-2007]
by Jeff Hunter
Oracle ACE Jeff Hunter has updated his extremely popular guide for installation on Oracle Enteprise Linux (for development and testing only, production deployments not supported).

Guide to Advanced Linux Command Mastery, Part 2 [21-Feb-2007]
by Arup Nanda
Oracle ACE Arup Nanda offers a tour of slightly more advanced Linux commands useful for Oracle users, whether developers or DBAs.

Committed to Code [21-June-2006]
by Rich Schwerin
Oracle's kernel contributions benefit anyone using Linux.

Adding New Nodes to Your Oracle RAC 10g Cluster on Linux [2-Oct-2006]
by Murali Vallath
Follow this step-by-step guide to add a new node to an existing Oracle RAC 10g Release 2 cluster.

Guide to Advanced Linux Command Mastery, Part 1 [11-Aug-2006]
by Arup Nanda
In this four-part series from Oracle ACE Arup Nanda, you will learn some not-so-well-known tricks for various routine Linux commands, as well as use cases for more sophisticated commands.

Learning Oracle RAC with the NetApp Simulator [30-Mar-2006]
by Sachin Garg
With the help of Net Appliance's Data ONTAP Simulator, DBAs and Linux enthusiasts can evaluate Oracle Real Application Clusters (RAC) on Linux with no up-front hardware investment.

Back to Top

Manageability

Oracle Enterprise Manager Grid Control Architecture for Very Large Sites [March 2009]
by Porus Havewala
Need to guarantee high scalability for Enterprise Manager Grid Control? This architecture, described by Oracle ACE Director Porus Homi Havewala based on real-world experiences, may be for you.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

More Ways to Flash Back [01-Sep-2008]
by Sushma Jagannath
Query history and recover from corruptions with Oracle Flashback technology.

Document, Monitor, and Manage [01-Sep-2008]
by Sue Harper
Take advantage of new features in Oracle SQL Developer 1.5.

Using Database Advisors [23-June-2008]
by Sushma Jagannath
Get advice on key management challenges and improve performance in Oracle Database 11g.

Managing History [23-June-2008]
by Jonathan Gennick
Oracle Total Recall enables users to find, track, and use past and present information

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Visualize Your Oracle Database Data with JChart [02-Nov-2007]
by Dustin Marx and Michael G. Martin
Use the open-source JFreeChart tool to easily plot your Oracle database data in a wide selection of high-quality chart types.

More Partitioning Choices [17-Aug-2007]
by Arup Nanda
Learn when and how to use new partitioning schemes in Oracle Database 11g.

Embedded Java Persistence [17-Mar-2007]
by Jonathan Gennick
Oracle Berkeley DB Java Edition provides painless persistence to Java objects.

Recover in a Flash [17-Jan-2007]
by Arup Nanda
Reduce database recovery time, using the Oracle flash recovery area.

When Microseconds Count [26-Oct-2006]
by Jonathan Gennick
The Oracle TimesTen in-memory database is always ready.

Restore to the Point [26-Oct-2006]
by Arup Nanda
Use named points in time to roll your database back by using flashback query.

Become a Master [28-Aug-2006]
by Aradhana Puri
Step up from Oracle Certified Professional to Oracle Certified Master.

Secure Search Returns Best Results [28-Aug-2006]
by Ron Hardman
Oracle Secure Enterprise Search provides the right intranet search.

Managing Certificates [01-Jul-2006]
by Aradhana Puri
Questions and answers on managing and using certificates and wallets.

Managing Oracle Portal [01-May-2006]
by Aradhana Puri
Questions and answers on configuring and administering Oracle Portal.

Oracle Database 10g Express Edition: Not Just for Learners [06-Mar-2006]
by Lewis Cunningham
Oracle Database XE's value is not limited to learning DBAs, students, hobbyists, or small businesses—it also holds appeal in many other situations.

Commanding ASM [01-Mar-2006]
by Arup Nanda
Access, transfer, and administer ASM files without SQL commands.

Faster Batch Processing [01-Mar-2006]
by Mark Rittman
LOG ERRORS handles errors quickly and simplifies batch loading.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

New Features for Oracle8i OCPs [01-Jan-2006]
by Aradhana Puri
Upgrade from Oracle8i OCP to Oracle Database 10g OCP in one exam.

Back to Top

Performance & Availability

On Constraints, Metadata, and Truth [01-May-2009]
by Tom Kyte
Our technologist uses constraints to improve query performance.

More New PL/SQL Features [01-May-2009]
by Sushma Jagannath
Improve performance in Oracle Database 11g with new PL/SQL features.

Guide to Oracle Data Guard Fast-Start Failover [March 2009]
by John Smiley
This document will guide you through configuring Oracle Data Guard Fast-Start Failover (FSFO) using a physical standby database. FSFO can provide substantial gains in high availability and disaster recovery preparedness for all environments, from inexpensive Cloud-based systems to global distributed data centers.

Improving Application Performance [2-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Baselines and Better Plans [2-Mar-2009]
by Arup Nanda
Use SQL plan management in Oracle Database 11g to optimize execution plans.

On Dynamic Sampling [18-Dec-2008]
by Tom Kyte
Our technologist samples dynamically, considers usage, and sets levels.

Managing Database Resources [18-Dec-2008]
by Sushma Jagannath
New features in Oracle Database 11g help you assess performance and limit I/O usage.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

New Ways to Flash Back [01-Nov-2008]
by Sushma Jagannath
Reverse transactions and track historical changes in Oracle Database 11g.

Keeping Active [01-Nov-2008]
by Arup Nanda
Use Oracle Active Data Guard to set up a physical standby database for reporting and recovery.

More Ways to Flash Back [01-Sep-2008]
by Sushma Jagannath
Query history and recover from corruptions with Oracle Flashback technology.

Using Database Advisors [23-June-2008]
by Sushma Jagannath
Get advice on key management challenges and improve performance in Oracle Database 11g.

Managing History [23-June-2008]
by Jonathan Gennick
Oracle Total Recall enables users to find, track, and use past and present information.

Compress to Impress [23-June-2008]
by Arup Nanda
Use Oracle Advanced Compression to conserve resources and improve performance.

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Oracle Database 11g Redux [11-Feb-2008]
by Tom Kyte
Our technologist continues to explore Oracle Database 11g features.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

On Tuning by Tracing [01-Jan-2008]
by Tom Kyte
Our technologist does a tune-up with SQL_TRACE.

Better Workload, Better Testing [01-Jan-2008]
by Arup Nanda
Use database replay to record and replay database activities for better testing.

Faster, Safer, and Smaller LOBs [17-Aug-2007]
by Jonathan Gennick
Oracle SecureFiles provides increased performance, better security, and reduced disk usage.

More Partitioning Choices [17-Aug-2007]
by Arup Nanda
Learn when and how to use new partitioning schemes in Oracle Database 11g.

Recover in a Flash [17-Jan-2007]
by Arup Nanda
Reduce database recovery time, using the Oracle flash recovery area.

When Microseconds Count [26-Oct-2006]
by Jonathan Gennick
The Oracle TimesTen in-memory database is always ready.

Restore to the Point [26-Oct-2006]
by Arup Nanda
Use named points in time to roll your database back by using flashback query.

Become a Master [28-Aug-2006]
by Aradhana Puri
Step up from Oracle Certified Professional to Oracle Certified Master.

Partition Decisions [01-Mar-2006]
by Arup Nanda
Understand your partition choices, and choose the best partition and key for your data.

Faster Batch Processing [01-Mar-2006]
by Mark Rittman
LOG ERRORS handles errors quickly and simplifies batch loading.

New Features for Oracle8i OCPs [01-Jan-2006]
by Aradhana Puri
Upgrade from Oracle8i OCP to Oracle Database 10g OCP in one exam.

Back to Top

Security

Faster, Safer, and Smaller LOBs [17-Aug-2007]
by Jonathan Gennick
Oracle SecureFiles provides increased performance, better security, and reduced disk usage.

Implementing Row-Level Security in Java Applications [9-July-2007]
by Lonneke Dikmans, Oracle Fusion Middleware Regional Director
Learn how to enforce row-level security across your JEE application, from database to cache.

Testing Database Security [26-Oct-2006]
by Aradhana Puri
Questions and answers on securing your Oracle database by using FGA and VPD

Secure Search Returns Best Results [28-Aug-2006]
by Ron Hardman
Oracle Secure Enterprise Search provides the right intranet search.

New Technical Article Series: Project Lockdown [22-May-2006]
by Arup Nanda
Learn a practical, phased approach to securing your database infrastructure using built-in Oracle Database security features—over one day, week, month, and quarter.

Back to Top

SQL

On Constraints, Metadata, and Truth [01-May-2009]
by Tom Kyte
Our technologist uses constraints to improve query performance.

On Wrong and Right [2-Mar-2009]
by Tom Kyte
Our technologist checks the documentation and tests the answers.

Improving Application Performance [2-Mar-2009]
by Sue Harper
Manage and tune Oracle Application Express applications with Oracle SQL Developer.

Baselines and Better Plans [2-Mar-2009]
by Arup Nanda
Use SQL plan management in Oracle Database 11g to optimize execution plans.

On Dynamic Sampling [18-Dec-2008]
by Tom Kyte
Our technologist samples dynamically, considers usage, and sets levels.

Managing Database Resources [18-Dec-2008]
by Sushma Jagannath
New features in Oracle Database 11g help you assess performance and limit I/O usage.

Encrypting Tablespaces [18-Dec-2008]
by Arup Nanda
Encrypt tablespaces transparently—without affecting performance.

On Separation and Counting [01-Nov-2008]
by Tom Kyte
Our technologist promotes more than one schema, counts partitions, and uses TKPROF.

New Ways to Flash Back [01-Nov-2008]
by Sushma Jagannath
Reverse transactions and track historical changes in Oracle Database 11g.

Programming Productively [01-Nov-2008]
by Sue Harper
Use Oracle SQL Developer to work efficiently with PL/SQL constructs.

The Trouble with Triggers [01-Sep-2008]
by Tom Kyte
Our technologist looks at trigger maintenance and implementation challenges.

Document, Monitor, and Manage [01-Sep-2008]
by Sue Harper
Take advantage of new features in Oracle SQL Developer 1.5.

On Redefinition, Nature, and Triggers [23-June-2008]
by Tom Kyte
Our technologist redefines tables, compares keys, and warns about DDL in triggers.

Managing File Versions [23-June-2008]
by Sue Harper
Edit files and use version control in Oracle SQL Developer 1.5.

The Power of Two [01-May-2008]
by David Peake
Use Oracle SQL Developer to aid Oracle Application Express development.

On Seeing Double in V$SQL [01-May-2008]
by Tom Kyte
Our technologist looks at SQL repetition in V$SQL and differences in cardinality.

Back Up and Recover [01-May-2008]
by Sushma Jagannath
New backup and recovery features in Oracle Database 11g save time and data.

Making Database Connections [01-May-2008]
by Sue Harper
Connect to Oracle and third-party databases from Oracle SQL Developer.

Oracle Database 11g Redux [11-Feb-2008]
by Tom Kyte
Our technologist continues to explore Oracle Database 11g features.

Building Queries Visually [11-Feb-2008]
by Sue Harper
Use point-and-click, drag-and-drop, and query builder in Oracle SQL Developer.

Performing Through Changes [11-Feb-2008]
by Arup Nanda
Measure the impact of changes on SQL workload with SQL performance analyzer.

On Tuning by Tracing [01-Jan-2008]
by Tom Kyte
Our technologist does a tune-up with SQL_TRACE.

More on Oracle Database 11g [18-Oct-2007]
by Tom Kyte
Our technologist takes another look at Oracle Database 11g.

Working with PL/SQL [18-Oct-2007]
by Sue Harper
Edit, compile, run, and debug PL/SQL code easily with Oracle SQL Developer.

Guide to Oracle Berkeley DB for SQL Developers [24-Sept-2007]
by Margo Seltzer
Get an introduction to using common SQL functions in Oracle Berkeley DB, from one of its inventors.

On Oracle Database 11g [17-Aug-2007]
by Tom Kyte
Our technologist takes a look at the server results and PL/SQL function caches.

Moving to an Oracle Database [17-Aug-2007]
by Sue Harper
Use Oracle Migration Workbench to migrate third-party schema objects to an Oracle database.

On Ignoring, Locking, and Parsing [21-June-2007]
by Tom Kyte
Our technologist looks out for WHEN OTHERS, locks, cascades, and parses.

Extending Oracle SQL Developer [21-June-2007]
by Sue Harper
Build extensions for Oracle SQL Developer with SQL and XML.

On Loading and Extents [11-May-2007]
by Sue Harper
Build chart, drill-down, and master/detail reports with Oracle SQL Developer.

Now Reporting [11-May-2007]
by Tom Kyte
Our technologist follows the direct path and optimizes extent usage.

On Cursors, SQL, and Analytics [11-Mar-2007]
by Tom Kyte
Our technologist referees between cursors, SQL statements, analytics, and aggregates.

On Top-n and Pagination Queries [17-Jan-2007]
by Tom Kyte
Our technologist gets more results using ROW_NUMBER, RANK, and DENSE_RANK.

Testing Database Security [26-Oct-2006]
by Aradhana Puri
Questions and answers on securing your Oracle database by using FGA and VPD

On Rescue Analytics and Popularity [26-Oct-2006]
by Tom Kyte
Our technologist explains the saving power of analytics and shares popularity.

On ROWNUM and Limiting Results [28-Aug-2006]
by Tom Kyte
Our technologist explains how ROWNUM works and how to make it work for you.

On Speeding, Dating, and Spelling [01-Jul-2006]
by Tom Kyte
Our technologist finds the OS, makes things appear faster, dates clients, and spells out numbers.

Build Custom Aggregate Functions [01-Jul-2006]
by Jonathan Gennick
Summarize data in new ways by writing your own aggregate functions.

Oracle SQL Developer Soars [01-May-2006]
by Jonathan Gennick
Bring the power of a GUI-based workbench to SQL and PL/SQL.

On Joins and Query Plans [01-May-2006]
by Tom Kyte
Our technologist optimizes joins and explains changing plans.

Querying, Constructing, and Transforming XML with Oracle XQuery [23-Feb-2006]
by Yuli Vasiliev
Learn how to leverage the power of the full-featured native XQuery engine integrated with Oracle Database 10g Release 2.

On Deduping and Ordering [01-Jan-2006]
by Tom Kyte
Our technologist deletes duplicates, gives trigger orders, and explains how SELECT locks.

SQL Tools Make Fast Work [01-Jan-2006]
by Jonathan Gennick
Different SQL tools run code, return results, and offer helpful differences.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

On Sharing, Splitting, and Deleting [01-Jan-2006]
by Tom Kyte
Our technologist shares cursors, splits large tables, and deletes securely.

Back to Top

Content Management

Extending Oracle SQL Developer [21-June-2007]
by Sue Harper
Build extensions for Oracle SQL Developer with SQL and XML.

Archiving Data Using XML [01-Jul-2006]
by Arup Nanda
Build a powerful, flexible data archive.

Querying, Constructing, and Transforming XML with Oracle XQuery [23-Feb-2006]
by Yuli Vasiliev
Learn how to leverage the power of the full-featured native XQuery engine integrated with Oracle Database 10g Release 2.

Auditing in XML [01-Jan-2006]
by Arup Nanda
Create database audit trails in XML.

Back to Top