As an Oracle DBA, verifying the integrity and consistency of data across different environments is crucial. In this article, we … Continue reading Comparing Data Between Oracle Databases Using Ansible
If you’ve ever wished to simplify your database management tasks using AI, Oracle’s Select AI is here to revolutionize your … Continue reading Select AI with Oracle Autonomous Database: From a DBA point of view
Oracle Cloud Infrastructure (OCI) continues to evolve, offering new features and enhancements that bring more flexibility, security, and efficiency to … Continue reading What’s New in OCI in 2024 – DB and Compute
As Oracle Database Administrators (DBAs), understanding the evolving landscape of Oracle Exadata systems is crucial for optimizing database performance, scalability, … Continue reading Comparative Analysis of Oracle Exadata X-6, X-8M, and X-10M
From my memories of Oracle CloudWorld 2023. I attended various sessions and this is one of the many topics that stuck so wanted to share what I learned. Continue reading Oracle Exadata Exascale: Bye-Bye ASM?
Oracle Database is a powerful and versatile platform for managing vast amounts of data. While techniques like table partitioning and compression are essential for optimal performance, there’s a wealth of additional knowledge to explore. In this blog post, we’ll discuss a bit on partitioned tables, unpartitioned tables, indexing, and strategies to optimize the performance of an Oracle database. Continue reading Oracle database – Table Partitioning and Indexing
The Oracle Database 23c comes with a host of new features and enhancements aimed at making database management more efficient and user-friendly. One standout feature is the introduction of DBMS_SEARCH, a powerful PL/SQL package designed to simplify and optimize indexing for multiple schema objects. Continue reading Ubiquitous Database Search in Oracle 23c
Set Up Alarm Definitions in Database Management: Oracle Cloud Database Management now offers the ability to set up alarm definitions. … Continue reading What’s new in OCI (Oct 2023)?: DB Edition
Introduction In a big announcement today, September 14, 2023, Microsoft’s CEO, Satya Nadella, and Oracle’s CTO, Larry Ellison, unveiled the … Continue reading Oracle Database@Azure: A Game-Changer for Multi-Cloud Computing
If a pluggable database is showing in failed state on the Oracle Cloud Infrastructure (OCI) console however it is in … Continue reading Pluggable database in failed state on OCI Console
IT-Noesis 