Replicated environment in Web interfaces to Oracle
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.
Web-based Applications and Client-server Applications
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 MouseOver below describes these similarities.
The next lesson discusses tips for designing Oracle Web applications.
Tuning Tips - Exercise
Before we continue, let us test your knowledge of Oracle WebServer components and architecture with a matching Exercise. Tuning Tips - Exercise