RAC specific


Save these scripts to either .sql or .ksh file type. Due to security, these files have .txt extensions.

  1. A real time script to break down Global Cache time in to components gc_traffic_processing_sql
  2. A real time script to print Global Cache performance time gc_traffic_print_sql
  3. A real time script to print change in Event histogram gc_event_histogram_sql
  4. Uses AWR tables to show the history of Global cache performance. Upload to excel and graph. awr_global_cache_sql
  5. Print AWR reports from all nodes for the past AWR snap time awrrpt_all_gen_sql
  6. Print AWR reports from all nodes – accepts a range of snap ids. awrrpt_all_range_gen_sql
  7. Print AWR reports from all nodes – accepts a range of snap ids – html format. awrrpt_all_range_gen_sql
  8. A script associated with the blog entry – to print GES locks RAC_check_locks_ksh
  9. To print GES locks RAC_check_locks_sql