Showing posts with the label funoracleapps

Understanding Histograms in Oracle and How to Manage Them

Understanding Histograms in Oracle and How to Manage Them 1. What is a Histogram? A histo…

Read more

Tracking Table Growth History in Oracle Databases (Single Instance & RAC)

Tracking Table Growth History in Oracle Databases (Single Instance & RAC) This docume…

Read more

Consolidated Oracle Report: Top Tables, LOBs, and Indexes (excluding SYS users)

Consolidated Oracle Report: Top Tables, LOBs, and Indexes (excluding SYS users) -- Top 10…

Read more

How to Call HTTPS APIs in PL/SQL Using UTL_HTTP with Oracle Wallet (HTTPS Enabled)

How to Call HTTPS APIs in PL/SQL Using UTL_HTTP with Oracle Wallet (HTTPS Enabled) Integr…

Read more

Unable to Apply AD/TXK Delta 14 Patch: adgrants.sql Does Not Create EBS_SYSTEM Schema

Unable to Apply AD/TXK Delta 14 Patch: adgrants.sql Does Not Create EBS_SYSTEM Schema Err…

Read more

Shell Script to Delete Archive Log Older than one hour

Shell Script to Delete Archive Log Older than one hour #!/bin/bash # ====================…

Read more

Understanding the Difference Between SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY in Oracle

Understanding the Difference Between SELECT_CATALOG_ROLE and SELECT ANY DICTIONARY in Ora…

Read more

Upgrading to Blobfuse2 from Blobfuse1 Step by Step

Upgrading to Blobfuse2 from Blobfuse1 Step by Step Why Blobfuse2? Blobfuse2 is not merely…

Read more