All public logs

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

• 07:41, 23 October 2022 Jan talk contribs created page BMC Oracle (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...")