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

Rise of NoSQL databases

Over the last few years we have seen the rise of a new type of databases, known as NoSQL databases that are challenging the dominance of relational databases. Relational databases have dominated the software industry for a long time providing mechanisms to store data persistently, concurrency control, transactions, mostly… Read More

Oracle : Generate Clear output for crs_stat -t

Oracle : Generate Clear output for crs_stat -t  

chmod 755 crsstat.sh   Output :