Performance Tuning in Database Systems In High Availability Architecture and Reducing Query Costs Strategies in Oracle Database Management System
AbstractIn industry, the priority of services provided by the companies are 7X24 (7 days 24 hours) uninterrupted services. Hence, the main reason why database should provide continuous uninterrupted services. The attributes of database services that provide high accessibility services should be reliability, availability and maintainability; features referred to as RAM (Reliability, Availability, Maintainability) in the literature. In addition to that in this paper, mathematical computation pertaining to the location and accessibility in ITIL processes will also be examined. It is also aimed to investigate what should be done at the architectural level to ensure that the commands coming from Structured Query Language (SQL) results in high performance. When database or system administrators wrongly configures the architectures processing the queries, it may result in inadequate power systems that could have operated with high performance. This article then discusses what might be the necessary adjustments in order to use the resources of query systems more efficiently.