Oracle RDBMS

  • Oracle provide a flexible RDBMS called oracle 11g using its feature you can store and manage data with all advantage of relational structure plus.
  • It supports java and xml.
  • It server offer the option of retrieving data based on optimization techniques and provide other facilities like consistency, protection of data through locking mechanism and control of DB accessed and used.
  • Oracle server consists of oracle DB and oracle server instance.
  • Every time DB is started SGA – System Global Area is allotted and oracle background processes are stared.
  • SGA is an area of memory that used for DB information shared by DB user. Combination of oracle background process and memory buffer is called an oracle instance.

Previous
Next Post »