- 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.
Next
« Prev Post
« Prev Post
Previous
Next Post »
Next Post »
Subscribe to:
Post Comments (Atom)
ConversionConversion EmoticonEmoticon