Software >> Services >> RDMBS >> Oracle >>  What are the oracle terms and their meanings

schema

a user account.  2 schemas availeble when an Oracle database is created i.e. SYS and SYSTEM

 

SID

oracle instance.  each instance has it's own INIT<instancename>.ORA.  Each instance have four types of files

  • parameter file
  • control files
  • data files
  • redo log files

It is the System Global Area (SGA) memory and background processes

 

Database

Is the data stored on disk

 

Tablespace

Is the basic storage allocation to a database

 

TNSNAMES.ORA

contains relationship between service and an instance