Category: Oracle
-
Oracle SQL Developer 23.1 is now available
It’s time to go update your desktop copy of SQL Developer! We have some very important bug fixes for our community of Oracle Database users, … Oracle SQL Developer 23.1 is now available
Written by
·
-
Linux Playground on #OCI
Spring is here and I will definitely spend more time outside on my bike and carrying my iPad in my backpack. So I was looking for an easy to setup environment to practice and train my shell scripting skills. And Oracle Always Free has a simple solution for that! I setup a small compute instance…
Written by
·
-
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
Written by
·
-
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/
Written by
·
-
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
Written by
·
-
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
Written by
·
-
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
Written by
·
-
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…
Written by
·
-
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…
Written by
·
-
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
Written by
·
-
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
Written by
·
-
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
Written by
·