Optimizing The Execution Plan In An Oracle Database

被引：0
|
作者：
Boicea, Alexandru [1 ]
Radulescu, Florin [1 ]
Ungureanu, Dan [1 ]
机构：
[1] Univ Politehn Bucuresti, Fac Automat & Comp Sci, Bucharest, Romania
来源：
ADVANCED BIO-INSPIRED COMPUTATIONAL METHODS | 2008年
关键词：
database; instance; session; instruction; index;
D O I：
暂无
中图分类号：
TP18 [人工智能理论];
学科分类号：
081104 ; 0812 ; 0835 ; 1405 ;
摘要：
This paper presents a case study for different methods of optimization the execution plan in Oracle 11g Database with the view to obtaining the shortest time of execution of stored procedures and functions. The testing was made on application of mobile telephony through execution of stored procedure PL/SQL which is processing telephone invoices on a database with a million recordings. Some system parameters have greatly influenced the performance of execution times of stored procedures and functions.
引用
收藏
页码：124 / 128
页数：5
相关论文
共 50 条
  • [21] Plan execution: Problems and issues
    Pryor, L
    AI MAGAZINE, 1997, 18 (01) : 127 - 127
  • [22] Keeping plan execution healthy
    de Jonge, F
    Roos, N
    van den Herik, J
    MULTI-AGENT SYSTEMS AND APPLICATIONS IV, PROCEEDINGS, 2005, 3690 : 377 - +
  • [23] On explicit plan languages for coordinating multiagent plan execution
    Lee, J
    Durfee, EH
    INTELLIGENT AGENTS IV: AGENT THEORIES, ARCHITECTURES, AND LANGUAGES, 1998, 1365 : 113 - 126
  • [24] Optimizing Execution Plans in a Multistore
    Forresi, Chiara
    Francia, Matteo
    Gallinucci, Enrico
    Golfarelli, Matteo
    ADVANCES IN DATABASES AND INFORMATION SYSTEMS, ADBIS 2021, 2021, 12843 : 136 - 151
  • [25] RETRACTED: Research and application of ORACLE performance optimizing technologies for building airplane environment resource database (Retracted Article)
    Zhang Jianjun
    Sun Jianyong
    Cheng Conggao
    2011 INTERNATIONAL CONFERENCE ON ENERGY AND ENVIRONMENTAL SCIENCE-ICEES 2011, 2011, 11 : 1768 - 1775
  • [26] Adaptive and Big Data Scale Parallel Execution in Oracle
    Bellamkonda, Srikanth
    Li, Hua-Gang
    Jagtap, Unmesh
    Zhu, Yali
    Liang, Vince
    Cruanes, Thierry
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2013, 6 (11): : 1102 - 1113
  • [27] Detecting Execution Anomalies As an Oracle for Autonomy Software Robustness
    Katz, Deborah S.
    Hutchison, Casidhe
    Zizyte, Milda
    Le Goues, Claire
    2020 IEEE INTERNATIONAL CONFERENCE ON ROBOTICS AND AUTOMATION (ICRA), 2020, : 9366 - 9373
  • [28] Universal Trading for Order Execution with Oracle Policy Distillation
    Fang, Yuchen
    Ren, Kan
    Liu, Weiqing
    Zhou, Dong
    Zhang, Weinan
    Bian, Jiang
    Yu, Yong
    Liu, Tie-Yan
    THIRTY-FIFTH AAAI CONFERENCE ON ARTIFICIAL INTELLIGENCE, THIRTY-THIRD CONFERENCE ON INNOVATIVE APPLICATIONS OF ARTIFICIAL INTELLIGENCE AND THE ELEVENTH SYMPOSIUM ON EDUCATIONAL ADVANCES IN ARTIFICIAL INTELLIGENCE, 2021, 35 : 107 - 115
  • [29] Database Migration from ORACLE to PostgreSQL
    Kurako, E. A.
    Orlov, V. L.
    PROGRAMMING AND COMPUTER SOFTWARE, 2023, 49 (05) : 455 - 463
  • [30] Database Security and Supervisory Method in Oracle
    孙莉
    Journal of China Textile University(English Edition), 1999, (01) : 78 - 80
12345