1. What constitute an ORACLE Instance?
SGA and ORACLE background processes constitute an ORACLE instance. (Or) Combination of memory structure and background process.
2. What is SGA?
The System Global Area (SGA) is a shared memory region allocated by ORACLE that contains data and control information for one ORACLE instance.
3. What are the components of SGA?
Database buffers, Redo Log Buffer the Shared Pool and Cursors.
4. What do Database Buffers contain?
Database buffers store the most recently used blocks of database data. It can also contain modified data that has not yet been permanently written to disk.
5. What do Redo Log Buffers contain?
Redo Log Buffer stores redo entries a log of changes made to the database.
6. What is Shared Pool?
Shared Pool is a portion of the SGA that contains shared memory constructs such as shared SQL areas.
7. What is Shared SQL Area?
A Shared SQL area is required to process every unique SQL statement submitted to a database and contains information such as the parse tree and execution plan for the corresponding statement.
8. What is Cursor?
A Cursor is a handle (a name or pointer) for the memory associated with a specific statement.
9. What is PGA?
Program Global Area (PGA) is a memory buffer that contains data and control information for a server process.
10. What is User Process?
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.
11. What is Server Process?
Server Process handles 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.
12. What are the two types of Server Configurations?
Dedicated Server Configuration and Multi-threaded Server Configuration.
13. What is Dedicated Server Configuration?
In a Dedicated Server Configuration a Server Process handles requests for a Single User Process.
14. What is a Multi-threaded Server Configuration?
In a Multi-threaded Server Configuration many user processes share a group of server process.
15. What is a Parallel Server option in ORACLE?
A configuration for loosely coupled systems where multiple instances share a single physical database is called Parallel Server.
Also Check the below links:
0 comments:
Post a Comment