Tuning Oracle databases or Oracle Performance Management (OPM) is what database administrators (DBAs) do to help the database run optimally. With the increase in e-commerce and deployment of databases and applications on the Internet, the task of keeping databases running is becoming increasingly important. This entry-level study teaches the essentials of keeping databases running at top performance. The guide covers releases 7.3 through 8i for NT, Linux and Unix platforms.

Oracle 8i is a database for the Windows NT/2000 platform. This book begins with looking at the fundamentals of the operating system and installation of Oracle 8i products on Windows NT/2000 and then goes on to cover intermediate and advanced topics such as: architecture: migration; clustering; parallel server; performance monitoring and troubleshooting; and using Oracle Enterprise Manager.

This text introduces various methods for Oracle database backup and recovery. It includes backup and recovery exercises that can be practised at home which allows the reader to test their skills. Hands-on troubleshooting exercises show common issues that can occur during the backup and recovery process and chapter review questions and answers test reader's knowledge and comprehension.

This text covers how to use JDBC programs with the Oracle8i and 9i databases, including details on the Oracle extensions to JDBC. It demonstrates accessing a database from JDBC using examples and introduces JDeveloper, which provides a productive environment for developing Java programs.

This authorized guide from Oracle Press explains how to administer Oracle9i on all of the major UNIX platforms, including Solaris, HP-UNIX and IBM-UNIX, and Linux. Inside, you'll find proven techniques and UNIX scripts that can be used to perform dozens of UNIX-related tasks.

Get complete coverage of STATSPACK--Oracle's powerful tuning tool--inside this official guide. Including ready-to-use STATSPACK scripts you'll be able to collect and analyze system data and soon have your Oracle database running at peak performance.

This volume focuses on developing applications with the Oracle9i application server, and which contains a CD-rom containing ready-to-run SQL scripts, Java application scripts and the Oracle9iAS MVC framework for J2EE.

Generate detailed reports that will give your company the competitive edge

Put essential information in the hands of end-users across your organization using Oracle Business Intelligence Discoverer 10"g" and the comprehensive information contained in this Oracle Press guide. You'll learn, step-by-step, how to query databases and warehouses, format the results, and distribute dynamic, Web-enabled reports. All features are covered in full detail, including OracleBI Discoverer Desktop, Workbook Wizard, Plus, Viewer, Discoverer Administrator, Portlet Provider, OLAP, and Enterprise Manager....