Oracle – Page 4 – Radu Pârvu

Always Free Resources

Learn what Always Free resources are available to all Oracle Cloud Infrastructure users. — Read on docs.oracle.com/en-us/iaas/Content/FreeTier/freetier_topic-Always_Free_Resources.htm

April 13, 2023

Managed disaster recovery and managed reader farm with Amazon RDS for Oracle using Oracle Active Data Guard | AWS Database Blog

Managed disaster recovery and managed reader farm with Amazon RDS for Oracle using Oracle Active Data Guard | AWS Database Blog — Read on aws.amazon.com/blogs/database/managed-disaster-recovery-and-managed-reader-farm-with-amazon-rds-for-oracle-using-oracle-active-data-guard/

April 12, 2023

Oracle Database 23c Free – Wider Tables

Oracle Database 23c Free introduces the ability to have wider tables, up to 4096 columns. — Read on blogs.oracle.com/in-memory/post/23c-free-wider-tables

April 9, 2023

ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

ChatGPT is the hottest topic in the tech world right now. One story even says that ChatGPT has passed Google’s Level 3 programming interview. I … ChatGPT Won’t Replace MySQL DBA – An Example of a Question About Encryption at Rest

March 28, 2023

Announcing custom third-party Python and R packages for use on Autonomous Database

In our continued expansion of Oracle Autonomous Database as a platform for data science and machine learning, we are pleased to announce that users of Oracle Machine Learning (OML) Notebooks and OML4Py and OML4R embedded execution are now able use custom-installed third-party packages in conda environments. — Read on blogs.oracle.com/machinelearning/post/third-party-python-and-r-packages-for-use-on-adb

March 24, 2023

Problematic Statistics of the Application Objects in your Oracle Database

One of the often asked questions is to find out the status of the statistics of the application owned schemas. In this article, I will list the SQL code that I used for this purpose. As well, I will publish a SQL Developer report that can be used for the same purpose. For ease of…

February 11, 2023

Oracle Automated DB Maintenance Tasks

This is a short article on how to manage the automated Oracle database maintenance tasks. Make sure the needed rights are in place by running the check: Typical output is: If your user is not listed, you must grant EXECUTE in order to use the package: We can check what is enabled by running: With…

February 1, 2023

Achieving Data Sovereignty with Oracle Sharding (Part 1)

Oracle Sharding meets data sovereignty requirements and supports applications that require low latency and high availability. — Read on blogs.oracle.com/database/post/achieving-data-sovereignty-with-oracle-sharding-part-1

January 30, 2023

Run Liquibase updates for a specific schema with SQLcl

Have a new version of your application schema to deploy? Let’s demonstrate how to run Liquibase updates for a specific schema. I have a changeSet for… Run Liquibase updates for a specific schema with SQLcl

December 20, 2022

List of the Oracle Database 23c New Features

On October 18th 2022, Oracle announced the new long term release of 23c Beta. Here is a compiled list of the new features I am aware of: OLTP and … List of the Oracle Database 23c New Features

November 1, 2022

Top Six Oracle GoldenGate Announcements at Cloud World 2022

Innovative new capabilities, significant cost savings and a major leap forward in simplicity and usability for all GoldenGate developers! — Read on blogs.oracle.com/database/post/goldengate-announcements-at-cloud-world-2022

October 31, 2022

Oracle Announces MySQL HeatWave Lakehouse with 17X Faster Query Performance vs. Snowflake and 6X Faster than Redshift on 400 TB Workload

Oracle today announced MySQL HeatWave Lakehouse, enabling customers to process and query hundreds of terabytes of data in object store in a variety of file formats, such as CSV and Parquet, as well as Aurora and Redshift backups. — Read on www.oracle.com/news/announcement/ocw-oracle-announces-mysql-heatwave-lakehouse-2022-10-18/

October 24, 2022