All About Statistics In Oracle Database (11g & 12c)

1. Backup the current Stats For Database stats: SQL> Exec dbms_stats.export_database_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_database_03282018’); For System stats: SQL> Exec dbms_stats.export_SYSTEM_stats(statown => ‘SYSTEM’, stattab => ‘prod_stat_system_03282018’); For Dictionary stats: SQL> Exec dbms_stats.export_Dictionary_stats(statown => ‘SYSTEM’, stattab => ‘prod_stats_dictionary_03282018’); For Fixed Tables stats: SQL> Exec dbms_stats.export_FIXED_OBJECTS_stats(statown… Read More

Oracle : Rename ASM Disk Label in Oracle 12c (RAC)

Rename Disk Label for reallocating disks from one diskgroup to other diskgroup     Before :    login as    sysasm :   

Wait till rebalnce completes.  

Please perform “ asm scan” command on other nodes which exists in the cluster :  … Read More