-- Only book to provide hundreds of ready-to-run SQL and PL/SQL scripts to programmers -- they will be provided on the CD-ROM
-- No other book has thousands of lines of annotated code -- providing in-depth understanding of how to use and customize each program -- an exciting new offering to the programming community
-- A natural extension of our PL/SQL Programming title with the same reliable backing of Oracle Press
"synopsis" may belong to another edition of this title.
In Oracle SQL & PL/SQL Annotated Archives, authors Loney and Carmichael have assembled a topical collection of SQL & PL/SQL scripts for Oracle7 and Oracle8. Although this book is not by any means a tutorial for the database's programming language, even skillful database administrators can learn much from the illustrated techniques.
The book begins with a chapter of Oracle8-specific scripts that include warning indicators for password expirations, scripts for determining value distributions across table and index partitions, and others. The rest of the chapters are devoted to particular topics. The first section addresses performance management and includes several scripts for collecting statistics and managing the System Global Area. These performance-related scripts are extremely valuable for any developer.
Next comes a series of scripts related to monitoring transactions, diagnostic utilities to analyze data definition, and similar scripts for managing objects and space. Then it's on to diagnostic and utility scripts for managing users and some general database scripts. The book wraps up with a lengthy appendix that serves as an excellent reference to the PL/SQL language.
Each chapter begins with summary of its scripts, and they are also included on the CD-ROM. Explanatory text is clearly identified as annotations, but the majority of the book consists of highly technical reading. While this book does not make for a very entertaining read, it provides Oracle administrators with powerful tools they can turn to in a pinch. --Stephen PlainFrom the Back Cover:
The Ultimate Collection of SQL & PL/SQL Scripts and Expert Commentary.
Add power and fine-tuning to your daily programming, administration, and management tasks with this collection of annotated SQL and PL/SQL scripts.
This unique book and CD set from best-selling author Kevin Loney and Oracle DBA Rachel Carmichael provides you with an extensive collection of scripts--each accompanied by expert commentary on how to customize and use it. You'll also discover numerous proven techniques for resolving problems such as improperly sized memory areas, random number generation, and object dependency issues. The critical topics covered include:Performance tuning Transaction management Deadlock resolution User management Data and relationship management Predicting and managing space requirements Managing Oracle8-specific features including abstract data types, partitions, expiring passwords, and more
Perform all your database and application management tasks more efficiently with the help of this valuable Oracle tool!
"About this title" may belong to another edition of this title.
Book Description Osborne/McGraw-Hill, 1998. Paperback. Book Condition: New. book. Bookseller Inventory # 0078825369
Book Description Osborne/McGraw-Hill, 1998. Paperback. Book Condition: New. Bookseller Inventory # DADAX0078825369
Book Description The McGraw-Hill Company. Book Condition: New. pp. xviii + 585 Illus. Bookseller Inventory # 58138238
Book Description Book Condition: Brand New. Book Condition: Brand New. Bookseller Inventory # 97800788253611.0