Yearly Archives: 2025

Angular Performance Playbook : The Ultimate Optimization Guide

INTRODUCTION/ ISSUE  In today’s fast-paced digital world, user expectations are higher than ever — speed, responsiveness, and smooth user experience are non-negotiable. Even the most beautifully designed Angular application will…

Read More

Capture the Entire APEX Page: Full-Page Screenshot

Introduction Taking screenshots is a common need during development, testing, or documentation in Oracle APEX applications. While partial screen captures are easy, capturing a full-page screenshot (including content below the…

Read More

Oracle Autonomous Health Framework Fleet Insights Configuration

Introduction: AHFFI is a function that collects data collected by AHF from multiple servers and  displays it on a single screen. Why we need to do Observe key issues across your fleet-Dashboards allow for in-depth analysis of the root  cause of each issue-If necessary, drill down into specific insight reports to identify  detailed. Support Platform: (OEL) x86_64, (RHEL) x86_64, db 19c or later and ahf 24.9 or later system requirements for ahffi : 4 cores CPU, 16GB RAM, 4GB disk space yum install cronie sudo yum install iproute sudo yum install hostname INSTALLATION STEPS: Download ahffi from link 3043060.1 mos Prerequisite setup Install jdk-24 Install instant client sqlplus 23.4.0 Install instant client basic 23.4.0 Create a user for ahffi on 23ai database create user ahffi identified by ahffi;  grant create session to ahffi;  grant connect, resource to ahffi;  grant create table to ahffi;  grant insert any table to ahffi;  alter user ahffi quota unlimited on users; Download the ahffi file and upload it to the server    …

Read More

Load Data into Snowflake DB Table

Introduction After creating db tables in Snowflake, the next step is to load data into them. Snowflake supports various methods to ingest data from local files, cloud storage, or external…

Read More

 Invalid APPS Database User Credentials in txkPostPDBCreationTasks After PDB Creation in Oracle EBS 12.2

Introduction: When performing a Post-PDB Creation Task in Oracle EBS 12.2, you may encounter the following error while running the txkPostPDBCreationTasks.pl script: FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid…

Read More

Script to enable Unified Auditing at Db level

Please find the below steps to enable the same.   create audit policy audit_all actions all only toplevel; audit policy audit_all by user1,user2,user3; audit policy audit_all by sys,system; CONNECT /…

Read More

Query to check identity columns in a table and enable/disable options.

Please run the below query to get the output. SELECT owner, table_name, column_name, generation_type, identity_options FROM dba_tab_identity_cols ORDER BY owner, table_name;   Generation type is below. GENERATED ALWAYS AS IDENTITY…

Read More

Change MAX_STRING_SIZE in an Oracle 19c Physical Standby Environment

In Oracle Database 19c, the MAX_STRING_SIZE parameter controls the maximum length for VARCHAR2, NVARCHAR2, and RAW columns. By default, it’s set to STANDARD, which limits columns to 4,000 bytes. Setting…

Read More

Cloning a Pluggable Database in Oracle

Within Oracle’s multitenant architecture, cloning a PDB allows you to build a duplicate environment—perfect for testing, patching, or sandboxing—without touching the production system. 1. Setting the Stage: Preparing Your Environment…

Read More

Enhancing Cloud Security with OCI Cloud Guard’s New Threat Recipes

Introduction Oracle Cloud Infrastructure (OCI) introduced new Cloud Guard threat detector recipes to help organizations better identify and respond to evolving cloud security risks. While many enterprises already use Cloud…

Read More