track_autoupgrade_copy_progress.sql
This script will be useful for tracking progress of GBS copied to Target system. Need to execute it on Target system.
Year: 2026
refre.sql for multitenant
This will provide prompt with session details.
prepfiles.sh for step by step generating pending statistics files
This script, prepfiles.sh, is a powerful utility for Oracle Database Administrators designed to automate the generation of a comprehensive SQL toolkit for managing and testing database statistics. By reading a list of tables from mtx_tablelist.lst, the script creates a sequenced set of SQL files that handle the entire lifecycle of Pending Statistics. This allows DBAs to gather and validate new…
Read More “prepfiles.sh for step by step generating pending statistics files” »
tracksqltime.sql
This PL/SQL block identifies recently active SQL queries from a specific application server and provides details on their performance and execution plans. Here is a breakdown of what the script does: