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 »