Pubudu: Data and Decisions

One of the most common performance bottlenecks in enterprise applications is resource reservation. Whether it is booking airline seats, reserving hotel rooms, allocating inventory etc, many applications rely on database row locking to prevent double booking. While this approach works, it becomes a serious scalability challenge during peak demand. The result is, Increased lock waits Application timeouts Poor user experience Reduced transaction throughput   The question is: Can we prevent double booking without relying heavily on database locks? The answer is yes.   Modern Oracle based applications can implement lock free reservation patterns that significantly reduce contention while maintaining data integrity.   The Traditional Approach Most applications perform a reservation using below method. SELECT available_qty FROM inventory WHERE item_id = 100 FOR UPDATE;   If sufficient quantity exists, UPDATE inventory SET ava...

Over the past few years, I have been closely following the evolution of cloud technologies and how enterprises are adopting them to drive digital transformation. While public cloud has become the default conversation for many organizations, I have often felt that the real enterprise challenge is not simply moving to the cloud, it is finding the right balance between innovation, security, regulatory compliance, and operational control.  As someone who has worked extensively with enterprise infrastructure and Oracle technologies, I wanted to share my perspective on why Oracle Cloud Infrastructure (OCI) is taking a different approach to this challenge. This article explores how OCI is redefining the future of private cloud by combining the capabilities of a modern public cloud with the isolation, sovereignty, and operational independence that many organizations increasingly require. Cloud computing has completely changed how organizations operate today. Businesses are moving applicati...

  Over the years, I had the opportunity to work with Oracle E-Business Suite (Oracle EBS) environments across multiple industries including manufacturing, banking, education, healthcare, and retail. Through these experiences, I have seen how Oracle EBS helps organizations streamline operations, improve efficiency, and manage complex business processes through a centralized platform. In this article, I would like to share a simple overview of how different industries are using Oracle EBS and how it continues to support modern digital transformation initiatives. In today’s fast moving business world, companies need systems that help them work faster, reduce costs, and make better decisions. Managing finance, HR, procurement, inventory, and operations through separate systems is no longer efficient. Businesses now prefer centralized platforms that can connect all departments together. This is where Oracle EBS plays an important role. Oracle EBS is one of the world’s most widely us...

  “Oracle Deep Data Security” was discussed recently at the Oracle AI World Singapore and it interested me to further study on how data security is evolving in the age of AI. The way data is accessed, processed and protected is changing dramatically with the rapid adoption of AI among the organizations. That’s why I thought it would be useful to explore Oracle Deep Data Security in a simple and practical way. In today’s world, data is everywhere. Businesses store customer data, financial transactions, employee records and much more inside databases. Earlier time, security was mostly handled at the application level. But this approach is no longer strong enough. With AI tools generating queries dynamically and multiple systems interacting with the same database, relying only on application level security creates risks. This is where Oracle introduces a new approach, moving security directly into the database itself. Oracle Deep Data Security is built on the idea that data shou...

  “Bring AI to Data” is a term I recently heard during the Oracle AI World in Singapore last week and it really caught my attention. It sounded simple but the idea behind it is quite powerful. So I thought it’s worth exploring a bit more! Normally, working with data and AI meant one thing, which is, moving data around. We would extract data from databases, send it to external tools or platforms, build machine learning models and then push the results back into the database. But this approach adds complexity, increases costs and introduces security risks. But now, Oracle is changing that model by bringing AI to where the data already is ! The concept of “Bring AI to Data” is straightforward but powerful. Instead of moving large volumes of data across systems, Oracle allows you to run AI and machine learning directly inside the database. This means that data do not have to leave its secure environment. This results faster processing, reduced data duplication, improved security ...

Performance tuning in Oracle Database often focuses on obvious areas like indexes, SQL rewrites etc. But some of the most impactful improvements can come from lesser known techniques. Here are 5 such tuning tricks that can make a real difference in production environments.   Use SQL Plan Baselines to Stabilize Performance Even properly tuned queries in Oracle Database can suddenly degrade when execution plans change due to statistics refreshes or system upgrades. Using SQL Plan Baselines helps maintain stable and efficient execution plans, preventing unexpected performance regressions especially in highly changing workloads. SELECT * FROM DBA_SQL_PLAN_BASELINES; So, don’t just capture baselines, but periodically change them to allow the optimizer to adopt better plans when appropriate. Use Automatic Indexing Automatic Indexing is a useful feature in Oracle Database that can improve performance with minimal effort.  It was introduced in Oracle Database 19c and enhance...