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
Using Temp instead of Undo for GTTs Mustafa, 2019-06-262019-07-03 Hello everyone, with 12c we have a very nice new option; Temp Undo for GTTs (Global Temporary Tables). as you know temporary tables are used for storing temporary data. those tables data are stored in TEMP tablespace so they are not vital. Temporary tables can generates very little redo data… Continue Reading