Oracle DBA 101

Marlene Theriault has been an Oracle DBA for over 17 ears and has worked with Oracle products since version 2.0 of the Oracle RDBMS. She has been published in magazines and conference proceedings throughout the world. Ms. Theriault received the "Best User Presentation" award at EOUG 1999, "Outstanding Speaker" at EDO'98, and the "Distinguished Speaker" award for presentations at both ECO'95 and ECO'96. She coauthored Oracle Security with William Heney (O'Reilly and Associates, 1998); The Oracle8i DBA Handbook with Kevin Loney (Oracle Press, 2000); and Oracle DBA 101 with Rachel Carmichael and James Viscusi (Oracle Press, 2000). She is chair of the MAOP DBA SIG and authors an "Ask The DBA" column for the MAOP newsletter. Ms. Theriault is an avid recreational walker (Volksmarching) and has done at least one 6-mile walk in each of the 50 United States. Marlene can be reached at mtheriault@mindspring.com. Rachel Carmichael has been an Oracle DBA for over nine ears. She chairs the DBA Special Interest Group for the New ork 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. James Viscusi has been working with relational database products for over 10 years and specifically with Oracle the last six years. He currently works with Oracle Corporation in the Support Division Center of Expertise, in particular working with customers experiencing performance problems. He has presented at several conferences worldwide including Oracle Open World, IOUG-A, and UKOUG. Mr. Viscusi is also a husband and father of two children and volunteers as an Emergency Medical Technician when he can find the time.

Part I: Getting Down to Basics. About Being an Oracle DBA. Oracle Installation, Configuration, and Build. What We Do Daily. General Database Considerations. Part II: The World of Views. Mapping the Database. The User's World. Logical Data Description. Using the V$ Views. The Instance-Level Dynamic V$ Views. Part III: Oracle Tools and Performance. Oracle-Supplied Tools. Server Performance. Part IV: Database Protection. Backup and Recovery. Part V: Appendices. A: Glossoary. B: Oracle8.1.5 DBA Views. C: Oracle8.1.5 V$ Views.