Oracle e-Books Downloads

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

Tom Kyte is of a rare breed. To begin, he's technically expert in his subject (administration of and development of applications for Oracle database management systems). What's more (and what distinguishes him from the ranks of the super-competent), he is both able and willing to share his considerable store of wisdom with Oracle users via books like Expert One on One: Oracle.

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columns--and the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom 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, then you will find that there are few information management problems that you cannot solve quickly and elegantly.

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.

Walks through the process of transforming a Windows NT or 2000 server into an Oracle 8i or 9i database server. The guide demonstrates how to install and define the Oracle database software, create a basic security schema, formalize the database backup plan, add client PCs, normalize the data, design the GUI forms, and produce reports. The CD-ROM contains code sample and scripts.

Teaches how table design techniques can be used to maximize Oracle performance. Exposes the internal mechanisms of Oracle. Provides pretested performance scripts to get immediate performance information. Offers expert advice on interpreting Oracle performance information. Shows how to quickly implement performance and tuning data collection without buying expensive tools.

|Next|