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 条
  • [11] Influence of Oracle hints on query execution
    Panus, Jan
    Pirkl, Josef
    SELECTED TOPICS IN APPLIED COMPUTER SCIENCE, 2010, : 490 - +
  • [12] Designing a Dependency Execution for Oracle Jobs
    Gu, Yuanhu
    Palaoag, Thelma Domingo
    PROCEEDINGS OF 2019 4TH INTERNATIONAL CONFERENCE ON INTELLIGENT INFORMATION TECHNOLOGY (ICIIT 2019), 2019, : 91 - 95
  • [13] Execution of the Work Plan
    Landauer, Carl
    SOCIAL RESEARCH, 1935, 2 (04): : 504 - 511
  • [14] Oracle secureiles - A filesystem architecture in Oracle database server
    Mukherjec, Niloy
    Ganesh, Amit
    Kuchithapadam, Krishna
    Muthulingam, Sujatha
    ICSOFT 2008: PROCEEDINGS OF THE THIRD INTERNATIONAL CONFERENCE ON SOFTWARE AND DATA TECHNOLOGIES, VOL SE/GSDCA/MUSE, 2008, : 60 - 63
  • [15] Oracle essentials: Oracle database 10g
    Gordon, RS
    LIBRARY JOURNAL, 2004, 129 (16) : 104 - 104
  • [16] Plan generation and plan execution in agent programming
    Van Riemsdijk, M. Birna
    Dastani, Mehdi
    DECLARATIVE AGENT LANGUAGES AND TECHNOLOGIES IV, 2006, 4237 : 225 - +
  • [17] An Oracle© database for the AMS experiment
    Boschini, M
    Gervasi, M
    Grandi, D
    Rancoita, PG
    Trombetta, L
    Usoskin, IG
    NUCLEAR PHYSICS B-PROCEEDINGS SUPPLEMENTS, 1999, 78 : 727 - 731
  • [18] Measuring oracle database schemas
    Grupo ALARCOS, E.S. Informática, Universidad de Castilla - La Mancha, Ronda Calatrava, 5, 13071 Ciudad Real, Spain
    Comput. Comput. Eng. Control, (237-243):
  • [19] INTEGRATING PLANNING, EXECUTION, AND LEARNING TO IMPROVE PLAN EXECUTION
    Jimenez, Sergio
    Fernandez, Fernando
    Borrajo, Daniel
    COMPUTATIONAL INTELLIGENCE, 2013, 29 (01) : 1 - 36
  • [20] Plan execution in dynamic environments
    Fraser, G
    Steinbauer, G
    Wotawa, F
    INNOVATIONS IN APPLIED ARTIFICIAL INTELLIGENCE, 2005, 3533 : 208 - 217
12345