And you can control data density (number of rows to a data block). You can situate datafiles to reduce contention.
For example, you can place redo log files on separate disks or use striping. You can distribute I/O in several ways when you install Oracle software and create your database. Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. Plan the layout of the underlying operating system files your database will comprise. Part II, "Oracle Database Structure and Storage" Plan the database tables and indexes and estimate the amount of space they will require. The remainder of this chapter discusses creating a database manually. The Oracle Database Upgrade Guide manual contains information about upgrading an existing Oracle Database. You can upgrade your existing Oracle Database and use it with the new release of the database software. If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database. See "Manually Creating an Oracle Database". Both the script and the file can be edited to suit your needs. Oracle provides a sample database creation script and a sample initialization parameter file with the Oracle Database software files. If you have existing scripts for creating your database, consider editing those scripts to take advantage of new Oracle Database features. These actions can be performed by executing prepared scripts, many of which are supplied for you. These actions include creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages. If you do so, you must complete additional actions before you have an operational database. You can use the CREATE DATABASE SQL statement to create a database. Refer to Oracle Database 2 Day DBA for detailed information on creating a database using DBCA. You can also launch DBCA as a standalone tool at any time after Oracle Database installation to create or make a copy (clone) of a database. Use the Database Configuration Assistant (DBCA).ĭBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database. You can create an Oracle Database in three ways: Deciding How to Create an Oracle Database
0 kommentar(er)
