|
Free ebooks
 Free database ebooks Oracle Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle EnterPrise Database
|
 Oracle Database 11g is an evolutionary step from the previous release of Oracle 10g; Oracle 10g was, in turn, a truly revolutionary step from Oracle9i in terms of its “set it and forget it” features. Oracle 11g continues the tradition of feature enhancement by making memory management more automated, adding several new advisors, and significantly improving availability and failover capabilities. Part I of this ebook covers the basics of the Oracle architecture and lays the foundation for deploying a successful Oracle infrastructure by giving practical advice for a new installation or upgrading from a previous release of Oracle. To provide a good foundation for the Oracle 11g software, we cover server hardware and operating system configuration issues in the relevant sections. In Part II of this book, we will cover several areas relevant to the day-to-day maintenance and operation of an Oracle 11g database. The first chapter in Part II discusses the requirements that a DBA needs to gather long before you mount the install CD on your server. Successive chapters deal with ways the DBA can manage disk space, CPU usage, and adjust Oracle parameters to optimize the server’s resources, using a variety of tools at the DBA’s disposal for monitoring database performance. Transaction management is greatly simplified by Automated Undo Management (AUM), an Oracle Database feature introduced in Oracle9i and enhanced in Oracle 10g and Oracle 11g. Part III of this book focuses on the high availability aspects of Oracle 11g. This includes using Oracle’s Recovery Manager (RMAN) to perform and automate database backups and recovery, along with other features, such as Oracle Data Guard, to provide a reliable and easy way to recover from a database failure. Last, but certainly not least, we will show how Oracle 11g Real Application Clusters (RAC) can at the same time provide extreme scalability and transparent failover capabilities to a database environment. Even if you don’t use Oracle 11g’s RAC features, the standby features make Oracle 11g almost as available as a clustered solution; being able to easily switch between standby and primary databases as well as query a physical standby database provides a robust high-availability solution until you are ready to implement a RAC database. In Part IV of this book, we will cover a variety of issues revolving around Networked Oracle. Not only will we cover how Oracle Net can be configured in an N-tier environment, but also how we manage large and distributed databases that may reside in neighboring cities or around the world. In this chapter, we cover the basics of Oracle Database 11g, highlighting many of the features we will cover in the rest of the book as well as the basics of installing Oracle 11g using Oracle Universal Installer (OUI) and the Database Configuration Assistant (DBCA). We will take a tour of the elements that compose an instance of Oracle 11g, ranging from memory structures to disk structures, initialization parameters, tables, indexes, and PL/SQL. Each of these elements plays a large role in making Oracle 11g a highly scalable, available, and secure environment. Download free ebooks of oracle:Oracle Database 11g DBA Handbook: Administer a Scalable, Secure Oracle EnterPrise Database
|
