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 :    NAME ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB PCT_FREE —————————— ——————– ———– —— ———- ———- ———- FRA01 1048576 CONNECTED EXTERN 1024000 517938 50.5798828 DATA01 1048576… 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   cat #!/bin/bash RSC_KEY=$1 QSTAT=-u AWK=/bin/awk # if not available use /usr/bin/awk # Table header:echo “” $AWK \ ‘BEGIN {printf “%-55s %-10s %-18s\n”, “HA Resource”, “Target”, “State”; printf “%-55s %-10s %-18s\n”, “———–“, “——“, “—–“;}’ # Table… Read More

More Latest News »