Analysis and Selection of the Optimizer Mode for Obtaining the Optimal Plan for the Execution of a Query in the ORACLE DBMS
( Pp. 92-100)

More about authors
Unkovskaia Galina A. master’s degree,
Belgorod State Technological University named after V.G. Shukhov
Belgorod, Russian Federation
For read the full article, please, register or log in
The relevance of this topic is related to the widespread use of Oracle database management systems (DBMS) in many industries where data volumes are extremely large, which requires high system performance, reliability and fault tolerance. The gradual increase in the number of users and the increasing amount of information processed in conditions of limited resources leads to the need for optimization to achieve stable results and reduce performance incidents. In Oracle, no matter what actions are performed on the data, an optimizer is involved, whose task is to determine the optimal query execution plan. The purpose of this study is to analyze the principles of the optimizer modes, compare them, determine the advantages and disadvantages of each of them, as well as the degree of influence of various factors on the construction of an optimal query execution plan for each of the optimizer modes. Simulations have shown that response time, overhead, and runtime stability can be improved by applying the correct optimizer mode. The result of the study is to provide recommendations for choosing the optimizer mode for a specific case.
How to Cite:
Unkovskaia G.A. Analysis and Selection of the Optimizer Mode for Obtaining the Optimal Plan for the Execution of a Query in the ORACLE DBMS. Computational Nanotechnology. 2023. Vol. 10. No. 3. Pp. 92–100. (In Rus.) DOI: 10.33693/2313-223X-2023-10-3-92-100. EDN: RYVEQA
Reference list:
Gladkov A.K., Nikolskaya D.I. Search engine optimization research based on the database. Economy and Quality of Communication Systems. 2022. No. 4. Pp. 67–74. (In Rus.)
Millsap K., Holt D. Oracle. Performance optimization. St. Petersburg: Symbol-Plus, 2006. 464 p.
Ivanov K.K., Efremov A.A., Vashchenko I.A. The role of the optimization process in the operation of database systems. Young Scientist. 2016. No. 28 (132). Pp. 15-16. (In Rus.)
Przyjalkowski V. What are Oracle’s plans? URL: (data of accesses: 07.07.2023).
Esaulova E.A. Comparison of optimizers. Proceedings of the tenth regional conference on mathematics MAK-2007. Barnaul, June, 2007. AltSU, AltSTU, BSPU, GAGU, Institute of water and environmental problems (Barnaul). N.M. Oskorbin et al. (ed.). Barnaul: AltGU Publishing House, 2007. Pp. 62–63.
Green C.D. Oracle 9i database performance tuning guide and reference. Release 2 (9.2) Part Number A96533-02. URL: (data of accesses: 09.07.2023).
Kite T. Oracle for professionals. Transl. from English. St. Petersburg: DiaSoftYUP LLC, 2003. 672 p.
Lewis J. Oracle. Fundamentals of cost optimization. St. Petersburg: Piter, 2006. 528p.
Jahrke M., Koch J. Query optimization in database systems. Transl. from English S. Kuznetsov. 1984. URL: (data of accesses: 09.07.2023).
Algazali S.M.M., Aivazov V.G., Kuznetsova A.V. Improving the process of finding inefficient SQL queries in the Oracle DBMS. Engineering Journal of Don. 2017. No. 4. (In Rus.) URL: (data of accesses: 16.07.2023).
Unkovskaia G.A. Integration of the method of multi-criteria selection of alternatives based on fuzzy sets into the business processes of the banking sector. XXI Century: Resumes of the Past and Challenges of the Present plus. 2022. No. 4 (60). Pp. 63–67. (In Rus.)
Nimick R.J. Tuning problematic queries. Oracle Magazine. 2000. (In Rus.) URL: (data of accesses: 10.07.2023).
Czuprynski J. Oracle database 11g Release 1 new features summary. Part 1. 2007. URL: (data of accesses: 28.06.2023).
Apple R. Oracle cost based optimizer correlations. All Regis University Theses. 2013. No. 234. URL: (data of accesses: 20.07.2023).
Hellström I. Oracle SQL & PL. SQL Optimizationfor Developers Documentation. Release 3.0.1. 2023. URL: (data of accesses: 16.07.2023).
Xiaoxiang Hermit. RBO and CBO of ORACLE optimizer. URL: (data of accesses: 16.07.2023).
Burleson D.K. Optimizing oracle optimizer statistics. URL: (data of accesses: 18.07.2023).
Kite T. Oracle: Effective application design. St. Petersburg: Piter. 2006. 800 p.
optimizer mode, access method, optimal plan, Oracle DBMS, performance.

Related Articles

Pages: 17-20 Issue №2286
Termination of passive joint obligation under the civil legislation of the Russian Federation and Ukraine
joint obligation joint debtors performance innovation debt forgiveness
Show more
CRIMINAL LAW (5.1.4.) Pages: 93-97 Issue №24238
Formation of Physical Fitness of Students in Educational Organizations of the Ministry of Internal Affairs of Russia in the Process of Mastering Combat Techniques of Wrestling
physical fitness combat fighting techniques strength reaction speed coordination of movements
Show more
3. ACCOUNTING, STATISTICS 08.00.12 Pages: 117-126 Issue №18758
Modernization of accounting, analytical and control processes in the conditions of digitalization of the economy
information support scorecard communication systems models analytical tools
Show more
11. GAPS IN THE LAW, INTERNATIONAL PUBLIC LAW Pages: 101-103 Issue №4210
The Riyadh Arab Agreement for Judicial Cooperation: Specificity of the Region
Riyad Convention cooperation recognition performance the court decision
Show more
5. CIVIL LAW; ENTREPRENEURIAL LAW; FAMILY LAW; INTERNATIONAL PRIVATE LAW; Civil procedure arbitration procedure Pages: 124-127 Issue №6998
Legal nature of demand and its qualitative characteristics
the obligation time withdrawal potestative condition performance
Show more
10. Financial law; Tax law; Budgetary law; Information Law; Administrative law; Administrative process Pages: 163-166 Issue №2833
Improving the performance of government functions through the messages of the President of Russia
act the state performance the norm Parliament
Show more
9. INTERNATIONAL PUBLIC LAW Pages: 231-236 Issue №3636
Forms and methods of translating norms of international instruments on human rights in the national legal system
form ways the embodiment implementation transformation
Show more
13. Civil procedure arbitration procedure Pages: 320-326 Issue №8496
arbitration Middle East alternative methods of dispute resolution The Hashemite Kingdom Of Jordan procedure
Show more