BMC Oracle: Revision history

Jump to navigation Jump to search

Diff selection: Mark the radio buttons of the revisions to compare and hit enter or the button at the bottom.
Legend: (cur) = difference with latest revision, (prev) = difference with preceding revision, m = minor edit.

10 December 2024

23 October 2022

  • curprev 07:4107:41, 23 October 2022‎ Jan talk contribs‎ 14,857 bytes +14,857‎ Created page with "Performance tuning of an BMC using Oracle 11 database 1. archive auditlogs 2. identify tables with high number of rows 3. identify high insert/delete tables - clean up - drop indexes 4. shrink tables 5. rebuilding indexes 6. change lob to inline -- Size in MB and num_rows SELECT alt.table_name, ars.viewname, alt.num_rows, round((alt.num_rows*alt.avg_row_len)/(1024*1024)) MB, alt.LAST_ANALYZED FROM all_tables alt LEFT JOIN ARSCHEMA ars ON to_char(ars.schemaid..."
Retrieved from "https://www.janmg.com/wiki/index.php?title=BMC_Oracle"