All public logs

Combined display of all available logs of Wiki. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).

• 19:54, 14 May 2025 Ebasso talk contribs created page IBM Sterling B2B: Useful Database Queries for Monitoring and Statistics (Created page with "This page documents commonly used SQL queries for gathering communication and processing statistics from IBM Sterling databases (Oracle, DB2, and MS SQL Server). == (Oracle) List Largest Tables and Update Statistics == Checking the largest tables and updating table statistics. select table_name, round((num_rows*avg_row_len)/1048576) tbsize, num_rows, last_analyzed from all_tables where owner='XXXXXXX' and num_rows>0 order by num_rows desc == 1. Communication Ses...")