- Arun Kumar
How to plan database creation
Database creation process involves several operating system files to work together. You create database only once and later on keep on adding more data files.
Before you can simply go ahead and start creating your database in real-time, you must know the database planning tasks.
Database Planning Steps
Plan the database tables and indexes and estimate the amount of space they will require
Plan the layout of the underlying operating system files your database will comprise:
Proper distribution of files can improve database performance dramatically by distributing the I/O during file access. Example, put redo log files and data files on separate physical HDD to improve I/O and response time
Select the global database name. Create the global database name by setting both the DB_NAME and DB_DOMAIN initialization parameters
Familiarize yourself with the initialization parameters contained in the initialization parameter file
Select the database character set
Consider which time zones your database must support
Select the standard database block size. This is specified at database creation by the DB_BLOCK_SIZE initialization parameter and cannot be changed after the database is created
Determine the appropriate initial sizing for the SYSAUX tablespace
Plan to use a default tablespace for non-SYSTEM users to prevent inadvertently saving database objects in the SYSTEM tablespace
Plan to use an undo tablespace to manage your undo data
Develop a backup and recovery strategy to protect the database from failure
Prepare to create the database by research and careful planning.