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 条
  • [31] ORACLE DATABASE-MANAGEMENT SYSTEM
    ALBAN, H
    DATA BASE PRODUCT REPORTS, 1987, 5 (02): : 5 - 44
  • [32] Database Migration from ORACLE to PostgreSQL
    E. A. Kurako
    V. L. Orlov
    Programming and Computer Software, 2023, 49 : 455 - 463
  • [33] Autonomicity in Oracle Database Management System
    Raza, Basit
    Mateen, Abdul
    Sher, Muhammad
    Awais, Mian Muhammad
    Hussain, Tauqeer
    PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON DATA STORAGE AND DATA ENGINEERING (DSDE 2010), 2010, : 296 - 300
  • [34] Optimized Program and Implementation of Oracle Database
    Chen Yu
    Cheng Pingguang
    PROCEEDINGS OF THE 2009 INTERNATIONAL CONFERENCE ON SOFTWARE TECHNOLOGY AND ENGINEERING, 2009, : 366 - 369
  • [35] USING OPTIMIZER HINTS IN AN ORACLE DATABASE
    Boicea, Alexandru
    Radulescu, Florin
    Bucur, Ion
    Ungureanu, Dan
    ANNALS OF DAAAM FOR 2009 & PROCEEDINGS OF THE 20TH INTERNATIONAL DAAAM SYMPOSIUM, 2009, 20 : 1371 - 1372
  • [36] Research on the Backup Bechanism of Oracle Database
    Li, Qun
    Xu, Honglin
    2009 INTERNATIONAL CONFERENCE ON ENVIRONMENTAL SCIENCE AND INFORMATION APPLICATION TECHNOLOGY, VOL II, PROCEEDINGS, 2009, : 423 - +
  • [37] PLAN CREATION, PLAN EXECUTION AND KNOWLEDGE ACQUISITION IN A DYNAMIC MICROWORLD
    MCCALLA, GI
    REID, L
    INTERNATIONAL JOURNAL OF MAN-MACHINE STUDIES, 1982, 16 (01): : 89 - 112
  • [38] Intelligent Execution through Plan Analysis
    Borrajo, Daniel
    Veloso, Manuela
    2021 IEEE/RSJ INTERNATIONAL CONFERENCE ON INTELLIGENT ROBOTS AND SYSTEMS (IROS), 2021, : 3162 - 3167
  • [39] Managing decision resources in plan execution
    Freed, M
    Remington, R
    IJCAI-97 - PROCEEDINGS OF THE FIFTEENTH INTERNATIONAL JOINT CONFERENCE ON ARTIFICIAL INTELLIGENCE, VOLS 1 AND 2, 1997, : 322 - 326
  • [40] HAVE A GOOD PROJECT EXECUTION PLAN
    SANDERSON, HM
    HYDROCARBON PROCESSING, 1983, 62 (12): : 72 - 76
12345