Software >> Services >> RDBMS >> 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