This article is a crash course in Linux file commands for those who are either new to the operating system or simply in need of a refresher. It includes a brief overview of the more useful commands as well as guidance regarding their most powerful applications. Combined with a little experimentation the information included here should lead to an...

This article introduces the types of query rewrites the optimizer can perform. It then discusses tools to help determine the best set of materialized views to create for enabling the optimizer to rewrite many queries. Materialized views created using these tools are also fast-refreshable when the underlying data on which the materialized view is based...

This article examines utilities such as grep cut paste join sed and awk but it doesn t just reiterate man pages and run through why each utility exists. Instead we ll start by looking at each utility and its options apply it to the colon-delimited file format common in Linux files and look at how and why each tool is useful for pulling data...

New tools help you better understand the performance of your applications....

Here are the 20 most popular technical articles and columns to appear on OTN last year. For the most popular J2EE and XML articles specifically see the Java Developer and XML Centers. Popular topics include PL SQL programming best practices tips for using Oracle with PHP XML parsing and anythi...

Learn how to use table compression to save space and improve query performance.In this article I show you how table compression works as well as how to configure table compression when building and managing databases. I also discuss performance considerations based on some sample test results to help you understand how much benefit you should expect...

Over the new 20 weeks I will help you through the ins and outs of this powerful new release by presenting what I consider to be the top 20 new Oracle Database 10g features for database administration tasks. This list ranges from the rudimentary such as setting a default tablespace for creating users to the advanced such as the new Automatic Storage...

This Article explores advanced FGA concepts such as application user models and the reconstruction of data viewed by the user....

This article explodes a variety of the most pernicious PL SQL myths shows you how to systematically remove them and offers advice about how to avoid writing today what will be mythological code tomorrow....

Learn how to evaluate JSP expressions dynamically use the Expression Language EL in XML configuration files and optimize EL usage when presenting SQL result sets.This article presents the EL API using it in several utility classes whose static methods are called from JSP pages using EL functions. The article also shows several practical uses of...

Take advantage of the changes in Ant 1.6 internals to write a task or even a library of tasks. This article will show you that Ant 1.6 has also changed internally and how you can take advantage of those changes when you write a task or even a library of tasks....

This Article demonstrate the use of J2EE Connector Architecture to access a common transaction-processing platform from a J2EE platform application....

Learn how to use Oracle HTML DB s built-in session state management reporting engine and authorization features to build highly flexible yet secure reports....

Simplify and enhance Struts JSP development with Tiles....

Learn how to easily migrate Access data to the Oracle Database on Linux using open-source tools....