At Magnus Consulting Limited, Oracle is one of the technology that is incorporated
into our softwares, solutions and technologies.
Oracle Database commonly referred to as Oracle RDBMS or simply as is a Relational database management system. Relational database management system (RDBMS) produced
and marketed by Oracle Corporation. Oracle is a major presence in database computing.
BRIEF OVERVIEW OF ORACLE FEATURES
An Oracle database system comprises at least one instance
of the application, along with data storage. An instance comprises a set of operating-system
processes memory-structures that interact with the storage.
Typical processes include PMON (the process
monitor) and SMON (the system monitor).
Users of Oracle databases refer to the server-side memory-structure as the SGA (System Global Area). The SGA typically holds cache information such as data-buffers,
commands and user information. In addition to storage, the database consists of online redo logs (which hold transactional history).
Processes can in turn archive the online redo logs into archive logs (offline redo logs), which provide the basis (if necessary)
for data recovery and for some forms of data replication.
The Oracle RDBMS stores data logically in the form of tablespaces
and physically in the form of data files Tablespaces can contain various types of memory segments for example,
Data Segments, Index Segments etc. Segments in turn comprise one or more extents.
Extents comprise groups of contiguous data blocks. Data blocks form the basic units
of data storage. At the physical level, data-files comprise one or more data blocks,
where the block size can vary between data-files.Oracle database management tracks its
computer data storage with the help of information stored in the SYSTEM. SYSTEM tablespace contains the data dictionary
— and often (by default) indexes and clusters (A data dictionary consists of a special collection of tables
that contains information about all user-in the database).
The Oracle DBMS can store and execute stored procedures and functions within itself.
PL/SQL (Oracle Corporation's proprietary procedural extension to SQL, or the object-oriented language Java can
invoke such code
objects and/or provide the programming structures for writing them.