Why should you use PLSQL_OPTIMIZE_LEVEL as 3 Mustafa, 2021-10-08 Hi, As you know PLSQL_OPTIMIZE_LEVEL parameter is used to optimize the codes while compiling them and it is really important. By default it’s value is 2 but you can increase it to 3 and you should, here is why. before begin, this is an extension for this post: https://mustafakalayci.me/2020/06/26/performance-gain-of-nocopy-parameters/ Very… Continue Reading
Performance Gain of NOCOPY Parameters Mustafa, 2020-06-262022-08-31 Hi, Almost every Oracle database uses PLSQL codes like packages/procedures/functions etc. Complex systems with complex codes pass many arguments (parameters) many times between plsql objects. Passing parameters might be the most executed operations in a database. So how well do you pass your parameters? I assume you know about types… Continue Reading