Articles

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

More Latest News »