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
Category: db
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
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…
Read More Announcing custom third-party Python and R packages for use on Autonomous Database
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…
Read More Problematic Statistics of the Application Objects in your Oracle Database
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: SELECT grantee, privilegeFROM dba_tab_privsWHERE owner = 'SYS'AND table_name = 'DBMS_AUTO_TASK_ADMIN'AND privilege = 'EXECUTE';…
Announcing Oracle Transaction Manager for Microservices Free
Oracle is announcing a new product to provide distributed transaction management services for microservice based applications. — Read on blogs.oracle.com/database/post/announcing-oracle-transaction-manager-for-microservices-free
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
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
High Availability Framework and Query Fault Tolerance for Hybrid Distributed Database Systems | Proceedings of the 31st ACM International Conference on Information & Knowledge Management
High Availability Framework and Query Fault Tolerance for Hybrid Distributed Database Systems | Proceedings of the 31st ACM International Conference on Information & Knowledge Management — Read on dl.acm.org/doi/abs/10.1145/3511808.3557086
Oracle (ORCL) Makes Order and Pay Easier at Restaurants
Oracle (ORCL) makes enhancements in Oracle MICROS Simphony to help restaurants serve their customers better. — Read on finance.yahoo.com/news/oracle-orcl-makes-order-pay-180906091.html
Resources management across database world – part I
Consolidation and resources optimization – we could we can meet them almost anywhere. Databases are there too. Everything is fine when available …Resources management across database world – part I
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
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
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…