• 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

  1. Plan the database tables and indexes and estimate the amount of space they will require

  2. Plan the layout of the underlying operating system files your database will comprise:

  3. 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

  4. Select the global database name. Create the global database name by setting both the DB_NAME and DB_DOMAIN initialization parameters

  5. Familiarize yourself with the initialization parameters contained in the initialization parameter file

  6. Select the database character set

  7. Consider which time zones your database must support

  8. 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

  9. Determine the appropriate initial sizing for the SYSAUX tablespace

  10. Plan to use a default tablespace for non-SYSTEM users to prevent inadvertently saving database objects in the SYSTEM tablespace

  11. Plan to use an undo tablespace to manage your undo data

  12. Develop a backup and recovery strategy to protect the database from failure

Prepare to create the database by research and careful planning.

Recent Posts

See All

Oracle Transportable Tablespace

Assume that you have a schema (IQS) on production server and you want to import the schema into test server. The ideal approach would be to perform entire schema export and import using data pump. Rig

Grant Select on all tables in a schema

I encountered this situation where I wanted to grant SELECT on all the tables owned by one user to another user. There are two simple ways to achieve this: Generate SQL for each table In this method,

Oracle Easy Connect Method

At times you will have a requirement to connect an remote Oracle database without a TNS entry. In such situation you will be using the Oracle easy connect method to connect Oracle database servery Eas

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback