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
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
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
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 cat crsstat.sh #!/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
Which one to choose RDS v/s MySQL on EC2 A lot of clients for whom we manage AWS come up with a simple question of which out of “RDS vs EC2” is better for their MySQL database requirements. The answer to this simple question is… Read More
There are two kinds of errors that we might receive in Teradata or in any other database for that matter. One are the error messages that we normally get (like syntax errors etc), all these errors are handled errors i.e. the code of Teradata… Read More
dbscontrol is a utility in Teradata which is helpful in tuning the system level configuration of Teradata. These are normally accessible via the Linux console of Teradata and we should be very careful and sure before making any changes to the same as any wrong… Read More
Secondary Indexes are another way of improving performance of queries hitting a particular table on Teradata. It is highly recommended that you first read about Primary indexes here Secondary index is a way of giving the optimizer an alternate path to data i.e. you can… Read More
Continuation to the Part 3 ORACLE – Physical Standby Database creation – Part 3 Configure the listener and tnsnames to support the database on both nodes Configure listener.ora on both servers to hold entries for both databases ON TEST1 (Primary Database… Read More
