USING OPTIMIZER HINTS IN AN ORACLE DATABASE

This paper presents how to use hints to force various approaches for optimization the execution times of stored procedures in Oracle 11g. The testing was made on an 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.