Effective Oracle By Design


Автор: Thomas Kyte
Издательство: Osborne ORACLE Press Series

Год: 2003
Страниц: 688
Язык: Английский
Формат: DjVu (Отсканированные страницы)
ISBN: 0072230657

 


Аннотация:

Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Table of contents
1: The Right Approach to Building Applications
2: Your Performance Toolkit
3: Architectural Decisions
4: Effective Administration
5: Statement Processing
6: Getting the Most Out of the Cost-Based Optimizer
7: Effective Schema Design
8: Effective SQL
9: Effective PL/SQL Programming
10: So, You Had an Accident
Appendix A: Setting Up and Some Scripts
Biographical note
Back cover copy
Streamline Application Development with Help from an Oracle Expert
Oracle guru Tom Kyte has written the definitive guide to designing and building high-performance, scalable Oracle applications. Providing detailed code examples throughout, Tom teaches proactive and efficient methods to develop and tune Oracle applications that fully exploit the database. You'll learn how to maximize the built-in functionality of the tools you're using in order to achieve the best results possible. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.
Use SQL*Plus, TKPROF, STATSPACK, JDeveloper, and other tools
Take advantage of Oracle's scalable architectural implementations
Handle administration with SPFILES, Oracle Managed Files, and Automatic Segment Space Management
Use archivelog mode, RMAN, and Data Guard for bulletproof backup and recovery
Improve statement processing by using bind variables and reducing parsing
Make full use of the Cost Based Optimizer (CBO)
Choose data structures that result in effectively designed schemas
Write efficient SQL statements and high-performance PL/SQL code
Learn invaluable techniques from an Oracle insider

 

Скачать книгу из интернета:

 

 

Вас заинтересует / Intresting for you:

Руководство по MySQL
Руководство по MySQL 1930 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
Самоучитель MySQL 5
Самоучитель MySQL 5 1304 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:25:31
Изучаем PHP и MySQL
Изучаем PHP и MySQL 877 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:25:31
PHP и MySQL. Карманный справоч...
PHP и MySQL. Карманный справоч... 1356 просмотров Алексей Вятский Tue, 21 Nov 2017, 13:26:01
Войдите чтобы комментировать

ildergun аватар
ildergun ответил в теме #7896 14 янв 2017 19:58
Особенно полезной для меня была глава об использовании утилит TKPROF, STATSPACK и JDeveloper