How to clear the Oracle EBS cache in a script

Customer June 10, 2022 at 3:23 pm

We need to schedule periodic maintenance scripts to clear the Oracle EBS cache as part of routine performance optimization. What is the authoritative method and associated documentation for clearing the Oracle EBS cache in a script for both 12.1 and 12.2 versions?

Viewing 10 reply threads

Author
Replies
- Support June 12, 2022 at 4:40 am
  In Oracle EBS 12.1 and 12.2, the cache is cleared according to documented procedures provided by Oracle. The specific mechanism usually involves calling designated database procedures or executing utility scripts to invalidate and flush the relevant caches, ensuring operational stability.
- Customer June 13, 2022 at 11:47 pm
  If we run a cache clear, how can we quickly verify the impact on database health and performance metrics afterward?
- Support June 14, 2022 at 2:15 pm
  Your DBA team should leverage Blitz Report’s Diagnostic Pack for quick checks. Running the Automatic Workload Repository (AWR) reports before and after the cache clear allows for immediate comparison and analysis of performance changes, even in multitenant databases.
- Customer June 15, 2022 at 12:00 pm
  If poor performance persists, potentially related to concurrent requests stalling, how can we monitor the environment proactively?
- Support June 16, 2022 at 5:54 am
  Utilize the Concurrent Request Monitoring and Alert Reporting tool. This enables immediate identification of requests that are ‘Running longer than x Minutes’ or stuck in a ‘Waiting’ phase, helping diagnose if a non-cleared cache issue or other bottleneck is impacting job execution.
- Customer June 17, 2022 at 10:02 pm
  We are planning a Linux OS upgrade (OL7 to OL8). Does this cache clearing step need special attention during that migration?
- Support June 19, 2022 at 1:47 pm
  While the core database procedures for cache clearing remain the same, any major OS upgrade, like Upgrading an Oracle E-Business Suite server from Oracle Linux 7 to Oracle Linux 8, requires full regression testing and careful execution of all maintenance scripts to ensure compatibility within the new environment. Cache clearing is a standard post-maintenance step.
- Customer June 21, 2022 at 3:34 pm
  We need a mechanism to integrate these various diagnostic and maintenance SQLs used by the DBA team into one place.
- Support June 23, 2022 at 6:12 pm
  Blitz Report is the recommended solution for Simplifying DBA tasks. It allows the DBA to centralize all diagnostic queries (AWR, FND, patch checks) and execute them directly from the EBS Forms interface, improving organization and speed.
- Customer June 25, 2022 at 6:36 am
  Can we also monitor the database connections themselves for potential security risks, such as suspicious logins?
- Support June 25, 2022 at 4:38 pm
  Yes, the DBA toolkit includes reports to Find an IP address and geolocation of EBS clients’ logins. This data can be visualized in Excel using tools like Bing Maps for security monitoring.
Author
Replies