Performance

1. Real time script to print change in segment level statistics segment_stats_delta_sql
2. A simple script to print waits in the database now wait_details_10g_sql
3. Top ten sessions in the database. Useful to see if any session in the cluster is causing issues top_ten_sesrank_v3_sql
4. CBC latches to file_id_block_id mapping latch_cbc_to_buf_sql
5. AWR script to print the history of plans for a sql_id awr_xplan_sql
6. Print history of an Event from AWR tables. Modify script with a correct event. awr_system_events_sql
7. To print plan changes for a given sql_id awr_plan_changes_sql
8. To print plan changes for all sql_ids. Useful script after a DB upgrade. awr_plan_changes_all_sql
9. Prints DB CPU usage history from AWR report. Open the output in Excel and graph it visually. awr_dbcpu_sql
10. AWR script to print daily redo rate from AWR data awr_redo_size.sql
11. AWR script to print hourly redo rate from AWR data awr_redo_size_history.sql
12. AWR script to print estimated daily rate if you turn on force logging awr_redo_nologging_size.sql
13. A script to print redo rate using v$archived_log view if you don’t have access to AWR data redo_size_archived_log_sql
14. ASH script to print state of a background process from ASH data. LGWR is the default. ash_lgwr_sql
15. ASH script to print top 20 events, sql_ids at Database level ash_ses_top20_sql
16. ASH script to print top 20 events, sql_ids for a session ashw_top20_sql
17. Real time script to print current library cache locks and pins library_cache_locks_pins_sql
18. A shell script to dissect output of heapdump level 2 heapdump_dissect_ksh
19. A shell script to print freelists from the heapdump of shared pool heapdump_freelists_sh
20. A script to print details about shared pool free lists shared_pool_free_lists_sql
21. A DTrace script to understand an UNIX process. Tested in Solaris. Useful to debug oracle processes. trace_syscall_preempt_size_sh
22. Zip file that goes with redo internals paper redo_internals_scripts.zip