Select is an exclusive member benefit of the IOUG. Click here to find out how to join.

Click here to see other SELECT Journal issues

SELECT Journal
October 2000, Volume 8, No. 1

Features

• Performance Problems Caused by the Nonreuse of SQL Statements
  By Jeff Maresh
  To maintain acceptable performance on Oracle databases, periodic tuning is necessary. Here, we will focus on the diagnosis and correction of performance problems related to the non-reuse of SQL statements.
• Rebuilding Large Indexes "In-Place"
  By Wayne Linton, I.S.P.
  ORACLE7 V7.2 and later versions have introduced time-saving functionality that can lighten the maintenance burden of the DBA. This article will describe how you can lighten your work load by utilizing the REBUILD, RESIZE and AUTOEXTEND features of the ORACLE database to automate the task of rebuilding large indexes.
• Oracle Internet Commerce Server
  By Bradley D. Brown
  Chances are, you have or are about to determine a way to make yours an e-business. Learn about the many benefits associated with using the Oracle Internet Commerce Serve to do just that.
• Managing Database Links in a Distributed Environment
  By Paul Makkar
  When migrating to a multiple-instance environment and start linking databases, you can introduce chaos and complexity - unless you know a few key techniques for making links simple and secure. Interested in finding out more about those techniques? Then read on!
• Using Spreadsheets for Analysis and Reporting in Web-Based, Multi-Tier Applications
  By Mark Spencer
  Spreadsheets are one of the most commonly used computing technologies in business today. Given their popularity and effectiveness, it’s logical to use spreadsheets for data analysis when building Java applications. As you’ll see in this paper, they are especially effective when used to build servlets and Java Server Pages.
• Faster Performance using Oracle8 Stored Procedures
  By Don Burleson
  As objects such as stored procedures and triggers become more popular, more application code will move away from external programs and into the database engine. Oracle has been encouraging this approach in anticipation of the object-oriented features of Oracle version 8. The Oracle DBA must be conscious of the increasing memory demands of stored procedures, and carefully plan for the days when all of the database access code resides within the database.

Regular Columns

• President's Letter
• From The Editor
• Select Star
• User Group Calendar
• User Groups
• Editorial Information

Download Acrobat Reader
Copyright 2006 by the International Oracle Users Group

Contact Us | Download Acrobat Reader | Privacy Statement | Refund Policy
Copyright and Disclaimer | Discussion Forum Access | Secured Area Access Agreement

IOUG Headquarters • 401 N. Michigan Ave., 22nd Floor • Chicago, IL 60611 • (312) 245-1579 • ioug@ioug.org
Copyright 2000 - 2006 by the Independent Oracle Users Group