Data Warehousing & Integration
	Linux & RAC
	Manageability
	Performance & Availability
	Security
	SQL
	XML

Data Warehousing & Integration

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.

Create an Excel Report from Several Oracle Databases Using Apache Jakarta POI [26-Aug-2005]
by Casimir Saternos
Use open source technology to broadcast SQL to several Oracle databases and create an Excel workbook with a separate sheet for each database result set.

Oracle Database 10g Release 2: Top Features for DBAs - Part 2 (Data Warehousing & Integration Features) [28-July-2005]
by Arup Nanda
New features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make your data warehouse an even more powerful, and less resource-intensive, asset.

Generate External Tables from an Excel Spreadsheet Using Apache Jakarta POI [04-Mar-2005]
by Casimir Saternos
Take advantage of open source technology and external tables to load data into Oracle from an Excel spreadsheet.

Making Data Flow [01-Nov-2004]
by Sanjay Mishra
Using Oracle Streams to make data move itself.

Data Warehousing: Moving Data Faster [01-Sept-2004]
by Arup Nanda
Find the fastest way to move data from warehouse to mart.

Compressing Data for Space and Speed [01-Mar-2004]
by Sanjay Mishra
Use table compression to save space and improve query performance.

Announcing the New MODEL [02-Jan-2004]
by Jonathan Gennick
The new MODEL clause brings spreadsheet calculations to the database.

Keeping Up With the Times [12-May-2003]
by Chris Busch
Learn how to address slowly changing dimensions in Oracle9i Warehouse Builder

Back to Top

