Oracle System Architecture Interview Preparation Guide
Download PDF

Oracle System Architecture frequently Asked Questions in various System Architecture related job Interviews by interviewer. Get preparation of System Architecture job interview questions

36 System Architecture Questions and Answers:

1 :: Tell me what are the two types of Server Configurations?

Dedicated Server Configuration and Multi-threaded Server Configuration.

2 :: Explain what are the different Oracle Kernel Layers?

The Oracle call interface (OCI) The Oracle call interface is the lowest level at which client programs are intended to interact with Oracle. This interface is well documented and provides access to most of the functionality of Oracle, including advanced features such as object navigation, and sophisticated transaction and session control. Applications with advanced requirements have to use OCI directly, in order to access the features that are not available in Oracle's other development tools. The user program interface (UPI) OCI is based on the user program interface. There are some UPI facilities that are not yet available via OCI, and so some of the Oracle tools actually call this interface directly. Precompiler programs also call the user program interface, but indirectly via the SQLLIB library, which is an undocumented alternative to OCI. The Oracle program interface (OPI) The user program interface is the lowest layer of the client-side call stack, and the Oracle program interface is the highest layer of the server-side call stack. In most configurations, Net8 bridges the gap between UPI and OPI. However, in single-task executables there is no gap, and the UPI calls correspond directly to OPI calls. The compilation layer (KK) This is the top layer of the Oracle kernel proper. This layer is responsible for the parsing and optimization of SQL statements and for the compilation of PL/SQL program units. The execution layer (KX) This layer handles the binding and execution of SQL statements and PL/SQL program units. It is also responsible for the execution of recursive calls for trigger execution, and for the execution of SQL statements within PL/SQL program units. The distributed execution layer (K2) The distributed execution layer establishes the transaction branches for distributed transactions, and handles the management of the two-phase commit protocol. The network program interface (NPI) When remote objects are referenced in a SQL statement, the network program interface sends the decomposed statement components to the remote database instances and receives the data in return. The security layer (KZ) This layer is called by the compilation and execution layers to validate the required object and system privileges. The query layer (KQ) This layer provides rows to the higher layers. In particular, the query layer is responsible for caching rows from the data dictionary, for use by the security and compilation layers. The recursive program interface (RPI) The recursive program interface is used to populate the dictionary cache from the data dictionary. Row cache recursive SQL statements are executed in a separate call context, but are not parsed and optimized in the compilation layer. The access layer (KA) The access layer is responsible for access to database segments. This is the first layer of the lower half of the kernel. The data layer (KD) This layer is responsible for the management and interpretation of data within the blocks of database segments such as tables, clusters, and indexes. The transaction layer (KT) This layer is responsible for the allocation of transactions to rollback segments, interested transaction list changes within data blocks, changes to rollback segment blocks for undo generation, transaction control facilities such as savepoints, and read consistency. The transaction layer is also responsible for space management, both at the level of segment free lists and at the level of tablespace extent allocation. The cache layer (KC) The cache layer manages the database buffer cache. It uses operating system dependent facilities for data file I/O, provides concurrency control facilities for local access to the cache buffers, and provides parallel cache management (PCM) instance locking facilities for Oracle parallel server. The other main responsibility of the cache layer is the control of redo generation into the log buffer, and the writing of redo to the log files. The cache layer also caches control file information. The services layer (KS) The services layer provides low-level services that are used by all the higher layers, such as error handling, debugging, and tracing facilities, as well as parameter control and memory services. In particular, the service layer is responsible for generic concurrency control facilities such as latches, event waits, enqueue locks, and instance locks. This layer is also responsible for the management of the data structures for background and user processes and sessions, as well as state objects, inter-process messages, and system statistics. The lock management layer (KJ) This layer is responsible for the locking used for synchronization and communication between the instances of a parallel server database. The generic layer (KG) The generic layer provides management for the generic data structures that are used by the higher layers, such as linked lists. Of particular interest are the library cache and the memory allocation heaps used for the shared pool and session memory. The operating system dependencies (S) Oracle uses operating system facilities for I/O, process scheduling, memory management, and other operations. The implementation details are operating system dependent, and so these details are isolated into a separate layer.

3 :: Tell me the names of ORACLE Background Process?

Mandatory Processes DBWR -
Database Writer.LGWR -
Log WriterCKPT -
Check PointSMON -
System MonitorPMON -
Process Monitor Optional Process ARCH -
ArchiverRECO -
RecoverDnnn -
Dispatcher, andLCKn -
LockSnnn -

4 :: What is Server Process in Oracle System Architecture?

Server Process handle requests from connected user process. A server process is in charge of communicating with the user process and interacting with ORACLE carry out requests of the associated user process.

5 :: What is User Process in Oracle System Architecture?

A user process is created and maintained to execute the software code of an application program. It is a shadow process created automatically to facilitate communication between the user and the server process.

6 :: Tell me what is Dedicated Server Configuration?

In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.

7 :: Do you know what is a Parallel Server option in ORACLE?

A configuration for loosely coupled systems where multiple instance share a single physical database is called Parallel Server.

8 :: Tell me what is a Multi-threaded Server Configuration?

In a Multi-threaded Server Configuration many user processes share a group of server process.

9 :: Tell us what Does DBWR do?

Database writer writes modified blocks from the database buffer cache to the data files.

10 :: Tell me what is the maximum number of Lock Processes used?

Though a single LCK process is sufficient for most Parallel Server systemsupto Ten Locks (LCK0,....LCK9) are used for inter-instance locking.