Oracle 9i
Instant PL/SQL scripts
Kevin Loney, Megh Thakkar, Rachel Carmichael
Résumé
Perform Database and Application Management Tasks Efficiently
Access a handpicked collection of essential, ready-to-run scripts to help you develop PL/SQL solutions more quickly and easily than you ever imagined. Verify performance, obtain information about characteristics, simplify management of database objects and users, and more—all through the use of preassembled scripts. Plus, expert authors supplement the scripts with in-depth explanations that will help you understand the behaviors created and even extend usage through customization. Organized by function, this book provides a thorough collection of fully documented SQL and PL/SQL scripts, including a display of sample results to help you analyze and optimize your applications.
- Use ready-to-run code to develop instant Oracle solutions
- Develop and deploy custom PL/SQL applications
- Write for Oracle7 Release 7.x, Oracle8 Release 8.x, Oracle8i, and Oracle9i
- Learn to performance-tune applications and use diagnostic scripts
- Discover native dynamic SQL options available as of Oracle8i
- Understand subpartitions, reverse indexes, iots, and materialized views
- Utilize random number generators while managing data
- Optimize shared memory usage in the System Global Area
- Manage databases, users, storage, and more
- Manage Java in the database
CD-ROM contains major scripts from the book and bonus chapters with additional scripts including a full chapter on managing Java in the database
Table of Contents
- 1: Oracle9i-Specific Scripts
- 2: Scripts and Managing Performance
- 3: Transaction Management
- 4: Data Management
- 5: Object Management
- 6: Space Management
- 7: User Management
- 8: Database Management
- 9: Java Support Scripts
- 10: Oracle Supplied Packages for DBAs
- Appendix
- A PL/SQL, Dynamic PL/SQL, and Procedures
- B. Scripts for the demo database
L'auteur - Kevin Loney
Kevin Loney travaille en tant que consultant en gestion technique expérimenté chez TUSC, une société da conseil basée à Chicago spécialisée dans la fourniture de solutions Oracle. Il est développeur et DBA Oracle depuis 1987 et aussi auteur depuis 1990 pour Oracle Magazine et Oracle Press. Il a été élu en 2002 Consultant of the year par le journal Oracle Magazine. Il est très apprécié et intervient fréquemment en tant que conférencier dans des groupes d'utilisateurs Oracle locaux et internationaux.
L'auteur - Rachel Carmichael
has been an Oracle DBA for over nine years. She chairs the DBA Special Interest Group for the New York Oracle Users Group, is both Chauncey and OCP certified, and has presented at various international and national conferences, including the ECO all-day DBA seminar for the past three years. She coauthored the Oracle Press book, Oracle SQL and PL/SQL Annotated Archives, 1998, with Kevin Loney, and this Oracle Press book, Oracle DBA 101, 2000, with Marlene Theriault and James Viscusi.
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Mc Graw Hill |
| Auteur(s) | Kevin Loney, Megh Thakkar, Rachel Carmichael |
| Parution | 02/11/2001 |
| Nb. de pages | 600 |
| Format | 18,3 x 23,2 |
| Couverture | Broché |
| Poids | 863g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780072132182 |
Avantages Eyrolles.com
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
