Tuning tips Web-based Oracle Connectivity

Oracle manages incoming web requests to Oracle databases in a variety of ways, depending on the specific configuration. Some of the most common methods include:

1. Oracle HTTP Server: Oracle HTTP Server (OHS) is a web server that can be used to route incoming web requests to Oracle databases. OHS can be configured to use a variety of different protocols, including HTTP, HTTPS, and WebDAV.
2. Oracle WebLogic Server: Oracle WebLogic Server is an application server that can be used to host Oracle database applications. WebLogic Server can be configured to receive incoming web requests directly, or it can be configured to use OHS as a reverse proxy.
3. Oracle Cloud Infrastructure (OCI) API Gateway: OCI API Gateway is a managed service that can be used to create and manage APIs. OCI API Gateway can be used to route incoming web requests to Oracle databases that are hosted in OCI.

Once an incoming web request has been routed to an Oracle database, the database will process the request and return a response. The response can be returned directly to the client, or it can be routed back through the web server or application server.

Here is a simplified example of how Oracle might manage incoming web requests to a database:

1. A user sends a web request to an Oracle web server.
2. The web server routes the request to OHS.
3. OHS forwards the request to an Oracle database.
4. The database processes the request and returns a response to OHS.
5. OHS forwards the response back to the web server.
6. The web server returns the response to the user.

Oracle also provides a number of features to help manage and secure incoming web requests to Oracle databases, including:

1. Authentication and authorization: Oracle provides a variety of authentication and authorization mechanisms to control who can access Oracle databases and what they can do once they are authenticated.
2. Auditing: Oracle provides auditing capabilities to track who is accessing Oracle databases and what they are doing.
3. Security policies: Oracle provides a number of security policies that can be used to protect Oracle databases from unauthorized access and attack.

Oracle customers can choose the method that best meets their specific needs and requirements for managing incoming web requests to Oracle databases.

The Oracle Web architecture has steadily evolved over the past few years. Like all very large database systems, most Web interfaces to Oracle databases use a replicated environment. Critical tables are replicated with Oracle snapshots into separate database schemas, often on different database servers. When a request is received, a customized Web listener directs the traffic to the least frequently used replicated database.
Remember to separate the performance issues associated with the WebServer from the Oracle database performance issues. The WebServer is an entirely separate piece of software with its own set of components, and is tuned independently from the Oracle database.

We can think of the models for Web-based applications and client-server applications as being very similar. A Web-based Oracle application can be viewed as a three-tiered client-server application.
The following diagram describes these similarities.