There were interesting situation happened after recreating undo. Most of the requests which have child requests and running more than hour are getting fail with ORA-1555 . When checking the…
Read MoreDear Readers I would like to explain more about the Oracle IoT Cloud services. Will provide continues blogs on this technology. In this block we will explore what is IOT…
Read More1. Overview In this document, we will explore a shell script named sftp_file_transfer.sh that automates the process of transferring files from one server to another. 2. Technologies and…
Read More1. Overview In this document, we will explore how to create a simple yet effective shell script to send email alerts with multiple attachments. 2. Technologies and Tools…
Read MoreTable of Contents Introduction Technologies and Tools Used Steps Conclusion 1. Introduction The Dynamic SQL Generator in Oracle PL/SQL allows you to dynamically construct SQL statements, providing flexibility and reusability…
Read MoreIntroduction: Encountering an issue where the Concurrent Request Report Output from the Oracle Report Manager Homepage dashboard redirects to the DMZ node instead of the primary node can be frustrating.…
Read MoreIntroduction: In Oracle E-Business Suite (EBS) R12.2, encountering BBM (Business Intelligence and Business Process Management) JAR issues can disrupt normal operations. This blog post provides a step-by-step guide to address…
Read MoreIntroduction: Upgrading from Oracle E-Business Suite 11i to R12 or transitioning between 12.x versions is a crucial step for organizations seeking enhanced functionality and improved performance. As part of this…
Read MoreQuery Store The Query Storeis a feature in SQL Server that helps you monitor query performance by capturing a history of queries, plans, and runtime statistics, etc. Benefits of using the Query…
Read MoreMigrating databases from Oracle to Azure SQL can unlock significant benefits, including cost savings, enhanced performance, and access to the full suite of Azure cloud capabilities. However, migration journeys can…
Read More