Oracle Tidbits – August 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in August 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #OrclDB When gathering optimizer statistics manually, you can reproduce the object prioritization of automatic collection by using the DBMS_AUTO_TASK_IMMEDIATE package. This package runs the … Read more

Oracle TidBits – July 2020 #OraTidBit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in July 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OrclDB #db20c Starting in Oracle Database 20c, the parameter to enable or disable password file case sensitivity is removed. All passwords in 20c password files … Read more