3rd
SEP

Oracle High Performance Tuning for 9i and 10g

Posted by bandr under Database

Oracle High Performance Tuning for 9i and 10g

Oracle High Performance Tuning for 9i and 10g

Book Description
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration.

A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

Read more ...

3rd

Special Edition Using Oracle 11i

Posted by bandr under Database

Special Edition Using Oracle 11i

Special Edition Using Oracle 11i

Product Description

The first part of Special Edition Using Oracle 11i introduces the Oracle ERP applications and R11i concepts. The reader is then educated on proven techniques for implementing these complex and integrated systems. Configuration and usage of each of the financial, distribution, manufacturing, HRMS, and projects applications are covered, followed by a discussion of working with Oracle Support, consulting firms, and compatible software vendors. The appendixes review the employment market, consulting opportunities, and provide the reader with an implementation checklist. All of R11i’s new features are covered in-depth and in practical terms. Not only will readers understand Oracle’s new capabilities, they will be able to apply them right away.

Read more ...

2nd
SEP

Expert Oracle9i Database Administration

Posted by bandr under Database

Expert Oracle9i Database Administration

Expert Oracle9i Database Administration

Book Description

This is the only real Oracle9i database administration book in the market! This 1,000+ page book enables a beginner or intermediate level Oracle DBA or Oracle developer/manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database, and includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features.

Read more ...

1st
SEP

Teach Yourself Oracle8 in 21 Days

Posted by bandr under Database

Teach Yourself Oracle8 in 21 Days

Teach Yourself Oracle8 in 21 Days

Teach Yourself Oracle8 in 21 Days is a tutorial that will teach the reader the basics of using and administrating an Oracle database. This book focuses on using concrete examples to explain why things should be done in a certain way. The key topics are broken out by week below:Week One Overview of the Oracle8 Architecture; Network Computing Architecture (NCA); Installing Oracle; Planning the Database; How to Administer Users, and How to Manage Processes.Week Two Administering Logs, Control Files, Datafiles, and Tablespaces; Controlling Rolback Segments; Building Tables and Views; Using Indexes and Clusters; and Security.Week Three Effective Backup Techniques; Recovering the Database; Administering Oracle Replication; Tuning and Optimizing the Database; Administering the Oracle Web Server; and Advanced Oracle Options. – This hands-on tutorial teaches the basics of Oracle8 in a short period of time

Read more ...

1st

Expert One on One Oracle

Posted by bandr under Database

Expert One on One Oracle

Expert One on One Oracle

Book Description
Tom Kyte has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter course, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

Read more ...

1st

Oracle SQL : Jumpstart with Examples

Posted by bandr under Database

Oracle SQL : Jumpstart with Examples

Oracle SQL : Jumpstart with Examples

  • Paperback: 688 pages
  • Publisher: Digital Press (September 23, 2004)
  • Language: English
Read more ...