“Oracle *daily* TidBits” (#oratidbit) published on Facebook, Twitter, and Google+ during weekdays in November 2018. Hope you find these helpful to learn something new or to remind you of its existence and use.
| #oratidbit #oraclecloud DBaaS Cloud Service Bare Metal is a dedicated instance with Oracle Database 11g, 12c, or 18c, including the multitenant option. Infrastructure ranges from virtual machines with 1 to 24 cores, 256 GB to 40 TB storage. |
| #oratidbit #oraclecloud Oracle Database Exadata Express Cloud Service is a fully managed database cloud service. Network configuration, storage, database patching & upgrade are taken care of for you. |
| #oratidbit #oraclecloud Oracle #DataHub Cloud Service enables you to consistently provision and manage NoSQL database clusters such as Apache Cassandra on Oracle Cloud. |
| #oratidbit #oraclecloud Oracle #EventHub Cloud Service is a managed, cloud-based messaging platform that leverages the combined power of Oracle Cloud and Apache #Kafka to enable you to work with streaming data. |
| #oratidbit #oraclecloud Oracle #NoSQL Database Cloud is a fully managed database cloud service that is designed to handle large amounts of data |
| #oratidbit #orachk Oracle Trace File Analyzer automatically runs SRDC (Service Request Data Collection) when ORA-600, ORA-4030, ORA-4031, ORA-7445 events are detected. |
| #oratidbit #orachk Installing Oracle Trace File Analyzer as root on non-engineered systems automatically sets up and runs the ORAchk daemon. The daemon restarts at 1 am every day to discover any environment changes. |
| #oratidbit #oraclecloud #dbaas The “Data Guard Standby for Hybrid DR” database type on Oracle Database Cloud Service is a single-instance database acting as the standby database in an Oracle Data Guard configuration. The primary database is on your own system. |
| #oratidbit #oracleXE Oracle Database 18c XE (Express Edition) limits itself automatically to two cores for processing. The maximum amount of user data in XE database cannot exceed 12GB. If the user data grows beyond this limit, then an ORA-12592 error will appear. |
| #oratidbit #oracleXE A Pluggable Database (PDB) created in Oracle Database XE 18c can be migrated to another Multitenant Container Database (CDB) Enterprise Edition (EE) 18c. Unplug a PDB from XE 18c database and plug it into another EE 18c database of the same release. |
| #oratidbit #oracleXE Oracle GoldenGate can not be used with Oracle Database Express Edition. |
| #oratidbit #oracleXE The maximum amount of user data in an Oracle Database XE database cannot exceed 12 gigabytes. Use Advanced Compression option to store more data. Use “ROW STORE COMPRESS ADVANCED” (table) “COMPRESS ADVANCED <LOW | HIGH>” (index) clauses. |
| #oratidbit #oracleXE To deinstall 18c XE, perform as root 1) “/etc/init.d/oracle-xe-18c delete” to remove data files, listener and configuration files 2) “yum remove oracle-database-xe-18c” to remove the software. |
| #oratidbit #orcldb Oracle Database monitors simple database operations when SQL statements or PL/SQL subprograms have consumed at least 5 seconds of CPU or I/O time in a single execution. |
| #oratidbit #orcldb When the CONTROL_MANAGEMENT_PACK_ACCESS init parameter is set to DIAGNOSTIC+TUNING, you can use /*+ MONITOR */ hint to enable monitoring of specific SQL statements. The MONITOR hint can enforce monitoring of statements that do not meet the time criteria. |
| #oratidbit #oraclecloud Oracle Database Backup Cloud Service supports two Oracle Database optimizations: RMAN backup encryption and RMAN backup compression algorithms. |
| #oratidbit #oraclecloud In addition to RMAN interface, you can use Oracle Enterprise Manager Cloud Control 13c to configure the backup module and perform backup and recovery operations in the Oracle Database Backup Cloud Service. |
| #oratidbit #oracleoem Oracle Enterprise Manager Ops Center is Oracle’s comprehensive solution for managing the physical and virtual assets in the data center: operating systems, firmware, BIOS configurations, bare metal server and so on. |
| #oratidbit #oracle101 If you enter values for a multi-value initalization parameter on multiple lines in the pfile, then the entries must be on consecutive lines. If they are not, then the first entry will not be processed. |
| #oratidbit #oracle101 The ALTER SYSTEM … DEFERRED statement does not modify the global value of the init parameter for existing sessions, but the value will be modified for future sessions that connect to the database. (Not all parameters are eligible for DEFERRED). |