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 6, Romania
来源：
BICS 2008: PROCEEDINGS OF THE 1ST INTERNATIONAL CONFERENCE ON BIO-INSPIRED COMPUTATIONAL METHODS USED FOR SOLVING DIFFICULT PROBLEMS-DEVELOPMENT OF INTELLIGENT AND COMPLEX SYSTEMS | 2008年 / 1117卷
关键词：
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 for Windows 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. The procedure verifies if the invoices for mobile telephony are in accordance with the type of contract. Some system parameters have greatly influenced the performance of execution times of stored procedures and functions.
引用
收藏
页码：89 / 94
页数：6
相关论文
共 50 条
  • [1] Optimizing The Execution Plan In An Oracle Database
    Boicea, Alexandru
    Radulescu, Florin
    Ungureanu, Dan
    ADVANCED BIO-INSPIRED COMPUTATIONAL METHODS, 2008, : 124 - 128
  • [2] Optimizing data transformation plan execution
    Yu, TF
    ISE'2001: PROCEEDINGS OF THE INTERNATIONAL SYMPOSIUM ON INFORMATION SYSTEMS AND ENGINEERING, 2001, : 80 - 84
  • [3] Optimizing SAS® access to an Oracle database in a large data warehouse
    Somerville, C
    Cooper, C
    PROCEEDINGS OF THE TWENTY-THIRD ANNUAL SAS USERS GROUP INTERNATIONAL CONFERENCE, 1998, : 511 - 520
  • [4] Systematic function optimizing and realization in Oracle database based on Windows platform
    Wang, Xiaochun
    Zhao, Ji
    Zhang, Yan
    Jisuanji Gongcheng/Computer Engineering, 2004, 30 (09):
  • [5] Research and Application of ORACLE Performance Optimizing Technologies for Building Airplane Environment Resource Database
    Zhang Jianjun
    Sun Jianyong
    Cheng Conggao
    INTERNATIONAL CONFERENCE ON GRAPHIC AND IMAGE PROCESSING (ICGIP 2012), 2013, 8768
  • [6] A novel query execution time prediction approach based on operator iterate-aware of the execution plan on the graph database
    He, Zhenzhen
    Yu, Jiong
    Gu, Tiquan
    JOURNAL OF KING SAUD UNIVERSITY-COMPUTER AND INFORMATION SCIENCES, 2024, 36 (06)
  • [7] ORACLE DATABASE MACHINE
    Martinez, Ricardo
    IBERGRID: 4TH IBERIAN GRID INFRASTRUCTURE CONFERENCE PROCEEDINGS, 2010, : 470 - 472
  • [8] ORACLE AND THE DATABASE WARRIORS
    SHAFFER, RA
    PERSONAL COMPUTING, 1990, 14 (03): : 41 - 42
  • [9] ORACLE DATABASE SECURITY
    Kaluzova, Ludmila
    STRATEGIC MANAGEMENT AND ITS SUPPORT BY INFORMATION SYSTEMS, PROCEEDINGS, 2007, : 25 - 30
  • [10] Oracle Database Replay
    Colle, Romain
    Galanis, Leonidas
    Buranawatanachoke, Supiti
    Papadomanolakis, Stratos
    Wang, Yujun
    PROCEEDINGS OF THE VLDB ENDOWMENT, 2009, 2 (02): : 1542 - 1545
12345