Linux & RAC

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,600 (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.

Basic Linux Shell Scripting for Oracle DBAs [2-Dec-2005]
by Casimir Saternos
Many sysadmins and DBAs find it necessary or convenient to automate basic tasks using Linux shell scripting. In this article, learn some basic bash shell scripts for installing, running, and maintaining Oracle databases.

Automating Installation of Oracle Database 10g and Red Hat Enterprise Linux [28-Sept-2005]
by Casimir Saternos
Get an introduction to the tools and processes involved in building a Linux server from the ground up via scripts and configuration files.

Convert a Single Instance Database to Oracle RAC 10g on Linux [26-July-2005]
by Vincent Chan
Learn how to convert a single instance database to Oracle Real Application Clusters (RAC) 10g on Red Hat Enterprise Linux 3, step by step.

Technical Note: Migrating to Oracle ASM using Oracle Enterprise Manager 10g Database Control [26-July-2005]
by Fairlie Rego

Guide to Linux Filesystem Mastery [05-Nov-2004]
by Sheryl Calish
What is a "filesystem", anyway? Sheryl Calish explains the concept as well as its practical application.

Grasping for Data [14-Oct-2004]
by Emmet Dulaney
Pointers for extracting valuable snippets of data from standard Linux files.

Installing Oracle Database 10g on Linux x86 [14-Sept-2004]
by John Smiley
Learn the basics of installing Oracle Database 10g on RHEL 2.1, RHEL 3, or SLES 8, from the bare metal up (for evaluation only)

Guide to Linux Archive Utility Mastery [30-July-2004]
by Sheryl Calish
Sheryl Calish continues her "Linux Mastery" series with an introduction to the effective use of the tar, cpio, and rpm facilities for archiving and restoring files.

Improve Your Scripting with the test Command [14-July-2004]
by Emmett Dulaney
Underlying every conditional statement is a test to see what is true and what is not. Knowing how this works can make the difference between writing mediocre scripts and ones you'll be proud of.

Build Your Own Oracle RAC Cluster on Linux and FireWire [18-May-2004]
by Jeffrey Hunter
Learn how to set up and configure an Oracle Real Applications Cluster on Linux and FireWire technology for less than $1,500 (for development and testing only).

Guide to Linux System Command Mastery [13-May-2004]
by Sheryl Calish
An introduction to system commands for newcomers to Linux.

Vimming with SQL*Plus [08-Apr-2004]
by David Kalosi
Are you using Vim, one of the most popular text editors among Linux sysadmins, in an Oracle environment? If so, here are some tips and tricks for getting the most out of the tool.

Guide to Linux File Command Mastery [12-Feb-2004]
by Sheryl Calish
A crash course in Linux file commands for the newly initiated.

AWK: The Linux Administrator's Wisdom Kit [16-Jan-2004]
by Emmett Dulaney
Learning Linux? This introduction to the invaluable AWK text-manipulation tool will be invaluable.

Technical Note: Upgrading to Red Hat Enterprise Linux 3 [16-Jan-2004]
by Wim Coekaerts
Numerous customers have started migrating from Red Hat Enterprise Linux 2.1 Advanced Server (RHAS2.1) to Red Hat Enterprise Linux 3 (RHEL3) or are deploying some new servers onto RHEL3 and have had several questions. I will try to explain some of the more commonly used features of RHAS2.1 and how to make use of them in RHEL3.

Using the sed Editor [19-Dec-2003]
by Emmet Dulaney
The sed editor is among the most useful assets in the Linux sysadmin's toolbox, so it pays to understand its applications thoroughly.

Automatic Storage Management on Linux [20-Oct-2003]
by Bert Scalzo
The Automatic Storage Management feature in Oracle Database 10g will hold special appeal for Linux sysadmins and DBAs managing growing storage networks

Back to Top

Manageability

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.

Automating Installation of Oracle Database 10g and Red Hat Enterprise Linux [28-Sept-2005]
by Casimir Saternos
Get an introduction to the tools and processes involved in building a Linux server from the ground up via scripts and configuration files.

Sharing Memory—Automatically [26-Aug-2005]
by Kimberly Floss
Put away your scripts and let Oracle automatically resize your memory pools.

Surveying Diagnostics [26-Aug-2005]
by Aradhana Puri
Tools in Oracle Database 10g store diagnostic information and provide answers.

My First Day with the New Release [26-Aug-2005]
by Tom Kyte
Our technologist talks about his first experience with Oracle Database 10g Release 2.

Migrating to Oracle ASM using Oracle Enterprise Manager 10g Database Control [28-July-2005]
by Fairlie Rego
Oracle Database 10g Release 2 makes it easy to migrate to Oracle Automatic Storage Management (ASM). This Technical Note explains the process.

Oracle Database 10g Release 2: Top Features for DBAs - Part 2 (Manageability Features) [1-July-2005]
by Arup Nanda
The Self-Managing Database becomes even more so with an Automatic Storage Management command-line tool, direct-attached SGA access, support for online partition redefinition, and more.

Tuning Undo Tablespace [17-June-2005]
by Kimberly Floss
Let Oracle do the math and right-size the undo tablespace for you.

Mining for Clues [17-June-2005]
by Arup Nanda
Use Oracle LogMiner to re-create transactions and undo damage.

Efficient Space Management [17-June-2005]
by Aradhana Puri
Concepts of and sample questions on space usage

Response Time Analysis Made Easy in Oracle Database 10g [18-Mar-2005]
by Robin Schumacher
With Oracle Database 10g, many previously difficult-to-attain response time metrics are now at your fingertips.

Encrypt Your Data Assets [01-Jan-2005]
by Arup Nanda
Build a flexible infrastructure to protect sensitive data.

Database Resource Manager [01-Nov-2004]
by Kimberly Floss
Using Oracle Database Resource Manager facilitates meeting SLAs.

Faster Backup, Faster Recovery [01-Nov-2004]
by Arup Nanda
Speed your backup and recovery with new features in Oracle Database 10g

Managing Distributed Trace Files with Oracle and PHP [23-Sept-2004]
by Paul Gallagher
Read this technical case study about the development of a tool that combines the power of PHP and the ease-of-use of PL/SQL for managing distributed trace files through a browser.

Tracing SQL in Oracle Database 10g [01-Sep-2004]
by Kimberly Floss
New tools help you better understand the performance of your applications.

Getting Good Advice About Access [23-June-2004]
by Kimberly Floss
New SQL Access Advisor in Oracle 10g guides you in choosing indexes and materialized views.

Schedule Away the Routine [23-June-2004]
by Jonathan Gennick
Free up DBA time by using the new job scheduler.

A Closer Look at ADDM [01-May-2004]
by Kimberly Floss
New diagnostics engine in Oracle 10g helps detect and diagnose performance problems.

Add Storage, Not Projects [01-May-2004]
by Jonathan Gennick
Automatic storage management lets DBAs do their jobs and keep their weekends.

Compressing Data for Space and Speed [01-Mar-2004]
by Sanjay Mishra
Use table compression to save space and improve query performance.

Supercharging the Pump [01-Mar-2004]
by Jonathan Gennick
Utilities in Oracle Database 10g take performance and versatility to new levels.

Oracle Database 10g: The Top 20 Features for DBAs [Jan-May 2004]
by Arup Nanda
Join Oracle Magazine's 2003 "DBA of the Year" Arup Nanda over the next few months as he presents his personal list of the top 20 Oracle Database 10g features for database administrators.

Capturing Change [01-Nov-2003]
by Sanjay Mishra
Use Change Data Capture to simplify ETL in data warehouse applications.

Storage on Automatic [06-Sep-2003]
by Lannes Morris-Murphy
The new Automatic Storage Management feature in Oracle Database 10g frees the DBA from a series of mundane tasks. Here's how it works.

Ready to Recover [01-Sep-2003]
by Joe Johnson
Oracle Recovery Manager is ready, reliable, and easy to implement.

Streamline Information Sharing [01-Feb-2003]
by Bob Thome, Brajesh Goyal
If you're using a variety of technologies to share and propagate data, events, and messages, it's time to simplify-with the help of Oracle Streams, the powerful and flexible new information-sharing technology in Oracle9i, Release 2.

Back to Top

Performance & Availability

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.

Tuning Oracle9i on Linux [01-Nov-2005]
by Aradhana Puri
Questions and answers about managing Oracle9i on Linux.

Surveying Diagnostics [26-Aug-2005]
by Aradhana Puri
Tools in Oracle Database 10g store diagnostic information and provide answers.

My First Day with the New Release [26-Aug-2005]
by Tom Kyte
Our technologist talks about his first experience with Oracle Database 10g Release 2.

Convert a Single Instance Database to Oracle RAC 10g on Linux [26-July-2005]
by Vincent Chan
Learn how to convert a single instance database to Oracle Real Application Clusters (RAC) 10g on Red Hat Enterprise Linux 3, step by step.

Oracle Database 10g Release 2: Top Features for DBAs - Part 3 (Performance Features) [15-July-2005]
by Arup Nanda
Memory-attached SGA query (Arup's favorite Release 2 feature) tops this list, but optimizer statistics management, the new "compare periods" report, and other new features are equally compelling.

Efficient Space Management [17-June-2005]
by Aradhana Puri
Concepts of and sample questions on space usage

New Ways to Flash Back [01-May-2005]
by Aradhana Puri
More Oracle Flashback concepts and sample questions

Creating Team Speed [01-May-2005]
by Sanjay Mishra
Use parallel execution to field a team for big processes.

Segments Shrink [01-May-2005]
by Kimberly Floss
Shrink segments online and in real time.

Room with a Better View [01-Mar-2005]
by Arup Nanda
Get a good, fast look at your data with materialized views.

Speed and Simplify Data Movement [01-Mar-2005]
by Kimberly Floss
Use Oracle Database 10g Data Pump for fast, flexible export and import.

Flashback for OCPs [01-Mar-2005]
by Aradhana Puri
More concepts and sample questions for OCP certification.

Understanding Optimization [01-Jan-2005]
by Kimberly Floss
Improvements in the Oracle Database 10g Optimizer make it even more valuable for tuning.

On Partitioning and Pipelining [01-Nov-2004]
by Tom Kyte
Our technologist speaks on UNION ALL, pipelines, and Saturdays.

Database Resource Manager [01-Nov-2004]
by Kimberly Floss
Using Oracle Database Resource Manager facilitates meeting SLAs.

Faster Backup, Faster Recovery [01-Nov-2004]
by Arup Nanda
Speed your backup and recovery with new features in Oracle Database 10g.

Technical Note: Getting the Most Out of SQL*Loader Direct Path Loads [23-Sept-2004]
by Richard Phillips & Jim Stenoish

Tracing SQL in Oracle Database 10g [01-Sep-2004]
by Kimberly Floss
New tools help you better understand the performance of your applications.

On Fetching, Storing, and Indexing [01-Sep-2004]
by Tom Kyte
Our technologist fetches sequentially, stores inline, and indexes globally.

Technical Note: Using Oracle Database 10g Data Pump Restart Capability [24-Aug-2004]
by Thomas B. Graves

Technical Note: Improving SQL*Loader Performance [21-July-2004]
by Carol Palmer & Jim Stenoish

Make Recovery Logical [23-June-2004]
by Darl Kuhn
Use Data Guard's logical standby database for recovery and 24/7 availability.

Getting Good Advice About Access [23-June-2004]
by Kimberly Floss
New SQL Access Advisor in Oracle 10g guides you in choosing indexes and materialized views.

Perform Without Waiting [23-June-2004]
by Arup Nanda
Diagnose performance problems, using wait events in Oracle 10g.

Understanding System Statistics [11-June-2004]
by Jonathan Lewis
Understanding the optimizer's use of system statistics can make a big difference when migrating to a new version of the Oracle Database.

Build Your Own Oracle RAC Cluster on Linux and FireWire [18-May-2004]
by Jeffrey Hunter
Learn how to set up and configure an Oracle Real Applications Cluster on Linux and FireWire technology for less than $1,500 (for development and testing only).

Flash Back to a Better Time [1-May-2004]
by Arup Nanda
Restore a table or an entire database to a point in the past, using a simple SQL statement.

Exploiting Parallel Operations with RAC [28-April-2004]
by Kevin Conlon
Learn the applied use of parallel operations with Real Application Clusters (RAC) to take advantage of scale-out cluster architecture.

The Great Migration Week Experiment [19-March-2004]
by Bill Burke
An eyewitness account of how Oracle and IOUG collaborated on the first-ever beta migration test at Oracle HQ.

Compressing Data for Space and Speed [19-Feb-2004]
by Sanjay Mishra
How to use table compression in Oracle9i Database Rel 2 to save space and improve query performance.

Diagnosing Database Performance Problems [05-Jan-2004]
by Cary Millsap
Use extended SQL trace data to see what's taking so long.

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.

Transparent Data Encryption [26-Aug-2005]
by Arup Nanda
Encrypt sensitive data transparently without writing a single line of code.

Oracle Database 10g Release 2: Top Features for DBAs - Part 2 (SQL & PL/SQL Features) [22-June-2005]
by Arup Nanda
Transparent Data Encryption and XQuery support are the two major new SQL-related features in Oracle Database 10g Release 2, but the list doesn't end there.

Database Security: Beyond the Password [25-Mar-2004]
by George Jucan
Keep your confidential data secure from (internal or external) intruders—even if passwords have been compromised—with Oracle Database built-in features.

Keeping Information Private with VPD [01-Mar-2004]
by Arup Nanda
Oracle's row-level security gives users their own virtual private databases.

Fine-Grained Auditing in Oracle Database 10g [01-Mar-2004]
by Arup Nanda
Learn about enhancements to FGA in Oracle Database 10g. Part 3 of Arup's FGA Series.

Back to Top

SQL

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.

On Transaction Isolation Levels [01-Nov-2005]
by Tom Kyte
Our technologist isolates transactions safely.

Develop and Test Regular Expressions with a Unit Testing Package [20-Jan-2006]
by Casimir Saternos
Learn basic techniques for constructing useful regular expressions in SQL, and then develop and test them using a supplied PL/SQL package.

Sharing Memory—Automatically [26-Aug-2005]
by Kimberly Floss
Put away your scripts and let Oracle automatically resize your memory pools.

Surveying Diagnostics [26-Aug-2005]
by Aradhana Puri
Tools in Oracle Database 10g store diagnostic information and provide answers.

My First Day with the New Release [26-Aug-2005]
by Tom Kyte
Our technologist talks about his first experience with Oracle Database 10g Release 2.

Going Global [26-Aug-2005]
by Ron Hardman
Globalization support in Oracle Database 10g Release 2 makes localization easier.

Transparent Data Encryption [26-Aug-2005]
by Arup Nanda
Encrypt sensitive data transparently without writing a single line of code.

Tuning Undo Tablespace [17-June-2005]
by Kimberly Floss
Let Oracle do the math and right-size the undo tablespace for you.

Nulls: Nothing to Worry About [17-June-2005]
by Lex de Haan and Jonathan Gennick
Avoid problems with three-valued logic.

Mining for Clues [17-June-2005]
by Arup Nanda
Use Oracle LogMiner to re-create transactions and undo damage.

On Searching and Synonyms [17-June-2005]
by Tom Kyte
Our technologist searches, moves, and finds synonyms.

Efficient Space Management [17-June-2005]
by Aradhana Puri
Concepts of and sample questions on space usage

New Ways to Flash Back [01-May-2005]
by Aradhana Puri
More Oracle Flashback concepts and sample questions

On Favorites and CONNECT BY [01-May-2005]
by Tom Kyte
Our technologist picks, expands, loads, and dates.

Filter Data Before You Get It [01-May-2005]
by Jonathan Gennick
Oracle Expression Filter lets you describe the data that will be important.

Bitmap Index vs. B-tree Index: Which and When? [11-Mar-2005]
by Vivek Sharma
Understanding the proper application of each index can have a big impact on performance. This Technical Article documents some surprising differences.

Find Answers Fast [01-Mar-2005]
by Jonathan Gennick and Anthony Molinaro
Analytic functions provide powerful ways to view your data.

On Rollups, Merges, and Moves [01-Mar-2005]
by Tom Kyte
Our technologist materializes, merges, and moves.

Flashback for OCPs [01-Mar-2005]
by Aradhana Puri
More concepts and sample questions for OCP certification.

More Space and More Time [01-Jan-2005]
by Jonathan Gennick
Improvements in tablespace management mean more free space.

Encrypt Your Data Assets [01-Jan-2005]
by Arup Nanda
Build a flexible infrastructure to protect sensitive data.

Understanding Optimization [01-Jan-2005]
by Kimberly Floss
Improvements in the Oracle Database 10g Optimizer make it even more valuable for tuning.

On Injecting and Comparing [01-Jan-2005]
by Tom Kyte
Our technologist speaks on safe injections, comparing tables, and materialized views.

More New Features for OCPs [01-Jan-2005]
by Aradhana Puri
Concepts and sample questions for Oracle Database 10g OCP upgrade certification.

New Features for OCPs [01-Nov-2004]
by Aradhana Puri
Concepts and sample questions for OCP upgrade certification.

On Partitioning and Pipelining [01-Nov-2004]
by Tom Kyte
Our technologist speaks on UNION ALL, pipelines, and Saturdays.

Keeping Information Private with VPD [01-Mar-2004]
by Arup Nanda
Oracle's row-level security gives users their own virtual private databases.

Optimize Your Text Retrieval [01-Sep-2004]
by Ron Hardman
Fine-tune Oracle Text applications with CTX_REPORT.

On Fetching, Storing, and Indexing [01-Sep-2004]
by Tom Kyte
Our technologist fetches sequentially, stores inline, and indexes globally.

Supercharging the Pump [01-Mar-2004]
by Jonathan Gennick
Utilities in Oracle Database 10g take performance and versatility to new levels.

Announcing the New MODEL [02-Jan-2004]
by Jonathan Gennick
The new MODEL clause brings spreadsheet calculations to the database.

Inside Oracle Database 10g: Writing Better SQL Using Regular Expressions [06-Sep-2003]
by Alice Rischert
The regular expressions feature in Oracle Database 10g is a powerful tool for manipulating textual data.

Back to Top

XML

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.

XQuery Flowers [26-Aug-2005]
by Jonathan Gennick
Use XQuery to retrieve and transform both XML and relational data.

XML to Relational: Bridging the Gap [26-Aug-2005]
by Sean Dillon
Storing XML in traditional relational storage.

Getting to XML [01-May-2005]
by Sean Dillon
Oracle XML DB Repository provides new ways into XML.

Which Storage XML [01-Mar-2005]
by Sean Dillon
When to use CLOBs or objects to store your XML.

Share Your Data as XML [01-Jan-2005]
by Sean Dillon
Make existing relational and object-based data available as XML.

Bring the Right JAX to Play [01-Mar-2004]
by Kelli Wiseth
API binds XML data to Java objects.

Back to Top