“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, default, delimited. DELIMITED defaults to ‘,’ but can be set via SET SQLFORMAT DELIMITED. |
| #OraTidbit #AutonomousDB Move to Autonomous Database (MV2ADB) tool is to migrate data from an on-premises Oracle Database Enterprise Edition deployment to an Oracle Autonomous database. MV2ADB uses Oracle Data Pump. “mv2adb auto” exports data from the source DB to OCI Object Storage, and then loads the data to the Autonomous Database. |
| #OraTidbit #AutonomousDB The ADB Schema Advisor is a light-weight utility that analyzes on-premise or cloud Oracle Database schemas for the suitability of migration to the Oracle Autonomous Database. Move to Autonomous Database tool option ‘mv2adb advisor’ it will install/execute the advisor automatically. |
| #OraTidbit #OraleZDM The major database release numbers of the source and target database must match for the Oracle Zero Downtime Migration (ZDM) job to succeed; higher patch release at the target is not a problem. |
| #OraTidbit #OracleCloud Oracle Database Cloud Service – Bare Metal Enterprise Edition includes the Oracle Database Enterprise Edition, Data Masking, and Subsetting Pack, Diagnostics and Tuning Packs, and Real Application Testing. |
| #OraTidbit #AWS #OracleRDS You can access trace files, audit log files, alert log file, listener log file using the Amazon RDS console or API. Use the procedures in rdsadmin.manage_tracefiles and rdsadmin.rdsadmin_util PL/SQL packages. |
| #OraTidbit #AWS #OracleRDS Amazon RDS purges trace files by default and log files that are older than seven days. You can view and set the trace file retention period using the rdsadmin.rdsadmin_util.show_configuration and set_configuration procedures. |
| #OraTidbit #AWS #OracleRDS You can create up to five read replicas of the Oracle RDS database. Amazon RDS upgrades the read replicas immediately after upgrading the source DB instance. You must own Active Data Guard license to create read replicas. |
| #OraTidbit #AutonomousDB Use the DBMS_CLOUD.EXPORT_DATA procedure to specify a query to select the data from Autonomous Database to your Cloud Object Store as Oracle Data Pump dump file. Note that the dump files cannot be imported using Oracle Data Pump impdp. |
| #OraTidbit #AutonomousDB Autonomous Database 19c provides Autonomous Data Guard where you can choose to enable a standby (peer) database to provide data protection and disaster recovery for your Autonomous Database instance. The standby database is created in the same region as the primary database. |
| #OraTidbit #OracleCloud If you include Oracle Database software licenses in your Oracle Exadata Cloud@Customer subscription, then the included licenses contain all of the features of Oracle Database Enterprise Edition, plus all of the database enterprise management packs, and all of the Enterprise Edition options. |
| #OraTidbit #OracleCloud Oracle Data Safe is a fully-integrated Cloud service focused on the security of your data. Features include Security Assessment, User Assessment, Data Discovery, Data Masking, and Activity Auditing. |
| #OraTidbit Oracle Database Real Application Security is a database authorization model that: supports declarative security policies, enables end-to-end security for multitier applications, provides an integrated solution to secure database and application resources, and advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet. |
| #OraTidbit #AutonomousDB #AWS The SQL Developer Amazon Redshift Migration Assistant, available with #SQLDev 18.3 and later versions provide a framework for easy migration of Amazon #Redshift environments on a per-schema basis. |
| #OraTidbit #OracleAnalytics With Oracle Analytics Desktop, you can connect to many different data sources such as DB2, Azure SQL, Amazon Aurora, Amazon Redshift, Neteeza, Sybase, PostgresSQL and many more. |
| #OraTidbit #AutonomousDatabase The ADB Schema Advisor is a light-weight utility that analyzes the on-premise or cloud Oracle Database schemas for the suitability of migration to the Autonomous Database. The Advisor discovers the schema objects and performs deep analysis to highlight is any differences exist when the object gets created on Oracle Autonomous Data Warehouse or Oracle Autonomous Transaction Processing database. |
| #OraTidbit #OracleCloud You can obtain the OCI tenancy details of DBaaS or Autonomous DB by querying the CLOUD_IDENTITY column of the V$PDBS view. The identity includes Database name, Region, Tenant OCID, Database OCID, and Compartment OCID. |
| #OraTidbit #OracleCloud #ExadataCloud Exadata Cloud Service is equipped with Oracle Database Enterprise Edition, plus all the database enterprise management packs and all the Enterprise Edition options, such as Oracle Database In-Memory and Oracle Real Application Clusters (RAC). |
| #OraTidbit #OracleCloud #ExadataCloud Application users and administrators connect only to the database servers, using the supplied client and backup network interfaces. Oracle manages all hardware, firmware, and the Exadata Storage Server software by using a separate management network. |