Find knowledge base article(s) by searching for keywords in the title e.g. type linux in the search box below
Find knowledge base article(s) by browsing the subject categories of articles
Technology quick references, cheatsheets, user manuals etc.
Shop Online through ShopifyLite
Tutorials on various IT applications.
Search Title    (UL:0 |SS:f)

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

 

 

[ © 2008-2021 myfaqbase.com - A property of WPDC Consulting ]