Abdul Hafeez Kalsekar -- Oracle database tuning case studies

  Result Cache,   can be used to cache query and function results in memory. The cached information is stored in a dedicated area inside the shared pool  where it can be shared by other PL/SQL programs that are performing similar calculations.    The Result Cache is set up using the result_cache_mode initialization parameter with one of these three values: 1.       auto:  The results that need to be stored are settled by the Oracle optimizer 2.       manual:  Cache the results by hinting the statement using the result_cache|no_result_cache hint 3.       force:  All results will be cached At  times we  come across   result cache Contention  or Corruption  issues  which  can be easily fixed by disabling and re-enabling result cache .    "ORA-600 [qesrcro_dol2ro] / result cache corruption"   can be seen in alert log in case of...

SPO pxhcdr.log SET DEF ^ TERM OFF ECHO ON VER OFF SERVEROUT ON SIZE 1000000; REM REM $Header: 1460440.1 pxhcdr.sql 12.1.09 2013/06/13 carlos.sierra mauro.pagano $ REM REM Copyright (c) 2000-2013, Oracle Corporation. All rights reserved. REM REM AUTHOR REM   carlos.sierra@oracle.com REM   mauro.pagano@oracle.com REM REM SCRIPT REM   pxhcdr.sql REM REM DESCRIPTION REM   Parallel Execution Health-Checks and Diagnostics Reports. REM REM   This read-only script performs two functions with regard to REM   system-wide parallel execution: REM     1. Reports on a set of commonly used health-checks. REM     2. Generates a set of diagnostics reports based on PX REM        performance views, PX static views and system tables. REM REM   Since pxhcdr.sql is a read-only script, which installs nothing REM   and updates nothing, it is safe to use on any Oracle database REM...