When to Use MongoDB

When to Use MongoDB   Is MongoDB right for your application? That depends on the kind of data you have, and what you want to do with that data. NoSQL databases have risen to the occasion when it comes to unstructured data and the kind… Read More

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 :