Process perfection for searching inefficient SQL-requests in the Oracle
Abstract
Process perfection for searching inefficient SQL-requests in the Oracle
Incoming article date: 02.12.2017Introduction: The paper discusses methods to solve the problem of searching inactive queries for Oracle Databases in example . If there are no clear reasons for Deterioration of performance, database managers need to analyze very large amounts of statistical information provided by database management. The aim of study: to visualize the information, it is proposed to perform initial intellectual analysis the formation of a parameters model for the query to classify and Separate set of requests. Scope of work . Each query is described by three sets of parameters: specified query execution plan parameters, real implementation plan parameters, and the characteristics of the implementation environment. its consider according to the characteristics, purpose and importance of each set of parameters and the methods to get them .its depends of selection the parameters to use in SQL query model ,query execution conditions and data base settings (DBS). Moreover, its depends on fails in the nature of the system for client programs. Problem statements. The problem is formulated by the dynamic formation in the inactive SQL query model from some of sets parameters that already contained identifiers. Conclusion: The proposed of this approach will speed up the search for inactive queries and can be extended to others databases, with consider their characteristics.
Keywords: SQL, query, DBMS, Oracle, inefficient SQL query, grouping, clustering