Oracle Database 11g DBA Handbook
Search in google:
The Essential Resource for Oracle DBAs—Fully Updated and ExpandedManage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.Plan and deploy permanent, temporary, and bigfile tablespacesOptimize disk allocation, CPU usage, I/O throughput, and SQL queriesDevelop powerful database management applicationsGuard against human errors using Oracle Flashback and Oracle Automatic Undo ManagementDiagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning SetsImplement robust security using authentication, authorization, fine-grained auditing, and fine-grained access controlMaintain high availability using Oracle Real Application Clusters and Oracle Active Data GuardRespond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair AdvisorBack up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and ImportWork with networked databases, data warehouses, and VLDBs Put the latest Oracle Database 11g tools to work—Oracle Total Recall, Oracle Flashback Data Archive, and more
Part I: Database ArchitectureChapter 1. Getting Started with the Oracle Architecture Chapter 2. Upgrading to Oracle Database 11gChapter 3. Planning and Managing Tablespaces Chapter 4. Physical Database Layouts and Storage ManagementPart II: Database ManagementChapter 5. Developing and Implementing Applications Chapter 6. Monitoring Space Usage Chapter 7. Managing Transactions with Undo Tablespaces Chapter 8. Database Tuning Chapter 9. Database Security and AuditingPart III: High AvailabilityChapter 10. Real Application Clusters Chapter 11. Backup and Recovery Options Chapter 12. Using Recovery Manager (RMAN)Chapter 13. Oracle Data Guard Chapter 14. Miscellaneous High Availability FeaturesPart IV: Networked OracleChapter 15. Oracle Net Chapter 16. Managing Large Databases Chapter 17. Managing Distributed Databases Appendix: Installation and Configuration IndexBob Bryla has more than 20 years of MIS experience as a database designer, systems analyst, and DBA. He currently handles the DBA activities on Lands' End's Oracle Internet databases. Bob is the coauthor, with Kevin Loney, of the previous edition of this book.Kevin Loney is a veteran Oracle consultant, developer, and DBA. He is a regular presenter at Oracle User Group conferences and is the bestselling author of several Oracle Press titles.
![SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]](/application/data/covers/44/31/9780321444431.jpg "SQL Queries for Mere Mortals: A Hands-on Guide to Data Manipulation in SQL [For Mere Mortals Series]")
