Masters

Permanent URI for this collection

https://repository.sdu.edu.kz/handle/123456789/1252

Browse

Browsing Masters by Subject "architecture, information, performance, DBMS, Oracle database"

Now showing 1 - 1 of 1
  • Thumbnail Image
    ItemOpen Access
    Development and research of the data processing system in the automated enterprise management system.
    (2018) Kalidolda Ye.
    The object of the study of this work is the architecture and structure of the Oracle database instance, while the subject of the study is the finding and the principle of storing the performance metrics of the database instance to obtain information about the performance of the DBMS. The main goal of the master's thesis will be to develop a method for low-level monitoring of the Oracle DBMS based on the techniques for obtaining performance metrics from the SGA (System Global Area) shared memory of an Oracle database instance and obtaining the storage structure for these metrics, with further implementation of the software product or module to the existing monitoring software. Monitoring systems allow you to track a huge number of database objects. In this work we will discuss the main monitoring objects, as well as various ways of obtaining data on these objects in the Oracle DBMS. In particular, we will consider the possibility of monitoring user sessions and obtaining metrics such as the identifiers of the processes started by the user, session identifiers, executable queries and waiting events. We will review the basic standard monitoring systems for Oracle DBMS, identify their advantages and disadvantages. The scientific novelty of the work is that, to date, there is not one implemented method for reading the performance metrics, which can dynamically determine the storage structure of the SGA shared memory and on the basis of this data, obtain metrics for the current performance of the DBMS.