Oracle Database 11g The Complete Reference P2

Critical Database Conceptsnew features include “invisible” indexes, simplified table maintenance, and editioned objects. You should evaluate your previous architecture decisions in light of the new features available. In the next several chapters, you will see how to install Oracle Database 11g and how to upgrade to Oracle Database 11g from prior releases. Following those chapters, you will see an overview of application planning, followed by many chapters on the use of SQL, PL/SQL, Java, object-oriented features, and XML to get the most out of your Oracle database. Your application architecture may change over time as the business process changes. During...
Nội dung trích xuất từ tài liệu:
Oracle Database 11g The Complete Reference P210 Part I: Critical Database Concepts new features include “invisible” indexes, simplified table maintenance, and editioned objects. You should evaluate your previous architecture decisions in light of the new features available. In the next several chapters, you will see how to install Oracle Database 11g and how to upgrade to Oracle Database 11g from prior releases. Following those chapters, you will see an overview of application planning, followed by many chapters on the use of SQL, PL/SQL, Java, object-oriented features, and XML to get the most out of your Oracle database. Your application architecture may change over time as the business process changes. During those changes you should be sure to review the latest features to determine how your application can best exploit them for functionality and performance. CHAPTER 2 Installing Oracle Database 11g andCreating a Database 1112 Part I: Critical Database Concepts s Oracle’s installation software becomes easier to use with each release, it is very A tempting to open the box of CDs and start the installation right away. Although this is fine if you’re going to experiment with some new database features, a lot more planning is required to perform a successful installation without rework or even reinstallation a month from now. Although the complete details of an Oracle Database 11g installation are beyond the scope of this book, you will see the basics of an Oracle install using the Oracle Universal Installer (OUI). In any case, a thorough review of the installation guide for your specific platform is key to a successful Oracle database deployment. NOTE Although this chapter is intended for beginning database administrators, the planning process should include end users, application developers, and system administrators, so the workload and space requirements will be as accurate as possible. The following issues should be addressed or resolved before you start the installation: ■ Decide on the local database name, and which domain will contain this database. ■ For the first project to use the database, estimate the number of tables and indexes as well as their size, to plan for disk space estimates beyond what is required for the Oracle SYSTEM tablespace and the associated Oracle software and tools. ■ Plan the locations of the physical datafiles on the server’s disk to maximize performance and recoverability. In general, the more physical disks, the better. If a RAID or a shared storage area will be used for the datafiles, consider Oracle Managed Files to manage the placement of the datafiles. You can use automatic storage management (ASM) to simplify your storage management. See Chapter 51 for details on ASM. ■ Review and understand the basic initialization parameters. ■ Select the database character set, along with an alternate character set. Although it’s easy to let the character sets default on install, you may need to consider where the users of the database are located and their language requirements. Character sets can be changed after installation only if the new character set is a superset of the existing character set. ■ Decide on the best default database block size. The default block size defined by DB_ BLOCK_SIZE cannot be changed later without reinstalling the database. Note that Oracle can support multiple block sizes within a single database. ■ Plan to store non-SYSTEM user objects in non-SYSTEM tablespaces. Make sure that all non-administrative users are assigned a non-SYSTEM tablespace as their default tablespace. ■ Plan to implement Automatic Undo Management to ease administration of transaction undo information. ■ Plan a backup and recovery strategy. Decide how the database needs to be backed up, and how often. Plan to use more than one method to back up the database. Chapter 2: Installing Oracle Database 11g and Creating a Database 13 Familiarity with a couple of key Web sites is a must. Oracle Technology Network (OTN), athttp://otn.oracle.com, has a wealth of information, including white papers, free tools, sample code,and the online version of Oracle Magazine. There is no charge for using OTN, other than registeringon the site. You can download the latest version of ...