Asian Journal of Advances in Research

The objective of the research is to demonstrate the power, performance, and scalability of Oracle even in the modern context. Oracle is still one of the most popular RDBMSs being used both by the corporate world as well as the researchers and academicians, although for entirely different objects and distinct purposes. Though many other database software are available in the market, there are a few most popular features which are simple to use, yet powerful, which makes this software highly desirable. For one, the software is scalable and its performance tuning features are such that this scalability is seamless without conspicuously degrading its performance. These features are further elaborated, explained and researched in this context. A new technique is also proposed in this research which adds a further dimension to the already acclaimed 3-tier architecture wherein the Oracle DB Server fits well. Oracle 4-tier architecture is discussed where its 4-tiers – the database, client, application, and load-balancing are elaborated. A limitation of Oracle Database is also discussed in terms of the high volume and ever-increasing variety and formats of data being generated as a result of social engineering phenomena. Thus, to overcome the limitations, the time is to adapt to the Big Data Technologies.