Home › Discussions › Questions & Answers › How to clear the Oracle EBS cache in a script

How to clear the Oracle EBS cache in a script

Avatar photoCustomer Questions & Answers 11 replies

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?

11 replies

  • Support Enginatics

    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.

  • Avatar photoCustomer

    If we run a cache clear, how can we quickly verify the impact on database health and performance metrics afterward?

  • Support Enginatics

    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.

  • Avatar photoCustomer

    If poor performance persists, potentially related to concurrent requests stalling, how can we monitor the environment proactively?

  • Support Enginatics

    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.

  • Avatar photoCustomer

    We are planning a Linux OS upgrade (OL7 to OL8). Does this cache clearing step need special attention during that migration?

  • Support Enginatics

    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.

  • Avatar photoCustomer

    We need a mechanism to integrate these various diagnostic and maintenance SQLs used by the DBA team into one place.

  • Support Enginatics

    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.

  • Avatar photoCustomer

    Can we also monitor the database connections themselves for potential security risks, such as suspicious logins?

  • Support Enginatics

    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.

  • You must be logged in to reply to this post.