 SCRIPTS FOR RAC
|
gc_traffic_print.sql
|
|
To print Global cache performance metrics for a smaller time window. See my blog for more information.
|
|
View gc_traffic_print.sql
|
|
awrrpt_all_range_gen.sql
|
|
To generate AWR reports from all instances from one script execution. Shows the range of snaps from the instance and accepts begin and end snap_ids.
|
|
View awrrpt_all_range_gen.sql
|
|
awrrpt_all_gen.sql
|
|
To generate AWR reports from all instances from one script execution. Uses latest AWR snap and no input required.
|
|
View awrrpt_all_gen.sql
|
|
gc_event_histogram.sql
|
|
To print Global cache event histograms for the past N seconds. See blog for more details.
|
|
View gc_event_histogram.sql
|
|
sp_gc_traffic_print.sql
|
|
This script prints Global cache traffic information such as CR time/ CUR time/ CR blocks etc. It is very handy in debugging GC performance issues, but no substitute for statspack report.
|
|
View sp_gc_traffic_print.sql
|
|
awr_global_cache.sql
|
|
To print global cache performance for CR and CUR block receive time using AWR base tables. This can be loaded to an excel spreadsheet for easier graphing.
|
|
View awr_global_cache.sql
|
|
sp_global_cache_all.sql
|
|
To pull CR & CUR blocks recv time in to a file. This can be loaded in to excel spreadsheet to graph CR and CUR avg recv time.
|
|
View sp_global_cache_all.sql
|
|
sp_gc_obj.sql
|
|
Print objects causing top global cache CUR block transfers
|
|
View sp_gc_obj.sql
|
|
|
 |
 |
|
