What Is Oracle Server 10g Architecture?
How oracle server database construct and work to fulfill an oracle database server's client requests
1 Answer - Sort by: Date | Rating
The Oracle Server architecture can be described in three categories:
1 User-related processes
2 Logical memory structures that are collectively called an Oracle instance
3 Physical file structures that are collectively called a database
User Processes:
At the user level, two processes allow a user to interact with the instance and, ultimately, with the database: the User Process and the Server Process. Whenever a user runs an application, such as a human resources or order-taking application, Oracle starts a User Process to support the user's connection to the instance. Depending on the technical architecture of the application, the User Process exists either on the user's own PC or on the middle-tier application server. The User Process then initiates a connection to the instance. Oracle calls the process of initiating and maintaining communication between the User Process and the instance a connection. Once the connection is made, the user establishes
a session in the instance.
After establishing a session, each user then starts a Server Process on the host server itself. It is this Server Process that is responsible for performing the tasks that actually allow the user to interact with the database.
In addition to the User and Server processes that are associated with each user connection, an additional memory structure called the Program Global Area (PGA) is also created for each user. The PGA stores user-specific session information such as bind variables and session variables. Every Server Process on the server has a PGA memory area.
The Oracle Instance:
An Oracle Server instance is made up of Oracle's main memory structure, called the System Global Area (SGA), and several Oracle background processes. It is with the SGA that the Server Process communicates when the user accesses the data in the database.
The System Global Area:
The SGA is made up of three required components and three optional components.
Required Components
Shared Pool (Required) :Caches the most recently used SQL statements that have been issued by database users
Database Buffer Cache (Required) : Caches the data that has been most recently accessed by database users
Redo Log Buffer (Requires) : Stores transaction information for recovery purposes
Java Pool (Optional): Caches the most recently used Java objects and application code when Oracle's JVM option is used
Large Pool (Optional):: Caches data for large operations such as Recovery Manager (RMAN) backup and restore activities and Shared Server components
Streams Pool (Optional): Caches the data associated with queued message requests when Oracle's Advanced Queuing option is used
1 User-related processes
2 Logical memory structures that are collectively called an Oracle instance
3 Physical file structures that are collectively called a database
User Processes:
At the user level, two processes allow a user to interact with the instance and, ultimately, with the database: the User Process and the Server Process. Whenever a user runs an application, such as a human resources or order-taking application, Oracle starts a User Process to support the user's connection to the instance. Depending on the technical architecture of the application, the User Process exists either on the user's own PC or on the middle-tier application server. The User Process then initiates a connection to the instance. Oracle calls the process of initiating and maintaining communication between the User Process and the instance a connection. Once the connection is made, the user establishes
a session in the instance.
After establishing a session, each user then starts a Server Process on the host server itself. It is this Server Process that is responsible for performing the tasks that actually allow the user to interact with the database.
In addition to the User and Server processes that are associated with each user connection, an additional memory structure called the Program Global Area (PGA) is also created for each user. The PGA stores user-specific session information such as bind variables and session variables. Every Server Process on the server has a PGA memory area.
The Oracle Instance:
An Oracle Server instance is made up of Oracle's main memory structure, called the System Global Area (SGA), and several Oracle background processes. It is with the SGA that the Server Process communicates when the user accesses the data in the database.
The System Global Area:
The SGA is made up of three required components and three optional components.
Required Components
Shared Pool (Required) :Caches the most recently used SQL statements that have been issued by database users
Database Buffer Cache (Required) : Caches the data that has been most recently accessed by database users
Redo Log Buffer (Requires) : Stores transaction information for recovery purposes
Java Pool (Optional): Caches the most recently used Java objects and application code when Oracle's JVM option is used
Large Pool (Optional):: Caches data for large operations such as Recovery Manager (RMAN) backup and restore activities and Shared Server components
Streams Pool (Optional): Caches the data associated with queued message requests when Oracle's Advanced Queuing option is used
1
0
- How To Minimize The Load On Pc During Startup When Oracle 10g Is Installed In It?
- Enter A How Do You Control Number Of Datafiles One Can Have In An Oracle Database?Question Or Search…
- How Can I Connect Vb6 With Oracle 10g?
- Hi What's The Main Difference Between Oracle 10g & 11i?
- Which Types Of Backups You Can Take In Oracle?
- How We Uninstall Oracle?
- How To Increase Sga Size Dynamically In Oracle 10g?
- Pls Advice Good Oracle DBA Course Centres In Bangalore With Good Trainer And Less Fees?
- What Are The Ways Of Connecting To The Net?
- What Is Online Redo Log Files?
- What Is The Diff Between Oracle 8i,9i,10g From Developer Point Of View?
- Difference Between Looping Statements In C And Oracle?
- Which Is The Best Institute For Oracle In Chennai?
- How Can I Connect Vb With Oracle Through Properties Connectivity And Coding Both?
- Through Properties Connectivity How We Connect Vb With Oracle?
- What Is A Redo Logfile?
- Is Oracle Course Iis Necessary For To Get A Better Job?
- How Can I Connect Oracle Database From VB6 Code Using ADO DB Connection?
- Who Or What Is The Oracle At Delphi And Why Do The The Bans Hope This Oracle Can Help Them?
- How Do I Move A Database From My Pc To The Server?
- Which King Consulted The God Through The Use Of Oracle Bones?
- What Is Mean By Citect Scada Cluster?
- How To Find The Setup Of Oracle 9i?
- How Can You Upgrade Your Apps If You Don't Have The Money?
- How To Setup The Cluster?
- What Is The Future Of Oracle 10g?
- What Is The Difference Between Oracle 9i And 10g?
- What Is The Difference Between Oracle 8i And 9i And 10g?
- Hi What's The Main Difference Between Oracle 9i & 10g ?
- What Is Difference Between Oracle 8i,9i,10g?
- Hello I Am Geetha. My Question Is What Is The Main Difference Between Oracle 10g And 11i?
- Is There Any Advantage Of Using Oracle Than SQL Server?
- Which Is The Best Among Oracle,SQL Server,MySQl?
- Why Oracle Said To Be More Efficient Than SQL Server?

New Comment - Comments are editable for 5 min.