Plus additional information on SQL Statement Tuning and Data Warehousing [under construction]
I'm also involved with Oracle9i SQL Statement Tuning and Data Warehousing topics. Click here to jump to that section.
I met Peter Koletzke at the 1998 ORACLE Open World and told him that I was unable to
endorse the first edition because it seemed fairly negative about the product (besides, it
is now obsolete). Both objections are soundly reversed in this complete re-write of
the original book (see below). Buy this book, if you're going to use Designer!
The accompanying CD-ROM contains source code for all examples in the book, plus
multimedia files that users can incorporate into their diagrams and multimedia
tutorials in Lotus ScreenCam format that show how to perform various
ORACLE Designer activities.
Click here
to read the Gerry Jurrens' review of this book.
Here are several recommended books from Addison-Wesley
Longman Publishing Company
Here are a few recommended books on Data Modeling:
This book is related to the ORACLE® Designer Business Process Modeler's conventions:
Here are several recommended books from O'Reilly & Associates . Phone: (800) 998-9938.
Here are some resources related to Oracle9i SQL Statement Tuning.
Instructor-Led Training Courses (visit http://education.oracle.com
for further information):
Oracle 9i: Performance Tuning: This course provides a very intensive understanding of Oracle database tuning for the DBA. If you are responsible for tuning the database as well as the applications, this course is highly recommended. I always strongly suggest that students have 3 to 6 months of practical working experience as an Oracle DBA prior to taking this course in order to get the maximum benefit of this class.
Oracle 9i: Implement Partitioning: This course provides the information required by both DBAs and Application Developers to implement Partitioning. Partitioning provides many advantages to the DBA in terms of dividing very large tables in smaller, more manageable pieces. To the Application Developer, Partitioning provides a real opportunity for application performance enhancement since the optimizer is “partition aware” and can eliminate searches that it knows won’t produce rows meeting the predicate criteria. The net results are substantial performance gains.
Reference Books:
Oracle SQL High Performance Tuning: Second Edition by Guy Harrison. Prentice Hall, 2001. This text is excellent. What sets it apart from other texts that deal with Oracle tuning is that the entire book is geared toward tuning from the perspective of the developer, not the database administrator. Virtually every other text available on Oracle tuning is geared towards database tuning, with “lip service” to application tuning. In addition, this text is extremely thorough and accurate. The only downside is that this edition covers SQL tuning up through release 8i. I haven’t seen a 9i version yet, but the 8i version is still worthy of your time and money if you’re serious about application tuning.
Oracle 9i New Features by Robert G. Freeman. McGraw-Hill/Osborne, 2002. This text is primarily aimed at Oracle 8i database administrators who need to learn the new features of Oracle 9i. Many of the new features documented deal with new performance tuning capabilities, and while the intent of many of these features target database administrators, some are appropriate and can be very advantageous to the application developer.
Oracle SQL Tuning Pocket Reference by Mark Gurry. O’Reilly & Associates, 2002. This pocket-sized text is an easy read for developers with some experience tuning SQL code. It does a good job of identifying some of the more typical problems with tuning SQL code and the author’s suggested workarounds to these problems. Also nicely summarizes the more common hints as well as the 9i init.ora parameters affecting SQL tuning.
Expert One on One Oracle by
Thomas Kyte. Wrox Press Inc., June
2001. Kyte
(database software engineer) illustrates major features and useful techniques
for Oracle 7.3, 8.0x, and 8i (through to 8.1.7). Using a proof-by-example
approach, he offers instruction on implementing the software, building database
applications, and then administering them. He covers database structures and
utilities, performance tuning, extensibility, and security. He also highlights
potential problems and mistakes. The book assumes a working knowledge of SQL and
PL/SQL. (Book News, Inc. review)
A note about Tom Kyte’s forthcoming book, due in April,
2003:
Expert One-on-One Oracle Performance By Design by Thomas Kyte. (ISBN 1-86100-826-0). This book has its own web site at http://www.expert-oracle.com.
Helpful Web Sites:
Oracle Technology Network: You’re probably already using this heavily! http://otn.oracle.com
Ask Tom: An excellent resource from Oracle guru, Tom Kyte. http://asktom.oracle.com
Wrox “programmer to programmer”: An interesting and eclectic site with some terrific resources for the SQL programmer. Also happens to be Tom Kyte’s publisher. http://www.wrox.com/
DBAzine: An online community for database questions and solutions. http://www.dbazine.com/ch_oracle.htmlClick here to return to the top of the page.
[Click HERE to send me email]