Updated DBA AWR Blitz Reports now work with pluggable databasesBy Alexander Pavlik|November 1st, 2021| With introduction of container databases Oracle changed the way AWR data is stored and accessed. You can read about that in more detail in this article from Franck Pachot. As we used AWR data in our Diagnostic Pack reports we also had to make some [...]
A simpler way to work with Automatic Workload Repository (AWR)By Glen Whelan|April 21st, 2020| Analyzing the AWR Report1 Example Standard Report2 Blitz Report Library3 Running the Blitz Report4 Highlights5 Evaluation of Blitz ReportAnalyzing the AWR Report The Oracle Automatic Workload Repository (AWR) collects and maintains performance statistics for problem detection and self-tuning purposes.The report generated by AWR is [...]
Oracle E-Business Suite – concurrent request monitoring and alert reportingBy Glen Whelan|April 15th, 2020| Concurrent Request Management1 Blitz Report - FND Concurrent Requests2 Blitz Report Output and Scheduling3 Evaluation of Blitz ReportConcurrent Request Management Critical concurrent requests should be monitored at all times to prevent problems in downstream processes. The standard method is to use Oracle Alert and [...]
How to put the Advanced functions into Oracle EBS Supply Chain Planning (ASCP)By Glen Whelan|March 17th, 2020| The Planners Workbench limitations 1 Adding Blitz Report to the Planner Workbench (optional) 2 Launching Blitz Report from the Planner Workbench (PWB) 3 Viewing the Excel report output 4 Launching Blitz Report from the standard menu 5 Summary The Planners Workbench (PWB) is the [...]
How to optimize Order Management form exports in Oracle EBSBy Glen Whelan|March 16th, 2020| Exporting Order Organizer efficiently in Oracle Order Management 1 Adding Blitz Report to the Order Organizer form menu (Optional) 2 Launching Blitz Report from within Order Organizer 3 Viewing the Excel report output 4 Launching Blitz Report from the standard menu (if not executing [...]
