Description: (NOTE: All chapters conclude with Test Your Thinking. ) About the Authors. Forward. Acknowledgements. Introduction. 1. The Database Administrator's Job. The Role of the Oracle DBA. Sources for Oracle DBA Help. 2. Creating Your Database. OFA Basics. Creating and Configuring an Oracle Database. 3. Oracle Networking: Configuring Basic Net8/SQL*Net Components. Setting up Network Configuration Files. Managing the Oracle Listener. Configuring the Multi-Threaded Server. 4. Tablespaces. Tablespaces: Logical Areas of Storage. How Tablespaces Relate to the Oracle Database and How to Manipulate Them. 5. Segments and Extents. Segments. Extents. 6. Data Blocks. Units of Storage Called Data Blocks. Block-Level Storage Parameters. 7. Redo Logs. Redo Logs. Recovering Data with Redo Logs. 8. Datafiles. Datafiles. Manipulating Your Datafiles. 9. User Creation. Creating and Manipulating Users. 10. Privilege and Resource Groups. Creating and Manipulating Privileges. Creating and Manipulating Roles. Creating and Manipulating Profiles. 11. Auditing. Auditing Sessions, Auditing Database Actions, and Auditing Objects. 12. Rollback Segments. Rollback Segment Management. 13. Locking. Locking and Data Consistency and Concurrency. 14. Logical Backup and Recovery. Backup and Recovery Using the Import and Export Utilities. 15. Physical Backup and Recovery. Backup and Recovery Using Archivelog Mode. 16. Application and SQL Optimization. Lab 16.1 Using the AUTOTRACE Command and TKPROF Utility. 17. Database Tuning and Optimization. Optimizing the Use of Memory and Disk Resources. Appendix A: Answers to Self-review Questions. Appendix B: Recommended Reading List. Appendix C: Raid Synopsis. Appendix D: Environment Settings to Remember. Index.

Please Wait