Oracle Tidbits: September 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in September 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #OracleCloud #AutonomousDB Sep 2020 #New: Refreshable clone of Autonomous DB. With a refreshable clone, the system creates a clone that can be easily updated … Read more

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

Oracle Tidbits – June 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in June 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit You can pre-format SQL query output in #SQLDev and #SQLcl using SET SQLFORMAT. The options are csv, html, xml, json, ansiconsole, insert, loader, fixed, … Read more

Oracle Tidbits – May 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in May 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #AutonomousDB Oracle Database Vault implements powerful security controls for your Autonomous Data Warehouse database. These security controls restrict access to application data by privileged … Read more

Oracle Tidbits – April 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in April 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #db20c Oracle Data Guard Broker provides early detection of fast-start failover (FSFO) configuration issues and reports those misconfigurations allowing administrators to take action prior … Read more

Oracle Tidbits – March 2020 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in March 2020. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit #Db20c Initialization parameters AUDIT_FILE_DEST, AUDIT_SYS_OPERATIONS, AUDIT_SYSLOG_LEVEL, AUDIT_TRAIL (Traditional auditing parameters) are deprecated in Oracle Database 20c. #OraTidbit #db20c Traditional auditing is deprecated in Database … Read more

Oracle Tidbits – December 2019 #OraTidbit

“Oracle *daily* TidBits” (#oratidbit) published on Facebook &Twitter, during weekdays in December 2019. December Tidbits are a repeat of the popular tidbits from 2019. I hope you find these helpful to learn something new or to remind you of its existence and use. #OraTidbit DBA_AUTO_STAT_EXECUTIONS view in #db19c displays information about automatic optimizer statistics collection tasks, which … Read more