create database rajpal

                datafile ‘/disk3/oraclate/pal/system/dbf’ size 170 m autoextend on

sysaux datafile ‘/disk3/oradatra/pal/sysaux/dbf’ size 100 m autoextend on

default temporary tablespace temp tempfile ‘/disk3/oradata/pal/temp.dbf’size 20m

default tablespace userdata datafile ‘/disk3/oradata/pal/userdata.dbf’ size 20,

undo tablespace undotbs datafile ‘/disk3/oradata/pal/undotbs.dbf’ size 20m


group 1 (‘/disk3/oradata/pal/redologi1a.log’) size 4m,

group 2 (‘/disk3/oradata/pal/redolog2a.log’) size 4m

controlfile reuse;








SQL >@cr8db

database created.

SQL> select status from v$instance;




SQL > Cl scr

SQL > ed run






conn system/manger

@ $ ORACLE_HOME/sqlplus/admin/pupbld.sql






SQL > @ run



Procedure is created.

SQL > select count (*) from tab;

SQL > select * from dba_users;



Dump destination is latest advance to oracle. It contains all transactions related information whatever we perform against the database. [alert$ORACLE_SID.log]

user related error files will be generated in user dump destination

Core dump destination contains memory related errors.






sanity check includes, whether the control file values (    SCN #]

available physically or not.                                                                   data

$ORACLE_HOME/rdbms/admin/catalog/sql                                user

$ORACLE_HOME/rdbms/admin/catalog/sql                                all

$ORACLE_HOME/rdbms/admin/catalog/sql à [system/manager]

Catalog.sql: contains all user friendly data dictionary vies [base table are not user friendly]

catproc.sql: contains tables, procedures & functions

pupbld.sql: contains default users [6],

default profiles.




Shut about:  Shut down immediately whether the Txs open or not, do not bothers & kills the Txs abruptly

Shutdown transactional: Shutsdown the database after open Txs are committed.

 Shut immediate:  if any open Tx, then it rollbacks the Tx and shutsdown.

Shutdown normal: shutsdown the database, after all the users terminated all the sessions.

Catalog.sql contains no tables, but contains, only views like user




contains pl/sql procedures   up to 8i


Up to ORACLE 8i one server may

contain multiple databases  of different

block sizes

from 9i


From ORACLE 9i one data base can maintain multiple   block sizes




Cpu work

in day not more than 60%

in ningh 100%

effective cpu utilization:

if 1 db going with backup than let the  other databases  do the reports, pl/sql procedures &