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 条
  • [41] Intelligent Supervision for Robust Plan Execution
    Micalizio, Roberto
    Scala, Enrico
    Torasso, Pietro
    AI(STAR)IA 2011: ARTIFICIAL INTELLIGENCE AROUND MAN AND BEYOND, 2011, 6934 : 151 - 163
  • [42] Speculative plan execution for information gathering
    Barish, Greg
    Knoblock, Craig A.
    ARTIFICIAL INTELLIGENCE, 2008, 172 (4-5) : 413 - 453
  • [43] Diagnosis of plan execution and the executing agent
    Roos, N
    Witteveen, C
    KI2005: ADVANCES IN ARTIFICIAL INTELLIGENCE, PROCEEDINGS, 2005, 3698 : 161 - 175
  • [44] Plan execution in a hostile dynamic environment
    Au, S
    Liang, J
    Parameswaran, N
    ADVANCED TOPICS IN ARTIFICIAL INTELLIGENCE, 1998, 1502 : 59 - 70
  • [45] Optimizing the Execution of Product Data Models
    Varvoutas, Konstantinos
    Bellas, Christos
    Kougka, Georgia
    Gounaris, Anastasios
    IEEE ACCESS, 2024, 12 : 25397 - 25410
  • [46] A database for optimizing MPI
    Chrysanthou-Baustert, I.
    Yiannakkaras, C.
    Demetriadou, O.
    Parpottas, Y.
    Christofides, S.
    Constantinos, C.
    Kaolis, D.
    EUROPEAN JOURNAL OF NUCLEAR MEDICINE AND MOLECULAR IMAGING, 2011, 38 : S185 - S185
  • [47] Improving Fault Localization with External Oracle by Using Counterfactual Execution
    Park, Jongchan
    Park, Tae eun
    Kim, Dongsun
    Heo, Kihong
    ACM TRANSACTIONS ON SOFTWARE ENGINEERING AND METHODOLOGY, 2025, 34 (02)
  • [48] AB=(sic)A: Execution Equivalence as a New Type of Testing Oracle
    Elyasov, A.
    Prasetya, W.
    Hage, J.
    Rueda, U.
    Vos, T.
    Condori-Fernandez, N.
    30TH ANNUAL ACM SYMPOSIUM ON APPLIED COMPUTING, VOLS I AND II, 2015, : 1559 - 1566
  • [49] Oracle Database In-Memory: A Dual Format In-Memory Database
    Lahiri, Tirthankar
    Chavan, Shasank
    Colgan, Maria
    Das, Dinesh
    Ganesh, Amit
    Gleeson, Mike
    Hase, Sanket
    Holloway, Allison
    Kamp, Jesse
    Lee, Teck-Hua
    Loaiza, Juan
    Macnaughton, Neil
    Marwah, Vineet
    Mukherjee, Niloy
    Mullick, Atrayee
    Muthulingam, Sujatha
    Raja, Vivekanandhan
    Roth, Marty
    Soylemez, Ekrem
    Zait, Mohamed
    2015 IEEE 31ST INTERNATIONAL CONFERENCE ON DATA ENGINEERING (ICDE), 2015, : 1253 - 1258
  • [50] Distributed Architecture of Oracle Database In-memory
    Mukherjee, Niloy
    Chavan, Shasank
    Colgan, Maria
    Das, Dinesh
    Gleeson, Mike
    Hase, Sanket
    Holloway, Allison
    Jin, Hui
    Kamp, Jesse
    Kulkarni, Kartik
    Lahiri, Tirthankar
    Loaiza, Juan
    Macnaughton, Neil
    Marwah, Vineet
    Mullick, Atrayee
    Witkowski, Andy
    Yan, Jiaqi
    Zait, Mohamed
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2015, 8 (12): : 1630 - 1641
12345