1. Optimizing the Execution Plan in an Oracle Database.
- Author
-
Boicea, Alexandru, Radulescu, Florin, and Ungureanu, Dan
- Subjects
- *
DATABASES , *COMPUTER files , *ELECTRONIC information resources , *ELECTRONIC data processing , *DATABASE design - Abstract
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. [ABSTRACT FROM AUTHOR]
- Published
- 2009
- Full Text
- View/download PDF