Introduction Since day one, I have been involved in discussions about whether Oracle Autonomous Database runs on Oracle RAC and whether the CPUs are distributed on multiple RAC nodes only for 17 OCPUs or more. Does that actually matter? No! But many, including me, always want to know more about what’s happening behind the scene.…
Do you want to develop an application and need a database? Create an Oracle Autonomous Database, download the Client Credentials, connect to the database, and create your first table, all in 50 seconds. Without pre-installing any tools. Open the Cloud Shell in your Cloud Console and execute the following few lines after adjusting the values…
Introduction Oracle Autonomous Database is a fully managed service. Simply specify the CPU count and the amount of storage needed and you are ready to go. Scaling up and down CPU and storage is an online operation without any service interruption. Additionally, you can enable CPU Auto Scaling. Traditional storage management operations like creating and…
Introduction Zero Downtime Migration (ZDM) provides great automation capabilities to migrate your Oracle Database to Oracle Cloud. After supporting Linux-based platforms, the new version 21.2 also supports cross-platform and even cross-cloud migrations. With this enhancement, now it’s possible to migrate an AWS RDS for Oracle to Oracle Autonomous Database using the offline logical migration method…
Introduction As more and more customers are moving their databases to Oracle Cloud, they have a mix of on-premises, Oracle Database Cloud Service, and Oracle Autonomous databases in their environments. DBAs and developers usually use SQL scripts to automate several tasks in the database. In some cases, they want to execute some tasks only on…
Introduction As you probably already know, Oracle APEX enables you to build applications with minimal coding. APEX is already available in all Oracle Autonomous Database workload types: transaction processing, data warehouse, and JSON. You get a fully-managed database where you can even more focus on your application development. Additionally, Oracle provides an Autonomous Database specifically…
Introduction As IT environments are growing and becoming more complex, the need for standardization, cost reduction, and greater agility is raising more than ever. Cloud solutions provide customers with features and capabilities to exactly achieve these goals and satisfy their business demands. When it comes to moving Oracle databases to the cloud, you might ask…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate as described in Part 2 or using the classical Data Pump export and import. This blog post provides a step by step instruction how to accordingly configure ZDM for Data Pump export and import with the minimal parameters required. Using Data Pump export and import…
Introduction ZDM version 21c supports logical migrations using Oracle GoldenGate. This makes it possible to migrate to Oracle Autonomous Database with zero downtime. This blog post provides step-by-step instructions on how to accordingly configure ZDM with the minimal parameters required. Data Pump will be used to create the initial load and GoldenGate extract and replicate…
Introduction Partitioned Tables allow you to subdivide tables into smaller pieces (partitions) that can be managed and accessed at a finer level of granularity. The nice thing is that it is entirely transparent to your SQL SELECT statements and to the application. External (Partitioned) Tables enable you to access data on external storage as if…
Database Heartbeat 