Optimizing the Execution Plan in an Oracle Database

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.