Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
ERROR : OC4J Configuration issue. <ORACLE_HOME> / oc4j / j2ee / OC4J_DBConsole_ <SERVER> _ <SID> not found. SOLUTION : The passwords of sysman and dbsnmp …
Read More »EMC flash drive as Temp database device
Here is an unusual data warehouse (columnar, not row based) server; I have several very large fact tables, some of them are over 800GB …
Read More »ORA-01552: cannot use system rollback segment for non-system tablespace ‘XXXX’
The problem was that the UNDO table space had several data files in recover mode. SOLUTION : Problematic files are recovered from backup and …
Read More »What is Contained Database and How To Create
We mentioned the Contained Database in our article titled “How To Move Logins To Another Instance (sp_help_revlogin)“. A Contained Database is a type of …
Read More »Bash Script for Backup of Mysql Users & Privileges
Below is a simple script which backup Mysql users & grants into separate sql file. So,if you are taking particular database backup then this …
Read More »How To Improve Database Performance on MongoDB Part 1
This little guide is medium in scope, it is not exhaustive. It just gives you an idea to focus 1 Choose the right storage …
Read More »RDS to RDS Database Refresh-Oracle
This document covers steps involved in refreshing an Oracle database schema where source and target both are AWS RDS databases Prerequisites: RDS Instances …
Read More »How To Move Logins To Another Instance(sp_help_revlogin)
If you do not use a contained database, you must also move your logins when you move the database to another instance. You can …
Read More »Rack Awareness by Sohel Teli
Rack Awareness: Rack awareness is having the knowledge of Cluster topology or more specifically how the different data nodes are distributed across the racks of …
Read More »Bash Script for Mysql General Log Rotation
Below is the simple script for monitoring & auditing mysql general logs.This can be set as per the need(eg. daily,horly).It will help in capturing …
Read More »