“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 same statistics gathering job that is executed during the automatic nightly statistics gathering job. |
| #OraTidbit #OrclDb To check whether optimizer statistics are stale, query the STALE_STATS column in DBA_TAB_STATISTICS and DBA_IND_STATISTICS. Values: YES-The statistics are stale. NO-The statistics are not stale. null-The statistics are not collected. |
| #OraTidbit #AutonomousDB New in August 2020: If the #ADW/#ATP database version is 19c or higher, you can rename the Autonomous Database. After you rename a database, download a new wallet. Applications also must be updated to use the new connection string. |
| #OraTidbit Oracle Data Safe helps to understand the sensitivity of data, evaluate risks to data, mask sensitive data, implement and monitor security controls, assess user security, monitor user activity, and address data security compliance requirements. You can use #DataSafe with #AutonomousDB. |
| #OraTidbit Enabling block change tracking (BCT) facilitates fast incremental backups. Using BCT for Fast Incremental Backup on Physical Standby requires Oracle Active Data Guard option. |
| #OraTidbit #db20c The result cache in an Active Data Guard standby database is utilized to cache results of queries that were run on the physical standby database. In the case of a role transition to primary the standby database result cache will be preserved ensuring performance for offloaded reporting and other queries continue without compromising the performance benefits of the standby result cache. |
| #OraTidbit #db20c A new PL/SQL package called DBMS_FLASHBACK_ARCHIVE_MIGRATE enables the migration of Flashback Data Archive enabled tables from a database on any release (in which the package exists) to any database on any release (that supports Flashback Data Archive). |
| #OraTidbit #db20c The SQL set operators now support all keywords as defined in ANSI SQL. The new operator EXCEPT [ALL] is functionally equivalent to MINUS [ALL]. The operators MINUS and INTERSECT now support the keyword ALL. |
| #OraTidbit #db20c Init parameter MAX_IDLE_BLOCKER_TIME sets the number of minutes that a session holding needed resources can be idle before it is a candidate for termination. MAX_IDLE_TIME sets limits for all idle sessions, whereas MAX_IDLE_BLOCKER_TIME sets limits only for idle sessions consuming resources. |
| #OraTidbit #db20c You can configure database clients to maintain multiple Secure Sockets Layer (SSL) sessions using different SSL certificates. Useful for database clients simultaneously connecting to various cloud databases, each with a separate certificate. |
| #OraTidbit #db20c Convert a set of existing databases running the same application into a sharded database without modifying the database schemas or the application (Federated Sharding). The databases can be geographically distributed and can have some differences in their individual schemas. |
| #OraTidbit #db20c Oracle ASM Flex Disk Group Support for Cloning a pluggable database (PDB) in One multitenant container database (CDB) to a New PDB in a Different CDB in 20c. Previously point-in-time database clones could only clone a PDB in a CDB to a new PDB in the same CDB. |
| #OraTidbit #db20c Blockchain tables are append-only tables in which only insert operations are allowed. Deleting rows is either prohibited or restricted based on time. Rows in a blockchain table are made tamper-resistant by special sequencing & chaining algorithms. |
| #OraTidbit #OracleCloud Oracle #Blockchain Platform gives a pre-assembled platform for building and running smart contracts and maintaining a tamper-proof distributed ledger. |
| #OraTidbit #OracleCloud #AutonomousDB #JSON Autonomous JSON Database is an Oracle Cloud service that is specialized for developing NoSQL-style applications that use JavaScript Object Notation (JSON) documents. To provision, click Autonomous JSON Database from the OCI left navigation list. |
| #OraTidbit Oracle Trace File Analyzer generates a real-time health summary report, which shows performance degradation due to faults and workload issues. The health summary consists of scores in the categories of availability, health, workload, and capacity broken down from cluster-wide through the database, instance, service, and hardware resource. |
| #OraTidbit #OracleCloud Secure Global Desktop (SGD) is a secure remote access solution for cloud-hosted enterprise applications and desktops that run on Microsoft Windows, Linux, Solaris, and mainframe servers. The difference between SGD and SSH or VPN is that the client never enters the network and the administrator of SGD controls all access, including client features such as copy and paste, printing or device access. |