The default time zone file is timezlrg_11.dat. Oracle Database uses one of two time zone files as the source of valid time zones. Oracle Database Globalization Support GuideĬonsider which time zones your database must support. See " About Selecting a Character Set" for details. You specify the database character set when you create the database.
" About Initialization Parameters and Initialization Parameter Files"Īll character data, including data in the data dictionary, is stored in the database character set. A server parameter file lets you store and manage your initialization parameters persistently in a server-side disk file. Become familiar with the concept and operation of a server parameter file. Create the global database name by setting both the DB_NAME and DB_DOMAIN initialization parameters.įamiliarize yourself with the initialization parameters contained in the initialization parameter file. Select the global database name, which is the name and location of the database within the network structure. Your Oracle operating system–specific documentation, including the appropriate Oracle Database installation guide. Oracle Automatic Storage Management Administrator's Guide To greatly simplify this planning task, consider using Oracle Managed Files and Automatic Storage Management to create and manage the operating system files that comprise your database storage. If you create a Fast Recovery Area, Oracle recommends that you place it on a storage device that is different from that of the data files. And you can control data density (number of rows to a data block). You can situate data files to reduce contention. For example, you can place redo log files on separate disks or use striping.
APEX SQL COMMAND EDITOR INSTALL
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. Plan the database tables and indexes and estimate the amount of space they will require.
0 kommentar(er)
